mybatis框架连接mysql数据库执行查询报错

柔光的暖阳◎ 2022-01-10 07:45 483阅读 0赞

**使用mybatis框架连接mysql数据库执行查询报错，**

### 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/gx/mapper/EmpMapper.xml
    ### The error may involve com.gx.mapper.EmployeeMapper.findAll
    ### The error occurred while executing a query
    ### 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.

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQxMTU2OQ_size_16_color_FFFFFF_t_70]  
出现这种错误具体是什么原因我也不太清楚，**只要在连接数据库 的文件中添加该时区`&&serverTimezone=PRC`就解决了**

![在这里插入图片描述][20190621100255844.png]

简单的查询出来那条数据来，说明包错已经解决了，很神奇吧！！！  
![在这里插入图片描述][20190621100545943.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDQxMTU2OQ_size_16_color_FFFFFF_t_70]: /images/20220109/aa96f7e0253b41bdb236ba2043c5fcbb.png
[20190621100255844.png]: /images/20220109/8ec7bf17f646423c804e8d6b36bd4201.png
[20190621100545943.png]: /images/20220109/f40b2028920f448eaedb423b9fdf3981.png