日志文件：/home/lxy/ch11.log 内容 2024年12月28日 星期六 05:29:33
2024-12-07T08:36:50.394+08:00 INFO 656 --- [ch11] [nio-8082-exec-6] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-08T08:49:13.362+08:00 INFO 656 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-08T08:49:13.363+08:00 INFO 656 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-09T08:51:07.212+08:00 INFO 656 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-09T08:51:07.213+08:00 INFO 656 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-10T09:19:49.225+08:00 INFO 656 --- [ch11] [nio-8082-exec-9] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-10T09:19:49.228+08:00 INFO 656 --- [ch11] [nio-8082-exec-9] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-13T08:43:59.396+08:00 INFO 656 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-13T08:43:59.419+08:00 INFO 656 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-17T10:04:56.538+08:00 INFO 656 --- [ch11] [io-8082-exec-10] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-17T10:04:56.541+08:00 INFO 656 --- [ch11] [io-8082-exec-10] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-17T10:04:58.108+08:00 INFO 656 --- [ch11] [nio-8082-exec-2] 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@6632cfda] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@2075415250 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] 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@6632cfda]
2024-12-17T10:04:58.182+08:00 INFO 656 --- [ch11] [nio-8082-exec-3] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-17T10:04:58.183+08:00 INFO 656 --- [ch11] [nio-8082-exec-3] 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-12-17T10:05:03.597+08:00 INFO 656 --- [ch11] [nio-8082-exec-4] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-12-17T10:05:03.598+08:00 INFO 656 --- [ch11] [nio-8082-exec-4] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:03.598+08:00 INFO 656 --- [ch11] [nio-8082-exec-4] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@58f71549] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@458677497 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] 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
<== Total: 3
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@58f71549]
2024-12-17T10:05:08.503+08:00 INFO 656 --- [ch11] [nio-8082-exec-5] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-12-17T10:05:08.504+08:00 INFO 656 --- [ch11] [nio-8082-exec-5] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:08.506+08:00 INFO 656 --- [ch11] [nio-8082-exec-5] cn.lxy.controller.DeptController : 新增部门:Dept(id=null name=12 createTime=null updateTime=null)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@54e1d38] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@636022200 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] will not be managed by Spring
==> Preparing: insert into dept_lxy (name create_time update_time) values( ???)
==> Parameters: 12(String) 2024-12-17T10:05:08.510389116(LocalDateTime) 2024-12-17T10:05:08.510399091(LocalDateTime)
<== Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@54e1d38]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3a3cc09f] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1341041981 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] will not be managed by Spring
==> Preparing: insert into operate_log_lxy (operate_user_id operate_user operate_time class_name method_name method_params return_value cost_time) values (? ? ? ? ? ? ? ?);
==> Parameters: 2(Integer) 金庸先生(String) 2024-12-17T10:05:08.510313688(LocalDateTime) cn.lxy.service.impl.DeptServiceImpl(String) add(String) [Dept(id=null name=12 createTime=null updateTime=null)](String) null(String) 18(Long)
<== Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3a3cc09f]
2024-12-17T10:05:08.539+08:00 INFO 656 --- [ch11] [nio-8082-exec-5] cn.lxy.aop.LogAspect : AOP记录操作日志: OperateLog(id=null operateUserId=2 operateUser=金庸先生 operateTime=2024-12-17T10:05:08.510313688 className=cn.lxy.service.impl.DeptServiceImpl methodName=add methodParams=[Dept(id=null name=12 createTime=null updateTime=null)] returnValue=null costTime=18)
2024-12-17T10:05:08.584+08:00 INFO 656 --- [ch11] [nio-8082-exec-6] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-12-17T10:05:08.585+08:00 INFO 656 --- [ch11] [nio-8082-exec-6] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:08.585+08:00 INFO 656 --- [ch11] [nio-8082-exec-6] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1ef380bd] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@345077697 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] 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: 10 12 2024-12-17 10:05:09 2024-12-17 10:05:09
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1ef380bd]
2024-12-17T10:05:11.516+08:00 INFO 656 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/emps
2024-12-17T10:05:11.516+08:00 INFO 656 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/depts
2024-12-17T10:05:11.517+08:00 INFO 656 --- [ch11] [nio-8082-exec-8] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:11.517+08:00 INFO 656 --- [ch11] [nio-8082-exec-7] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:11.517+08:00 INFO 656 --- [ch11] [nio-8082-exec-8] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@691f21a9] was not registered for synchronization because synchronization is not active
2024-12-17T10:05:11.518+08:00 INFO 656 --- [ch11] [nio-8082-exec-7] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c625c7b] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.6666666666666666
JDBC Connection [HikariProxyConnection@1413545577 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
JDBC Connection [HikariProxyConnection@17100918 wrapping com.mysql.cj.jdbc.ConnectionImpl@1ce61b02] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_lxy
==> Parameters:
<== Columns: count(0)
<== 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: 10 12 2024-12-17 10:05:09 2024-12-17 10:05:09
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@691f21a9]
<== 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@1c625c7b]
2024-12-17T10:05:15.794+08:00 INFO 656 --- [ch11] [nio-8082-exec-9] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/emps
2024-12-17T10:05:15.795+08:00 INFO 656 --- [ch11] [nio-8082-exec-9] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:15.795+08:00 INFO 656 --- [ch11] [nio-8082-exec-9] cn.lxy.controller.EmpController : 分页査询，参数:25
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b6b8f91] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.75
JDBC Connection [HikariProxyConnection@501181044 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] 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(Long) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 6 changyuchun 123456 常遇春 1 5.jpg 2 2012-12-05 2 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 7 xiaozhao 123456 小昭 2 6.jpg 3 2013-09-05 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 8 jixiaofu 123456 纪晓芙 2 7.jpg 1 2005-08-01 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b6b8f91]
2024-12-17T10:05:16.401+08:00 INFO 656 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/emps
2024-12-17T10:05:16.402+08:00 INFO 656 --- [ch11] [nio-8082-exec-1] c.lxy.interceptor.LoginCheckInterceptor : 令牌合法 放行
2024-12-17T10:05:16.402+08:00 INFO 656 --- [ch11] [nio-8082-exec-1] cn.lxy.controller.EmpController : 分页査询，参数:35
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12b86ae6] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.8
JDBC Connection [HikariProxyConnection@935684741 wrapping com.mysql.cj.jdbc.ConnectionImpl@a82afc] 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: 10(Long) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 12 luzhangke 123456 鹿杖客 1 11.jpg 5 2007-02-01 3 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 13 hebiweng 123456 鹤笔翁 1 12.jpg 5 2008-08-18 3 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 14 fangdongbai 123456 方东白 1 13.jpg 5 2012-11-01 3 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Row: 18 chenyouliang 123456 陈友谅 1 17.jpg null 2015-03-21 null 2024-09-13 15:50:51 2024-09-13 15:50:51
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12b86ae6]
2024-12-20T09:09:24.395+08:00 INFO 656 --- [ch11] [io-8082-exec-10] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-20T09:09:24.398+08:00 INFO 656 --- [ch11] [io-8082-exec-10] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-21T08:57:48.532+08:00 INFO 656 --- [ch11] [nio-8082-exec-2] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-21T08:57:48.532+08:00 INFO 656 --- [ch11] [nio-8082-exec-2] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息
2024-12-23T08:48:01.679+08:00 INFO 656 --- [ch11] [nio-8082-exec-3] c.lxy.interceptor.LoginCheckInterceptor : 请求的url: http://localhost:8082/index
2024-12-23T08:48:01.681+08:00 INFO 656 --- [ch11] [nio-8082-exec-3] c.lxy.interceptor.LoginCheckInterceptor : 请求头token为空返回未登录的信息