JDBC学习笔记

• JDBC学习记录
• • 使用步骤
  • • 创建连接
    • 增
    • 删
    • 改
    • 查
  • 高级应用
  • • 事务

记录JDBC学习记录。
环境：
数据库：mysql 8.0.23
驱动：

  mysql
  mysql-connector-java
  8.0.23

public class JDBCUtil {
   public static String driverClassName = "com.mysql.cj.jdbc.Driver";
   public static String url = "jdbc:mysql://localhost:3306/testobject?useSSL=false&serverTimezone=UTC";
   public static String userName = "****";
   public static String password = "****";

   
   public static Connection getConnection(){
       Connection connection = null;
       try {
           //1、加载驱动
           Class.forName(driverClassName);
           //2、创建连接
           connection = DriverManager.getConnection(url,userName,password);
       } catch (ClassNotFoundException e) {
           //Class.forName(driverClassName);
           e.printStackTrace();
       } catch (SQLException throwables) {
           //DriverManager.getConnection(url,userName,password);
           throwables.printStackTrace();
       }
       return connection;
   }

   
   public static Statement getStatement(){
       Connection connection = JDBCUtil.getConnection();
       Statement statement = null;
       try {
           statement = connection.createStatement();
       } catch (SQLException throwables) {
           throwables.printStackTrace();
       }

       return statement;
   }
}

public static void originalJdbc(){
       System.out.println( "Hello World!" );
       Statement statement = JDBCUtil.getStatement();
       try {
           ResultSet set = statement.executeQuery("select * from students");
           while (set.next()){
               System.out.println(set.getString("name"));
           }
           set.close();
           statement.close();
       } catch (SQLException throwables) {
           throwables.printStackTrace();
       }
   }