在用java连接MySQL时报了Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver这个错误
是在加载类的时候找不到该类,缺少对应的mysql-connector-java的jar包
下载连接:https://dev.mysql.com/downloads/file/?id=477057
我是用的是 mysql-connector-java-8.0.11.jar,导入该包
可能因为版本问题又报错
Exception in thread "main" java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
看提示信息是关于时区什么的错误,
这时在连接的数据库链接后面加上serverTimezone=GMT即可,如jdbc:mysql://114.xxx.xxx.xx:3306/xxxxx?serverTimezone=GMT
此外,会提示Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
这种信息,可能是版本更新了连接驱动,将`com.mysql.jdbc.Driver'改为`com.mysql.cj.jdbc.Driver'就行了