日志文件：/home/lxy/ch10.log 内容 2024年12月28日 星期六 05:03:28
2024-09-27T15:16:44.171+08:00 INFO 10497 --- [ch10] [ main] cn.lxy.Ch10Application : Starting Ch10Application v0.0.1-SNAPSHOT using Java 17.0.12 with PID 10497 (/home/lxy/ch10.jar started by root in /home/lxy)
2024-09-27T15:16:44.182+08:00 INFO 10497 --- [ch10] [ main] cn.lxy.Ch10Application : No active profile set falling back to 1 default profile: "default"
2024-09-27T15:16:46.034+08:00 INFO 10497 --- [ch10] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8081 (http)
2024-09-27T15:16:46.071+08:00 INFO 10497 --- [ch10] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2024-09-27T15:16:46.071+08:00 INFO 10497 --- [ch10] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.30]
2024-09-27T15:16:46.120+08:00 INFO 10497 --- [ch10] [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2024-09-27T15:16:46.122+08:00 INFO 10497 --- [ch10] [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1834 ms
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
2024-09-27T15:16:46.754+08:00 INFO 10497 --- [ch10] [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: class path resource [static/index.html]
------. --. --. --.
| .--. ' ----. ---. ---. | '--' | ---. | | ---. ---. --.--.
| '--' | ' -. | | .-. | | .-. : | .--. | | .-. : | | | .-. | | .-. : | .--'
| | --' \ '-' | ' '-' ' \ --. | | | | \ --. | | | '-' ' \ --. | |
`--' `--`--' .`- / `----' `--' `--' `----' `--' | |-' `----' `--'
`---' `--' is intercepting.
2024-09-27T15:16:47.251+08:00 INFO 10497 --- [ch10] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8081 (http) with context path '/'
2024-09-27T15:16:47.279+08:00 INFO 10497 --- [ch10] [ main] cn.lxy.Ch10Application : Started Ch10Application in 3.817 seconds (process running for 5.316)
2024-09-27T15:18:34.724+08:00 INFO 10497 --- [ch10] [nio-8081-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2024-09-27T15:18:34.724+08:00 INFO 10497 --- [ch10] [nio-8081-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2024-09-27T15:18:34.726+08:00 INFO 10497 --- [ch10] [nio-8081-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 2 ms
2024-09-27T15:18:36.815+08:00 INFO 10497 --- [ch10] [nio-8081-exec-2] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@636c3918] was not registered for synchronization because synchronization is not active
2024-09-27T15:18:36.837+08:00 INFO 10497 --- [ch10] [nio-8081-exec-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2024-09-27T15:18:37.061+08:00 INFO 10497 --- [ch10] [nio-8081-exec-2] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@5ef368d8
2024-09-27T15:18:37.063+08:00 INFO 10497 --- [ch10] [nio-8081-exec-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@63403183 wrapping com.mysql.cj.jdbc.ConnectionImpl@5ef368d8] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 李家学工部 2024-09-13 16:54:26 2024-09-13 16:54:26
<== Row: 2 李氏教研部 2024-09-13 15:50:10 2024-09-13 15:50:10
<== 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@636c3918]
2024-09-27T15:18:38.373+08:00 INFO 10497 --- [ch10] [nio-8081-exec-3] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@436f3e73] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1302906990 wrapping com.mysql.cj.jdbc.ConnectionImpl@5ef368d8] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
2024-09-27T15:18:38.383+08:00 INFO 10497 --- [ch10] [nio-8081-exec-4] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@388f9c08] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.0
<== Columns: id name create_time update_time
<== Row: 1 李家学工部 2024-09-13 16:54:26 2024-09-13 16:54:26
<== Row: 2 李氏教研部 2024-09-13 15:50:10 2024-09-13 15:50:10
<== 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@436f3e73]
JDBC Connection [HikariProxyConnection@1646774988 wrapping com.mysql.cj.jdbc.ConnectionImpl@5ef368d8] 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@388f9c08]
2024-09-27T15:18:41.221+08:00 INFO 10497 --- [ch10] [nio-8081-exec-5] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3359a0fb] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1033787616 wrapping com.mysql.cj.jdbc.ConnectionImpl@5ef368d8] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 李家学工部 2024-09-13 16:54:26 2024-09-13 16:54:26
<== Row: 2 李氏教研部 2024-09-13 15:50:10 2024-09-13 15:50:10
<== 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@3359a0fb]
2024-10-23T17:54:17.874+08:00 INFO 10497 --- [ch10] [nio-8081-exec-6] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@43f711b0] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1858701815 wrapping com.mysql.cj.jdbc.ConnectionImpl@54f8d427] 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@43f711b0]
2024-10-23T17:54:19.669+08:00 INFO 10497 --- [ch10] [nio-8081-exec-9] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3b7a72f3] was not registered for synchronization because synchronization is not active
2024-10-23T17:54:19.671+08:00 INFO 10497 --- [ch10] [io-8081-exec-10] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3fa431c5] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.5
JDBC Connection [HikariProxyConnection@901614572 wrapping com.mysql.cj.jdbc.ConnectionImpl@54f8d427] will not be managed by Spring
==> Preparing: select * from dept_lxy
==> Parameters:
JDBC Connection [HikariProxyConnection@1420598675 wrapping com.mysql.cj.jdbc.ConnectionImpl@558c37ba] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_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@3b7a72f3]
<== 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@3fa431c5]
2024-10-23T17:54:25.793+08:00 INFO 10497 --- [ch10] [nio-8081-exec-7] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@53b0919f] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.6666666666666666
JDBC Connection [HikariProxyConnection@1689519042 wrapping com.mysql.cj.jdbc.ConnectionImpl@54f8d427] 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)
2024-10-23T17:54:25.803+08:00 INFO 10497 --- [ch10] [nio-8081-exec-8] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@742ffee2] was not registered for synchronization because synchronization is not active
<== 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@53b0919f]
JDBC Connection [HikariProxyConnection@1657258293 wrapping com.mysql.cj.jdbc.ConnectionImpl@558c37ba] 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@742ffee2]
2024-10-23T17:54:27.853+08:00 INFO 10497 --- [ch10] [nio-8081-exec-1] cn.lxy.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c092011] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1649342347 wrapping com.mysql.cj.jdbc.ConnectionImpl@54f8d427] 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@4c092011]
2024-10-23T17:56:14.725+08:00 INFO 10497 --- [ch10] [nio-8081-exec-4] cn.lxy.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@41b441fc] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.75
JDBC Connection [HikariProxyConnection@777168153 wrapping com.mysql.cj.jdbc.ConnectionImpl@558c37ba] 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@41b441fc]
2024-10-24T10:17:29.121+08:00 INFO 10497 --- [ch10] [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2024-10-24T10:17:29.123+08:00 INFO 10497 --- [ch10] [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.