JDBC学习笔记

JDBC学习记录

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

<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.23</version>
</dependency>

使用步骤

创建连接

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 = "****";

   /**
    * 获取数据库连接
    * @return
    */
   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;
   }

   /**
    * 获取statement
    * @return
    */
   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();
       }
   }

高级应用

事务