JDBC2023.04.11

最新推荐文章于 2024-05-23 20:16:10 发布

giao211

最新推荐文章于 2024-05-23 20:16:10 发布

阅读量2.1k

点赞数 3

文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/giao211/article/details/130083951

版权

1.JDBC连接数据库的步骤和代码

//1.加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2.获取connection对象
        Connection connection =
                DriverManager.getConnection("jdbc:mysql://localhost/day0410?serverTimezone=UTC", "root", "root");
        //3.获取statement对象
        Statement statement = connection.createStatement();
        //4.执行sql语句
        String sql = "select * from emp";
        //5.返回结果集
        ResultSet resultSet = statement.executeQuery(sql);
        //6.处理结果集
        while (resultSet.next()){
            int id = resultSet.getInt("id");
            String ename = resultSet.getString("ename");
            System.out.println("id->"+id+"\t"+"ename->"+ename);
        }
        //7.释放资源
        resultSet.close();
        statement.close();
        connection.close();