这些是我在做毕设时遇到的问题及怎样解决：基于SSM的烈士纪念与追思系统的设计与实现(原名纪念烈士网站的设计与实现)

本文链接：https://blog.csdn.net/weixin_55267013/article/details/135591001

1.浏览器的问题。QQ浏览器刚开始能播放视频，但过几天后就不能播放视频了，我认为有可能是她禁止有些js文件的使用（ckplayer.js等），而Microsoft Edge、Google Chrome浏览器可以播放视频。

在命令提示符窗口中从C盘切到其他盘文件夹时，在命令提示符窗口下先回到C盘根目录，然后win+R，把想要进入的那个文件夹目录复制粘贴在win+r上运行，接着在命令提示符上切到对应盘就会进入哪个文件夹目录。

2.修改视频信息时，把日期删了，才可以修改并保存成功，日期不删会报错。
3.上传视频时，Microsoft Edge浏览器有时会遇到因为视频的名称问题而上传不了，Google Chrome浏览器暂时没有这样的问题。上传的视频有可能因为名称问题在本地看不了，网页上传后的能看（进击的巨人）。

4.关于Eclipse的tomcat问题(Server Tomcat v9.0 Server at localhost failed to start问题)
查看对应的web.xml文件，看里面配置的servlet与对应的servlet Java文件是否相适应，若web.xml配置了相应java文件的servlet,而项目中又没有相对应的调用该servlet的文件时，就会出现这个错误，TOMCAT中配置该项目时启动不了，报的错就是这个，而移除该项目时，又可以启动了，从侧面说明项目有问题，解决办法就是查看web.xml文件，当用到servlet时。

5.当项目中有用到servlet时，web.xml如果没配置好时，相关的jsp页面跳转不出来，报404错误，并且该跳转页面会出现大小写混乱的问题，比如，jsp页面的名称的首字母是小写时，而web.xml中配置该用到servlet的文件时的首字母时大写时，当运行时，该文件会报错，而对应的修改网址的jsp页面名称的首字母大小写时又能出来了，功能不影响，但页面展示有问题。

6.tomcat用startup.bat启动时闪退，有可能和jdk有关，原来一直用jdk 13，现在用jdk 17，但是在eclipse中可以启动，没有问题。

7.在创建数据库（mysql）时，要注意表的结构（字段），列入birthday time date创建日期时，会报错，SQL语法有错误，应写成birthday_time date,还有char类型字段max=255.

8.在烈士信息系统管理中，如果想要添加新的烈士信息，先查看现有序号，然后在现有的基础上改变序号为一个新序号（数据库中所没有的序号），这时可以添加烈士信息（重复的，只是序号不同，可以改变序号，姓名，年龄，烈士简介，出生时间，牺牲时间，除了性别不能修改）！更新一会有问题，一会没有问题的，真奇怪！（代码中执行数据库操作的代码顺序有问题，所以才不能更新成功）

9.mysql的版本对应不同的驱动连接器，mysql-connector-java-8.0.18.jar，mysql-connector-java-8.0.29.jar，我的电脑上的MySQL版本是8.0.29，而有的需要链接MySQL数据库的程序需要使用8.0.18版本，否则运行会报错，没有创建一个新的数据库链接服务器。

10.MySQL数据库中，当用到性别这个字段时，刚开始用的是enum类型，但是运行展示在页面上时，会报错，前面字段能出来，enum及enum后其他字段出不来，但是换成char类型时，不会报错！

11.添加功能没有完全成功的原因（性别字段修改不了）是因为MySQL数据库中创建性别字段时，char类型设置小了（原来位4个字符，而female有6个字符），只要把性别字段的char>6个字符时，添加功能（在网页上添加到MySQL数据库中时）完美实现。
11.存储在MySQL数据库中的数据展示在网页上时，如果执行更新功能时，姓名，牺牲时间，烈士简介可以更新（其他三个字段，出生时间，年龄，性别暂时无法更新，数据库抛出异常序号不能重复）。

12.重新配置tomcat时需要重启电脑，否则启动会闪退！

13.HTTP状态 500 - 内部服务器错误
类型异常报告

消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

描述服务器遇到一个意外的情况，阻止它完成请求。

例外情况

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is 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 java.sql.SQLException: 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.)
### The error may exist in com/yx/mapper/MovieMapper.xml
### The error may involve com.yx.dao.MovieMapper.selectSliderMV
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 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.)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

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 java.sql.SQLException: 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.)
### The error may exist in com/yx/mapper/MovieMapper.xml
### The error may involve com.yx.dao.MovieMapper.selectSliderMV
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 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.)
   org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:79)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 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.)
### The error may exist in com/yx/mapper/MovieMapper.xml
### The error may involve com.yx.dao.MovieMapper.selectSliderMV
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 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.)
   org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 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.)
   org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
   org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
   org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
   org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
   org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
   org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
   org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

java.sql.SQLException: 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.)
   org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294)
   org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
   org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
   org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
   org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
   org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
   org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
   org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
   org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
   org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
   org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

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.
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
   com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
   com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
   com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
   com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
   org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
   org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
   org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
   org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)
   org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
   org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
   org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
   org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
   org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
   org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
   org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
   org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
   org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
   org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
根本原因。

com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.
   java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
   java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
   com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
   com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2121)
   com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2145)
   com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310)
   com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967)
   com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
   com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
   com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
   com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
   org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
   org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
   org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
   org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)
   org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
   org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
   org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
   org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
   org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
   org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
   org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
   org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
   org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
   org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
   org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
   jdk.proxy3/jdk.proxy3.$Proxy15.selectList(Unknown Source)
   org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
   org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
   org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
   org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
   jdk.proxy3/jdk.proxy3.$Proxy17.selectSliderMV(Unknown Source)
   com.yx.service.impl.MoiveServiceImpl.getMovieBySliderImage(MoiveServiceImpl.java:49)
   com.yx.controller.MovieController.showIndex(MovieController.java:165)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
   org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
   org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
   org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
   org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
):注意主要问题的全部 stack 信息可以在 server logs 里查看

Apache Tomcat/9.0.80

因为自己在给项目添加功能时，功能实现不了时，导致其他功能也有问题，所有页面出不来！！也就是上面的问题，然后我删除了新添加的代码所有代码，当运行项目或该项目相关页面时，页面出不来，首页也是如此，都是上面的问题。花了一段时间，不断地调试程序，上网查资料，反反复复，最终找出了原因，需要在jdbc.url后的数据库名后加上serverTimezone=CST&，然后该错误就解决了，原来的代码都没有这个东西，但就是因为增加功能时导致原项目也出现了问题，删除了增添的代码，还是一样的问题，起初我以为是tomcat服务器的问题，删了又下，下了又重新配置，原来9.0.26的版本也是这个问题，换成9.0.80的版本，还是这个问题，才确定不是tomcat服务器的问题，进一步确定问题在代码上。刚开始排错时，发现mybatis-config.xml里面的代码爆红，看到错误是没有发现mybatis-3-mapper.dtd这个东西（原项目，一样的代码，没有这个报错），上网查了资料
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"mybatis-3-mapper.dtd">
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
解决这个问题的方法是<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
————————————————
版权声明：本文为CSDN博主「_明月」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/dear_Alice_moon/article/details/73208116

但是还是不能根本性地解决问题，只是该文件不会爆红了，主要的问题依然是上面的问题，原来的代码也是错误的那个！！
然后花了很长一段时间，才把这个解决，我都想放弃了，但还是坚持了下去，才最终解决了问题。最终在jdbc.url后的数据库名后加上serverTimezone=CST&后该问题完美解决，原代码上也没有这句代码，我真的很不理解，在原来的基础上增加功能，发现实现不了，删除相关所有代码后，原项目就出问题了，一样的代码，或者一样的配置，解决问题需要加新代码（原项目不需要新代码就可以运行了），真的奇怪，真的不要随便乱动项目代码，但要勇于尝试创新才能解决问题，虽然会出现一些奇奇怪怪的错误，不过这才是我需要做的！！！

14.通过tomcat上传相关文件时（上传到本地文件夹里面）里面有一句代码是获取当前web服务器目录，因为在ssm项目里那句代码获取不到，所以没有完美运行，而把ssm项目放进tomcat服务器根目录的webapps中时，该功能完美实现，相关文件上传到该项目中的image（可改名称）文件夹中！

15.用tomcat（webapps）starbat.bat启动的项目一直有中文乱码问题，而用eclipse启动时又没有这个问题！！我在浏览器的控制台的源代码里面对比了一下（相同的原文件），一个中文时乱码，一个不是（eclipse启动运行出来的页面）。原文件都没有问题，但是运行出来后在浏览器控制台的源代码里面相同文件是不一样的，一个中文乱码，一个没有，真离谱到底是哪里的问题？

16.使用命令行操作数据库时，要选中相应的数据库操作，否则所有数据库的都会有这个记录（覆盖掉原来所有的数据库，数据库中的数据全部丢失！！！在navicat中的consle界面）。

17.记得一定要所有备份数据（更新的和原来的数据）！！！

18.用到servlet-api.jar编译时有问题，导入的包不存在！！！

19.数据库中字段类型的编码格式问题，如mess字段原来是Gb2312，运行出来以后，页面报错java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'mess' at row 1
经排查是数据库mess字段类型编码格式要改为UTF-8，错误解决！！！

20.页面中文乱码问题！！！（htm页面放在tomcat的webapps中启动startup.bat时运行出来有中文乱码问题，而在eclipse中运行出来没有中文乱码问题），原因是eclipse中htm文件的编码格式是UTF-8，而webapps中htm文件的编码格式是UTF-8 BOM，这样页面才没有问题！！！

21.网站分享功能的实现，因为微信没有对外接口，所以要去微信公众号注册一个账号并发布网站后才能实现，而有对外接口的（QQ、QQ空间等）需要网站发布后才能实现，没有发布过的网站，分享的结果是undefined!!。

22.当项目更换图片或别的相关文件时，要先清除浏览器缓存数据后，在运行，如果还是不行，就要去到该项目在tomcat中运行的根目录中替换掉相关图片和修改代码（项目中的图片也要替换掉），不需要每次都重新启动tomcat和清楚浏览器缓存数据。

23.当网站图片显示不出来时，检查图片路径是否正确！！！

24.java文件编码格式不同（ANSI、UTF-8）会出现乱码！