MySQL数据库驱动从5.x到8.0.28后的一些小变动

package com.kuang.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class TestJDBC {
    public static void main(String[] args) throws Exception {
        //配置信息
//        String url = "jdbc:mysql://localhost:3306/jdbc?useSSL=false&serverTimezone=UTC";
        String url = "jdbc:mysql://localhost:3306/jdbc?useSSL=false&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false";
        String username="root";
        String password="admin";
//        1. 加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
//        2. 连接数据库
        Connection connection = DriverManager.getConnection(url, username, password);
//        3. 向数据库发送SQL对象STATEMENT:CRUD
        Statement statement = connection.createStatement();//不安全
//        4.编写sql  jdbc的套路是️死的，sql会变
        String sql = "select * from users";
//        5. 执行SQL 返回一个结果集
        ResultSet rs = statement.executeQuery(sql);
        while (rs.next()){
            System.out.println("id = " + rs.getObject("id"));
            System.out.println("name " + rs.getObject("name"));
            System.out.println("password = " + rs.getObject("password"));
            System.out.println("email = " + rs.getObject("email"));
            System.out.println("birthday = " + rs.getObject("birthday"));
        }
//        6. 关闭连接释放资源  原则 先开后关
        rs.close();
        statement.close();
        connection.close();

    }
}

主要概括为：

1. 使用ClassforName的情况下，驱动变成了：

com.mysql.cj.jdbc.Driver