[Java] 解决Mybatis的serverTimezone时区出现问题

• Mybatis serverTimezone时区出现问题
  
  
  
  • 错误信息
    
  • 出现原因
    
  • 解决
    
  
  
• Mybatis 插件碰到的时区问题及用法
  

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: 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.
### The error may exist in com/chun/dao/UserMapper.xml
### The error may involve com.chun.dao.UserMapper.getUserList
### The error occurred while executing a query
### Cause: java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time

&serverTimezone=Asia/Shanghai"  //注意Shanghai是开头大写
或者
&serverTimezone=GMT%2B8