1.在pom.xml中引用外部库 mysql-connector-java-8.0.12
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
</dependency>
2.更换驱动
(注意:自Mysql 8.0后,驱动名字从com.mysql.jdbc.Driver更改为com.mysql.cj.jdbc.Driver)
url =
"jdbc:mysql://localhost:3306/ [你的数据库名] ?useSSL=false&serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8";
Class.forName("com.mysql.cj.jdbc.Driver");
//注意,mysql8.0需要更换驱动名
connection =DriverManager.getConnection(url," [用户名] "," [密码] ");