日志文件：/home/lyq/ch11.log 内容 2024年12月28日 星期六 06:29:11
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:384)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
2024-11-05T22:44:48.574+08:00 INFO 2977 --- [ch11] [nio-8082-exec-1] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-05T22:44:48.575+08:00 INFO 2977 --- [ch11] [nio-8082-exec-1] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-05T22:53:02.567+08:00 INFO 2977 --- [ch11] [nio-8082-exec-2] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-05T22:53:02.567+08:00 INFO 2977 --- [ch11] [nio-8082-exec-2] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-05T22:53:04.047+08:00 INFO 2977 --- [ch11] [nio-8082-exec-3] cn.lyq.controller.LoginController : 员工登录: Emp(id=null username=jinyong password=123456 name=null gender=null image=null job=null entrydate=null deptId=null createTime=null updateTime=null)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7f6737ee] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1864594556 wrapping com.mysql.cj.jdbc.ConnectionImpl@1fc54e75] will not be managed by Spring
==> Preparing: select * from emp_lyq where username = ? and password = ?
==> Parameters: jinyong(String) 123456(String)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 2 jinyong 123456 金庸 1 1.jpg 4 2000-01-02 2 2024-09-13 16:37:03 2024-09-13 16:37:03
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7f6737ee]
2024-11-05T22:53:04.328+08:00 INFO 2977 --- [ch11] [nio-8082-exec-4] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-05T22:53:04.329+08:00 INFO 2977 --- [ch11] [nio-8082-exec-4] c.lyq.interceptor.LoginCheckInterceptor : 令牌合法 放行
org.springframework.web.servlet.resource.NoResourceFoundException: No static resource index.
at org.springframework.web.servlet.resource.ResourceHttpRequestHandler.handleRequest(ResourceHttpRequestHandler.java:585)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:52)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:384)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
2024-11-05T22:53:08.307+08:00 INFO 2977 --- [ch11] [nio-8082-exec-5] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-11-05T22:53:08.308+08:00 INFO 2977 --- [ch11] [nio-8082-exec-5] c.lyq.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-11-05T22:53:08.308+08:00 INFO 2977 --- [ch11] [nio-8082-exec-5] cn.lyq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1536254c] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@872834844 wrapping com.mysql.cj.jdbc.ConnectionImpl@1fc54e75] will not be managed by Spring
==> Preparing: select * from dept_lyq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 刘氏无事部 2024-10-11 16:58:03 2024-10-11 16:58:03
<== Row: 3 刘氏咨询部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: 4 刘氏就业部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: 5 刘氏人事部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: null 无事部 2024-10-11 16:58:16 2024-10-11 16:58:16
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1536254c]
2024-11-05T22:53:10.367+08:00 INFO 2977 --- [ch11] [nio-8082-exec-6] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts/null
2024-11-05T22:53:10.368+08:00 INFO 2977 --- [ch11] [nio-8082-exec-6] c.lyq.interceptor.LoginCheckInterceptor : 令牌合法 放行
org.springframework.web.method.annotation.MethodArgumentTypeMismatchException: Failed to convert value of type 'java.lang.String' to required type 'java.lang.Integer'; For input string: "null"
at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.convertIfNecessary(AbstractNamedValueMethodArgumentResolver.java:302)
at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:137)
at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122)
at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:224)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:178)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:936)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:596)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:384)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.lang.NumberFormatException: For input string: "null"
at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
at java.base/java.lang.Integer.parseInt(Integer.java:668)
at java.base/java.lang.Integer.valueOf(Integer.java:999)
at org.springframework.util.NumberUtils.parseNumber(NumberUtils.java:203)
at org.springframework.beans.propertyeditors.CustomNumberEditor.setAsText(CustomNumberEditor.java:115)
at org.springframework.beans.TypeConverterDelegate.doConvertTextValue(TypeConverterDelegate.java:439)
at org.springframework.beans.TypeConverterDelegate.doConvertValue(TypeConverterDelegate.java:412)
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:161)
at org.springframework.beans.TypeConverterSupport.convertIfNecessary(TypeConverterSupport.java:80)
at org.springframework.beans.TypeConverterSupport.convertIfNecessary(TypeConverterSupport.java:53)
at org.springframework.validation.DataBinder.convertIfNecessary(DataBinder.java:860)
at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.convertIfNecessary(AbstractNamedValueMethodArgumentResolver.java:294)
... 48 more
2024-11-05T22:53:10.447+08:00 INFO 2977 --- [ch11] [nio-8082-exec-7] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-11-05T22:53:10.448+08:00 INFO 2977 --- [ch11] [nio-8082-exec-7] c.lyq.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-11-05T22:53:10.448+08:00 INFO 2977 --- [ch11] [nio-8082-exec-7] cn.lyq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@70fdf4f9] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@679368801 wrapping com.mysql.cj.jdbc.ConnectionImpl@1fc54e75] will not be managed by Spring
==> Preparing: select * from dept_lyq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 刘氏无事部 2024-10-11 16:58:03 2024-10-11 16:58:03
<== Row: 3 刘氏咨询部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: 4 刘氏就业部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: 5 刘氏人事部 2024-09-13 16:36:54 2024-09-13 16:36:54
<== Row: null 无事部 2024-10-11 16:58:16 2024-10-11 16:58:16
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@70fdf4f9]
2024-11-08T13:38:30.403+08:00 INFO 2977 --- [ch11] [nio-8082-exec-8] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-08T13:38:30.405+08:00 INFO 2977 --- [ch11] [nio-8082-exec-8] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-10T14:13:14.553+08:00 INFO 2977 --- [ch11] [nio-8082-exec-9] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-10T14:13:14.562+08:00 INFO 2977 --- [ch11] [nio-8082-exec-9] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-10T14:13:27.995+08:00 INFO 2977 --- [ch11] [io-8082-exec-10] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-10T14:13:27.995+08:00 INFO 2977 --- [ch11] [io-8082-exec-10] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-12T08:40:40.978+08:00 INFO 2977 --- [ch11] [nio-8082-exec-1] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-12T08:40:40.983+08:00 INFO 2977 --- [ch11] [nio-8082-exec-1] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-18T09:02:38.823+08:00 INFO 2977 --- [ch11] [nio-8082-exec-2] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-18T09:02:38.825+08:00 INFO 2977 --- [ch11] [nio-8082-exec-2] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-18T14:04:07.431+08:00 INFO 2977 --- [ch11] [nio-8082-exec-3] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-18T14:04:07.434+08:00 INFO 2977 --- [ch11] [nio-8082-exec-3] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-11-19T08:37:52.990+08:00 INFO 2977 --- [ch11] [nio-8082-exec-4] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-11-19T08:37:53.010+08:00 INFO 2977 --- [ch11] [nio-8082-exec-4] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-02T19:28:53.075+08:00 INFO 2977 --- [ch11] [nio-8082-exec-5] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-02T19:28:53.092+08:00 INFO 2977 --- [ch11] [nio-8082-exec-5] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-06T11:26:05.957+08:00 INFO 2977 --- [ch11] [nio-8082-exec-6] c.lyq.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-06T11:26:06.005+08:00 INFO 2977 --- [ch11] [nio-8082-exec-6] c.lyq.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息