Java - 使用JDBC連接MySql时出現的報錯：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

原因:

輸入中文字型時會出現以上錯誤訊息

解決方法:

需要修改文件:application.properties
位置:src/main/resources/application.properties

修改/加入語法:

useUnicode=true&characterEncoding=UTF-8

打開application.properties

# For MySQL Connection
spring.datasource.url=jdbc:mysql://localhost:3306/sys?serverTimezone=UTC&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.http.encoding.force=true

修改後:

# For MySQL Connection
spring.datasource.url=jdbc:mysql://localhost:3306/sys?serverTimezone=UTC&useSSL=false& useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.http.encoding.force=true