ssm框架搭建异常

数据库连接不上异常

问题一&＃xff1a;

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown system variable &＃39;query_cache_size&＃39;)

原因解决方法&＃xff1a;

数据库版本与数据库驱动版本对应不上&＃xff0c;首先查询数据库版本&＃xff08;执行SELECT VERSION() 即可得到版本号&＃xff09;&＃xff0c;然后修改pom文件&＃xff08;maven项目&＃xff09;里面数据库驱动mysql-connector-java的版本号&＃xff0c;修改一致即可&＃xff0c;不是maven项目的&＃xff0c;可以网上下载相同版本号的数据库驱动重新导入

问题二&＃xff1a;

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 &＃39;???ú±ê×??±??&＃39; 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.)

原因解决方法&＃xff1a;

找到数据库url配置文件&＃xff0c;修改成下面格式&＃xff08;genox是数据库名称&＃xff0c;主要是加上后面的编码&＃xff0c;时区&＃xff09;&＃xff0c;driver最好写成下面加上cj&＃xff08;mysql某个版本之后开始&＃xff0c;我的是8.0.11&＃xff09;

url&＃61;jdbc:mysql://localhost:3306/genox?useUnicode&＃61;true&characterEncoding&＃61;utf8&serverTimezone&＃61;GMT%2B8&useSSL&＃61;false

driver&＃61;com.mysql.cj.jdbc.Driver

问题三&＃xff1a;

静态资源&＃xff0c;js/css文件总是找不到

原因解决方法&＃xff1a;

系统不能找到这些资源文件&＃xff0c;需要声明&＃xff0c;在web.xml文件中&＃xff0c;web-app标签里面添加以下

default*.css

default*.js