JDBC连接数据库(idea版)

1.引入依赖：

<dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.28</version>
            </dependency>
        </dependencies>

2.代码编写：

 public static void main(String[] args) throws SQLException {
        Connection concon = null;
        PreparedStatement pstm = null;
        ResultSet resultSet = null;
        String url = "jdbc:mysql://localhost:3306/db06";
        String user = "root";
        String password = "root";
        try {
            //1.注册驱动。
            DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
            //2.获取连接。
            concon = DriverManager.getConnection(url, user, password);
            if (!concon.isClosed()) {
                System.out.println("数据库连接成功！");
            }
            //3.获取操作数据库的预处理对象
            pstm = concon.prepareStatement("select * from t_product");
            //4.执行sql,得到结果集
            resultSet = pstm.executeQuery();
            //5.遍历结果集。
            int i = 0;
            while (resultSet.next()) {
                int id = resultSet.getInt("id");
                String productCode  = resultSet.getString("product_c1ode");
                System.out.println("id" + id);
                System.out.println("product_code" + productCode);
            }
        } catch (SQLException throwables) {
            System.out.println("数据库字段错误！");
        } finally {
            //6.释放资源
            if (resultSet != null) {
                resultSet.close();
            }
            if (pstm != null) {
                pstm.close();
            }
            if (concon != null) {
                concon.close();
            }
        }
    }

点击运行，大功告成！