mysql8.0.16jar_MySQL8.0 connector JAR包的下载位置及JDBC配置

MySQL8.0 connector JAR包的下载位置及JDBC配置

下载地址在https://dev.mysql.com/downloads/connector/j/

需要选择操作系统(Select Operating System)

Mysql 8.0 的JDBC配置有所变化

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

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db3?serverTimezone=UTC", "root", "密码");

String sql = "insert into student values("zhangsan", 1356897824)";

Statement stmt = conn.createStatement();

int count = stmt.executeUpdate(sql);

System.out.println(count);

stmt.close();

conn.close();

变化主要在两点, 分别是Class.forName("com.mysql.cj.jdbc.Driver"), 以及获得连接的URL配置DriverManager.getConnection("jdbc:mysql://localhost:3