JDBC的基本操作

oldsweet老甜甜

于 2021-06-14 16:06:50 发布

阅读量194

点赞数

CC 4.0 BY-SA版权

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_45867029/article/details/117906598

 Class.forName("com.mysql.cj.jdbc.Driver"); // 反射加载相对应的驱动类
        String url = "jdbc:mysql://localhost:3306/bzbh"; // 反应sql的url
        String username = "root";
        String password = "Aa010326.";
        // 连接成功，数据库对象 Connection 代表数据库
        Connection connection = DriverManager.getConnection(url,username,password);

        // 执行sql的对象Statement 执行sql的对象
        Statement statement = connection.createStatement();

        // 执行sql
        String sql = "SELECT * FROM  orders";
        final ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            System.out.println("order_num" + resultSet.getObject("order_num"));
        }
        // 连接的关闭
        resultSet.close();
        statement.close();
        connection.close();