SSM坑之 项目数据库连接

SSM项目搭建好之后运行出现

1.Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver ’

这个错误一般是jdbc.properties中的driver配置出错，检查后面是否有多余的空格

2.SSM时jdbc报错
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (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=UTC"

补充：在 JDBC 数据库连接池配置中，编辑 JDBC URL ，添加一个 zeroDateTimeBehavior = convertToNull 的参数。这样 Java 就会把零值日期转换为 null 值。（很容易出错）

这几个错误困扰了两天，找了很多资料才成功，也是功夫不负有心人；
万事开头难，过了这一关，也算是基本将SSM框架打通了