在使用springboot整合MYSQL和JPA 的坑

在使用springboot整合MYSQL和JPA时项目会报

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.

and

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.

一般出现上述两个问题问题不大嘿嘿 你的连接代码应该是

spring.datasource.url = jdbc:mysql://localhost:3306/test

spring.datasource.driverClassName =com.mysql.jdbc.Driver

在新版spring boot 整合MYSQL和JPA时原来的连接会发生报错需要改成

spring.datasource.url = jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.driverClassName =com.mysql.cj.jdbc.Driver

新版的spring boot Driver 需要写成 com.mysql.cj.jdbc.Driver

指定时区

serverTimezone=GMT%2B8

这段配置时指定时区；上面代码中指定的时区时北京东8区。
serverTimezone=UTC UTC代表全球时区与上面的北京东8区差8个小时
也可以设置成其他时区比如上海： serverTimezone=Asia/Shanghai

指定字符集

useUnicode=true&characterEncoding=utf-8

是否要指定字符集 如果指定字符集就必须让useUnicode等于true
characterEncoding指定字符集位utf-8或者gbk