java连接数据库 JDBC编程

static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; 

static final String DB_URL = "jdbc:mysql://localhost:3306/mytest?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";

static final String USER = "root";

static final String PASS = "183210";

 JDBC编程步骤：

①：加载驱动

 

Class.forName(JDBC_DRIVER);

②：获取数据库连接：

conn = DriverManager.getConnection(DB_URL,USER,PASS);

③执行查询           

System.out.println("数据为：");

            stmt = conn.createStatement();

            String sql;

            sql = "SELECT id, name, url FROM websites";

            //executeQuery()只能执行查询语句，

            ResultSet rs = stmt.executeQuery(sql);

             ⬆️⬆️⬆️

          Resultset是一个查询结果集，在逻辑结构上类似于一个表。

④：输出内容         

// 展开结果集数据库

            while(rs.next()){

                // 通过字段检索

                int id  = rs.getInt("id");

                String name = rs.getString("name");

                String url = rs.getString("url");

   

                // 输出数据

                System.out.print("ID: " + id);

                System.out.print(", 站点名称: " + name);

                System.out.print(", 站点 URL: " + url);

                System.out.print("\n");

            }

⑤：关闭

// 完成后关闭

            rs.close();

            stmt.close();

            conn.close();