日志文件：/home/du/ch10.log 内容 2025年04月19日 星期六 17:03:30
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78c36800]
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5f214f7c]
2025-02-21T04:04:08.050+08:00 INFO 294551 --- [ch10] [nio-8081-exec-5] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2892f6d6] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1811786772 wrapping com.mysql.cj.jdbc.ConnectionImpl@4843b4e2] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2892f6d6]
2025-02-21T04:04:08.445+08:00 INFO 294551 --- [ch10] [io-8081-exec-10] cn.du.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a9f88ce] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961538461538462
JDBC Connection [HikariProxyConnection@1794970435 wrapping com.mysql.cj.jdbc.ConnectionImpl@4843b4e2] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
2025-02-21T04:04:08.447+08:00 INFO 294551 --- [ch10] [nio-8081-exec-3] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@22e316bf] was not registered for synchronization because synchronization is not active
<== Columns: count(0)
<== Row: 10
<== Total: 1
==> Preparing: select * from emp_du LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a9f88ce]
JDBC Connection [HikariProxyConnection@196448910 wrapping com.mysql.cj.jdbc.ConnectionImpl@4b8f273f] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@22e316bf]
2025-03-12T04:03:48.209+08:00 INFO 294551 --- [ch10] [nio-8081-exec-9] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44264ab] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1174996233 wrapping com.mysql.cj.jdbc.ConnectionImpl@72ee796f] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44264ab]
2025-03-12T04:03:48.603+08:00 INFO 294551 --- [ch10] [nio-8081-exec-5] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
2025-03-12T04:03:48.603+08:00 INFO 294551 --- [ch10] [nio-8081-exec-1] cn.du.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@193df753] was not registered for synchronization because synchronization is not active
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d3e745f] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@868505050 wrapping com.mysql.cj.jdbc.ConnectionImpl@72ee796f] will not be managed by Spring
==> Preparing: select * from dept_du
Cache Hit Ratio [SQL_CACHE]: 0.9961685823754789
==> Parameters:
<== Columns: id name create_time update_time
JDBC Connection [HikariProxyConnection@641060062 wrapping com.mysql.cj.jdbc.ConnectionImpl@7c593217] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
==> Parameters:
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@193df753]
<== Columns: count(0)
<== Row: 10
<== Total: 1
==> Preparing: select * from emp_du LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d3e745f]
2025-03-12T07:58:39.214+08:00 INFO 294551 --- [ch10] [nio-8081-exec-6] cn.du.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@549b172d] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961832061068703
JDBC Connection [HikariProxyConnection@1555183879 wrapping com.mysql.cj.jdbc.ConnectionImpl@35b7bd11] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
<== Columns: count(0)
<== Row: 10
<== Total: 1
==> Preparing: select * from emp_du LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@549b172d]
2025-03-12T07:58:40.640+08:00 INFO 294551 --- [ch10] [nio-8081-exec-4] cn.du.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@76d423ee] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961977186311787
JDBC Connection [HikariProxyConnection@1468901532 wrapping com.mysql.cj.jdbc.ConnectionImpl@35b7bd11] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
<== Columns: count(0)
<== Row: 10
<== Total: 1
==> Preparing: select * from emp_du LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@76d423ee]
2025-03-24T16:53:04.056+08:00 INFO 294551 --- [ch10] [nio-8081-exec-2] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@42bf495d] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@98406777 wrapping com.mysql.cj.jdbc.ConnectionImpl@2bfbf745] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@42bf495d]
2025-03-24T16:53:05.432+08:00 INFO 294551 --- [ch10] [nio-8081-exec-5] cn.du.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1822c2e9] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9962121212121212
2025-03-24T16:53:05.434+08:00 INFO 294551 --- [ch10] [nio-8081-exec-1] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@210f9f60] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1859336657 wrapping com.mysql.cj.jdbc.ConnectionImpl@2bfbf745] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
JDBC Connection [HikariProxyConnection@351525084 wrapping com.mysql.cj.jdbc.ConnectionImpl@2489dd98] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== Columns: count(0)
<== Row: 10
<== Total: 1
==> Preparing: select * from emp_du LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id name create_time update_time
<== Row: 1 杜家学工部 2024-09-04 17:26:19 2024-09-04 17:26:19
<== Row: 2 杜氏教研部 2024-09-27 05:29:56 2024-09-27 05:30:03
<== Row: 3 杜氏咨询部 2024-09-01 17:15:39 2024-09-01 17:15:39
<== Row: 8 杜氏就业部 2024-09-04 18:37:15 2024-09-04 18:37:15
<== Row: 12 杜氏人事部 2024-09-26 09:04:52 2024-09-26 09:04:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@210f9f60]
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 4 yangxiao 123456 杨逍 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/aef4b9af-8de9-48cf-8a3c-cd1fe85f7c81_黄渤.jpg 2 2008-05-01 2 2024-09-01 17:15:52 2024-09-21 22:41:08
<== Row: 7 xiaozhao 123456 小昭 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/168332cc-6096-4ad2-8653-b384eb9bb495_黄渤.jpg 3 2013-09-05 1 2024-09-01 17:15:52 2024-10-21 17:53:33
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 11 zhaomin 123456 赵敏 2 10.jpg 1 2013-09-05 1 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1822c2e9]