JDBC数据库依赖mysql-connector下载地址,导入驱动前需导入依赖
http://mvnrepository.com/artifact/mysql/mysql-connector-java
mysql5及之前的版本使用的是旧版驱动"com.mysql.jdbc.Driver"
mysql6以及之后的版本需要更新到新版驱动,对应的Driver是"com.mysql.cj.jdbc.Driver"
这个类是数据库厂商实现的JDBC一套接口里的一个类,称之为“驱动类”,它的继承树如下所示:
————com.mysql.jdbc.Driver extends com.mysql.cj.jdbc.Driver
————com.mysql.cj.jdbc.Driver extends NonRegisteringDriver
————public class NonRegisteringDriver implements java.sql.Driver
驱动详情见链接:https://blog.csdn.net/flybone7/article/details/84641712
驱动连接数据库时解决警告方法:
-
WARN: Establishing SSL connection without server’s identity verification is not recommended.
在url后面加useSSL=false,有参数用&,无参数用?
-
The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone.
1.打开mysql配置文件my.ini,加入default-time-zone = ‘+8:00’
PS:务必在[mysqld] 之下加 ,否则会出现 unknown variable 'default-time-zone=+8:00’
2.在url中配置加上 ?serverTimezone=GMT%2B8