日志文件：/home/lxy/ch11.log 内容 2024年10月23日 星期三 10:26:46
2024-10-11T17:00:22.433+08:00 INFO 18200 --- [ch11] [nio-8082-exec-5] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/emps
2024-10-11T17:00:22.435+08:00 INFO 18200 --- [ch11] [nio-8082-exec-5] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-10-11T17:00:22.439+08:00 INFO 18200 --- [ch11] [nio-8082-exec-5] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae21b22] was not registered for synchronization because synchronization is not active
2024-10-11T17:00:22.442+08:00 INFO 18200 --- [ch11] [nio-8082-exec-6] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-10-11T17:00:22.443+08:00 INFO 18200 --- [ch11] [nio-8082-exec-6] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-10-11T17:00:22.444+08:00 INFO 18200 --- [ch11] [nio-8082-exec-6] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@bece65d] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.0
JDBC Connection [HikariProxyConnection@86706512 wrapping com.mysql.cj.jdbc.ConnectionImpl@2d524afa] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 李家学工部 2024-10-10 11:09:14 2024-10-10 11:09:14
<== Row: 2 李家教研部 2024-09-13 16:46:00 2024-09-13 16:46:00
<== Row: 3 李氏咨询部 2024-09-13 15:50:10 2024-09-13 15:50:10
<== Row: 6 李家就业部 2024-09-13 16:46:00 2024-09-13 16:46:00
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@bece65d]
JDBC Connection [HikariProxyConnection@1197637925 wrapping com.mysql.cj.jdbc.ConnectionImpl@2d524afa] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_lxy
==> Parameters:
<== Columns: count(0)
<== Row: 17
<== Total: 1
==> Preparing: select * from emp_lxy LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 lixiaoyan 123456 李晓燕 1 1.jpg 4 2000-01-01 2 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 2 jinyong 123456 金庸先生 1 https://web-lxylxy.oss-cn-beijing.aliyuncs.com/cc887c35-ec97-4a71-aa07-964f85d74096_th.jpg 4 1999-12-31 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 3 zhangwuji 123456 张无忌 1 2.jpg 2 2015-01-01 2 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ae21b22]
2024-10-12T09:46:28.446+08:00 INFO 18200 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-10-12T09:46:28.447+08:00 INFO 18200 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-10-17T21:46:46.049+08:00 INFO 18200 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
io.jsonwebtoken.ExpiredJwtException: JWT expired 492387053 milliseconds ago at 2024-10-11T21:00:19.000Z. Current time: 2024-10-17T13:46:46.053Z. Allowed clock skew: 0 milliseconds.
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:682)
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:362)
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:94)
at io.jsonwebtoken.impl.io.AbstractParser.parse(AbstractParser.java:36)
at io.jsonwebtoken.impl.io.AbstractParser.parse(AbstractParser.java:29)
at io.jsonwebtoken.impl.DefaultJwtParser.parseSignedClaims(DefaultJwtParser.java:821)
at cn.lxy.utils.JwtUtils.parseJWT(JwtUtils.java:41)
at cn.lxy.interceptor.LoginCheckInterceptor.preHandle(LoginCheckInterceptor.java:43)
at org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:146)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
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-10-17T21:46:46.055+08:00 INFO 18200 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 解析令牌失败 返回未登录错误信息
2024-10-17T21:46:47.597+08:00 INFO 18200 --- [ch11] [nio-8082-exec-9] cn.lxy.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@2971b647] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1937968115 wrapping com.mysql.cj.jdbc.ConnectionImpl@68078378] will not be managed by Spring
==> Preparing: select * from emp_lxy 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 https://web-lxylxy.oss-cn-beijing.aliyuncs.com/cc887c35-ec97-4a71-aa07-964f85d74096_th.jpg 4 1999-12-31 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2971b647]
2024-10-17T21:46:47.657+08:00 INFO 18200 --- [ch11] [io-8082-exec-10] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-10-17T21:46:47.658+08:00 INFO 18200 --- [ch11] [io-8082-exec-10] c.lxy.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-10-18T17:07:32.024+08:00 INFO 18200 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
io.jsonwebtoken.ExpiredJwtException: JWT expired 26445025 milliseconds ago at 2024-10-18T01:46:47.000Z. Current time: 2024-10-18T09:07:32.025Z. Allowed clock skew: 0 milliseconds.
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:682)
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:362)
at io.jsonwebtoken.impl.DefaultJwtParser.parse(DefaultJwtParser.java:94)
at io.jsonwebtoken.impl.io.AbstractParser.parse(AbstractParser.java:36)
at io.jsonwebtoken.impl.io.AbstractParser.parse(AbstractParser.java:29)
at io.jsonwebtoken.impl.DefaultJwtParser.parseSignedClaims(DefaultJwtParser.java:821)
at cn.lxy.utils.JwtUtils.parseJWT(JwtUtils.java:41)
at cn.lxy.interceptor.LoginCheckInterceptor.preHandle(LoginCheckInterceptor.java:43)
at org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:146)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
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-10-18T17:07:32.026+08:00 INFO 18200 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 解析令牌失败 返回未登录错误信息
2024-10-19T16:32:27.596+08:00 INFO 18200 --- [ch11] [nio-8082-exec-2] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-10-19T16:32:27.598+08:00 INFO 18200 --- [ch11] [nio-8082-exec-2] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息