1、maven项目-----使用jdbc连接数据库demo

1. 创建maven项目
2. 引入mysql依赖包

   <dependency> 
   <groupId>mysql</groupId> 
   <artifactId>mysql-connector-java</artifactId> 
   <version>5.1.32</version>
   </dependency>

   

3、创建数据库及表

4、JDBC连接数据库

import java.sql.*;

/**
*采用JDBC连接数据库
 **/
public class JDBCTest {
    public static void main(String[] args) throws Exception{

        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;

        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");

            //获取连接
            String url = "jdbc:mysql://127.0.0.1:3306/springtest";
            String user = "root";
            String password = "123456";
            connection = DriverManager.getConnection(url, user, password);

            //获取statement preparedStatement
            String sql = "select * from user";
            preparedStatement = connection.prepareStatement(sql);

            // 执行查询
            rs = preparedStatement.executeQuery();

            // 处理结果集
            while (rs.next()) {
                System.out.print(rs.getString("uid")+" ");
                System.out.print(rs.getString("uname")+" ");
                System.out.println(rs.getString("usex"));

            }
        } finally {
            // 关闭连接，释放资源
            if (rs != null) {
                rs.close();
            }
            if (preparedStatement != null) {
                preparedStatement.close();
            }
            if (connection != null) {
                connection.close();
            }
        }
    }
}

运行结果：

1 Tom 男
2 Jany 女
3 Mary 男 

 

 

下一篇继续学习mybatis 实现增删改查CRUD--入门级：https://blog.csdn.net/LOVEYSUXIN/article/details/103464456