日志文件:/home/du/ch10.log 内容 2025年01月18日 星期六 04:00:34
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b7a4e41]
2024-12-26T19:57:22.446+08:00 INFO 294551 --- [ch10] [nio-8081-exec-3] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3f42ca18] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1799513765 wrapping com.mysql.cj.jdbc.ConnectionImpl@7f81323c] 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@3f42ca18]
2024-12-26T19:57:27.230+08:00 INFO 294551 --- [ch10] [nio-8081-exec-6] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3cc5dd1a] was not registered for synchronization because synchronization is not active
2024-12-26T19:57:27.233+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@2c8aab59] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.996078431372549
JDBC Connection [HikariProxyConnection@681745461 wrapping com.mysql.cj.jdbc.ConnectionImpl@7f81323c] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
JDBC Connection [HikariProxyConnection@595970061 wrapping com.mysql.cj.jdbc.ConnectionImpl@1c142765] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_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@3cc5dd1a]
<== 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@2c8aab59]
2024-12-26T19:57:32.360+08:00 INFO 294551 --- [ch10] [nio-8081-exec-7] cn.du.controller.EmpController : 分页査询,参数:25
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@547721b5] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.99609375
JDBC Connection [HikariProxyConnection@1247538400 wrapping com.mysql.cj.jdbc.ConnectionImpl@1c142765] 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(Long) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 12 luzhangke 123456 鹿杖客 1 11.jpg 5 2007-02-01 3 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 13 hebiweng 123456 鹤笔翁 1 12.jpg 5 2008-08-18 3 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 14 fangdongbai 123456 方东白 1 13.jpg 5 2012-11-01 3 2024-09-01 17:15:52 2024-09-01 17:15:52
<== Row: 18 dutongxue 123456 杜同学 1 http://tlias.itheima.com/1.jpg 2 2015-09-18 1 2024-09-15 19:56:11 2024-11-08 21:34:32
<== Row: 24 12 123456 二维 1 https://web-dzj.oss-cn-beijing.aliyuncs.com/486d1ff8-980f-4eab-8336-3b14e43877d4_微信图片_20230204205556.jpg 1 2024-11-17 8 2024-11-08 21:35:28 2024-11-08 21:35:28
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@547721b5]
2024-12-26T19:57:34.582+08:00 INFO 294551 --- [ch10] [nio-8081-exec-8] cn.du.controller.EmpController : 分页査询,参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@38f96d9b] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961089494163424
JDBC Connection [HikariProxyConnection@822290544 wrapping com.mysql.cj.jdbc.ConnectionImpl@1c142765] 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@38f96d9b]
2024-12-26T19:57:38.818+08:00 INFO 294551 --- [ch10] [nio-8081-exec-9] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@30aec04a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1624675543 wrapping com.mysql.cj.jdbc.ConnectionImpl@1c142765] 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@30aec04a]
2025-01-13T16:10:14.034+08:00 INFO 294551 --- [ch10] [nio-8081-exec-3] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6da1d8d6] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@2141388198 wrapping com.mysql.cj.jdbc.ConnectionImpl@77b37f9c] 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@6da1d8d6]
2025-01-13T16:10:14.291+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@644491ca] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961240310077519
JDBC Connection [HikariProxyConnection@1267230012 wrapping com.mysql.cj.jdbc.ConnectionImpl@77b37f9c] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
2025-01-13T16:10:14.294+08:00 INFO 294551 --- [ch10] [nio-8081-exec-4] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f88cac2] 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)
JDBC Connection [HikariProxyConnection@1385887577 wrapping com.mysql.cj.jdbc.ConnectionImpl@13b0c79] will not be managed by Spring
==> Preparing: select * from dept_du
==> Parameters:
<== 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@644491ca]
<== 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@6f88cac2]
2025-01-13T16:10:24.938+08:00 INFO 294551 --- [ch10] [nio-8081-exec-7] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@36e2240a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@592179930 wrapping com.mysql.cj.jdbc.ConnectionImpl@77b37f9c] 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@36e2240a]
2025-01-13T16:10:28.660+08:00 INFO 294551 --- [ch10] [nio-8081-exec-8] cn.du.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78c36800] was not registered for synchronization because synchronization is not active
2025-01-13T16:10:28.662+08:00 INFO 294551 --- [ch10] [nio-8081-exec-9] cn.du.controller.EmpController : 分页査询,参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5f214f7c] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9961389961389961
JDBC Connection [HikariProxyConnection@432764994 wrapping com.mysql.cj.jdbc.ConnectionImpl@13b0c79] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_du
==> Parameters:
JDBC Connection [HikariProxyConnection@1353420736 wrapping com.mysql.cj.jdbc.ConnectionImpl@77b37f9c] 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@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]