简单JDBC操作

JDBC基本操作步骤

步骤总结

1. 加载驱动

   Class.forName("com.mysql.jdbc.Driver");
   

2. 连接数据库DriverManager

   String url = "jdbc:mysql://localhost:3306/数据库名?userUnicode=true&characterEncoding=utf8&userSSL=true"
   String username = "root";
   String password = "123456"
   Connection connection = DriverManager.getConnection(url,username,password);
   
   mysql8 + useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
   

3. 获得执行SQL的对象 Statement

   Statement statement = connection.createStatement();
   

4. 获得返回的结果集

   例：
   String sql = "Select * from users";
   ResultSet resultSet = statement.executeQuery(sql);
   

5. 释放连接

   connection.close();
   statement.close();
   resultSet.close();