日志文件：/home/wh/ch10.log 内容 2024年12月23日 星期一 10:33:41
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 7 王家就业部 2024-09-06 15:38:12 2024-09-06 15:38:12
<== Row: 8 王家学工部 2024-09-06 15:45:16 2024-09-06 15:45:16
<== Total: 5
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@59e4e85a]
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1726cf19]
2024-10-11T13:57:21.479+08:00 INFO 692110 --- [io-8081-exec-10] cn.wh.controller.EmpController : 新增员工，emp:Emp(id=null username=shaseng password=null name=沙僧 gender=1 image= job=4 entrydate=2024-10-13 deptId=3 createTime=null updateTime=null)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2992402d] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1970932310 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: insert into emp_wh(username name gender image job entrydate dept_id create_time update_time) values( ? ? ? ? ? ? ? ? ?);
==> Parameters: shaseng(String) 沙僧(String) 1(Short) (String) 4(Short) 2024-10-13(LocalDate) 3(Integer) 2024-10-11T13:57:21.479874766(LocalDateTime) 2024-10-11T13:57:21.479878916(LocalDateTime)
<== Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2992402d]
2024-10-11T13:57:21.544+08:00 INFO 692110 --- [nio-8081-exec-2] cn.wh.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7397f27a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@969672256 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7397f27a]
2024-10-11T13:57:21.548+08:00 INFO 692110 --- [nio-8081-exec-2] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:05
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17b9e83b] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1534188692 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 0(Integer) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 wanghao 123456 王老师 1 1.jpg 4 2000-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 2 jinyong 123456 金庸先生 1 https://web-wanghao.oss-cn-beijing.aliyuncs.com/7e4591a5-b5b8-477c-943f-84c4a631ee81_金庸先生.jpg 4 1999-12-31 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 3 zhangwuji 123456 张无忌 2 2.jpg 2 2015-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17b9e83b]
2024-10-11T13:57:31.830+08:00 INFO 692110 --- [nio-8081-exec-1] cn.wh.controller.EmpController : 分页査询，参数:25
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@62eec96a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1824102413 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@62eec96a]
2024-10-11T13:57:31.835+08:00 INFO 692110 --- [nio-8081-exec-1] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:55
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@392cc1c] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@388231325 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 5(Integer) 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-06 14:25:59 2024-09-06 14:25:59
<== Row: 7 xiaozhao 123456 小昭 2 6.jpg 3 2013-09-05 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 8 jixiaofu 123456 纪晓芙 2 7.jpg 1 2005-08-01 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 9 zhouzhiruo 123456 周芷若 2 8.jpg 1 2014-11-09 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 10 dingminjun 123456 丁敏君 2 9.jpg 1 2011-03-11 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@392cc1c]
2024-10-11T13:57:32.194+08:00 INFO 692110 --- [nio-8081-exec-3] cn.wh.controller.EmpController : 分页査询，参数:35
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@176b35c5] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1350255055 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@176b35c5]
2024-10-11T13:57:32.198+08:00 INFO 692110 --- [nio-8081-exec-3] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:105
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f4b107f] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@557897038 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 10(Integer) 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-06 14:25:59 2024-09-06 14:25:59
<== Row: 12 luzhangke 123456 鹿杖客 1 11.jpg 5 2007-02-01 3 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 13 hebiweng 123456 鹤笔翁 1 12.jpg 5 2008-08-18 3 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 14 fangdongbai 123456 方东白 1 13.jpg 5 2012-11-01 3 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 18 chenyouliang 123456 陈友谅 1 17.jpg null 2015-03-21 null 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f4b107f]
2024-10-11T13:57:32.653+08:00 INFO 692110 --- [nio-8081-exec-5] cn.wh.controller.EmpController : 分页査询，参数:45
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12cd4426] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1793095782 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12cd4426]
2024-10-11T13:57:32.656+08:00 INFO 692110 --- [nio-8081-exec-5] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:155
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79c4cb25] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@22043727 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 15(Integer) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 19 whtongxue 123456 王同学 1 http://tlias.itheima.com/1.jpg 1 2015-09-18 1 2024-09-19 11:00:49 2024-09-19 11:00:49
<== Row: 20 zhongli 123456 钟离 1 https://web-wanghao.oss-cn-beijing.aliyuncs.com/29abdd46-a88b-4c98-9af0-3afde9063191_钟离.jpg 2 2024-09-18 1 2024-09-19 19:51:56 2024-09-19 19:51:56
<== Row: 62 wukong 123456 悟空 1 2 2024-10-15 3 2024-10-10 11:43:26 2024-10-10 11:43:26
<== Row: 63 shaseng 123456 沙僧 1 4 2024-10-13 3 2024-10-11 13:57:21 2024-10-11 13:57:21
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79c4cb25]
2024-10-11T13:57:36.731+08:00 INFO 692110 --- [nio-8081-exec-6] cn.wh.controller.EmpController : 根据ID査询员工信息，id:63
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@557f0fab] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@70153078 wrapping com.mysql.cj.jdbc.ConnectionImpl@687933c6] will not be managed by Spring
==> Preparing: select * from emp_wh where id = ?
==> Parameters: 63(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 63 shaseng 123456 沙僧 1 4 2024-10-13 3 2024-10-11 13:57:21 2024-10-11 13:57:21
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@557f0fab]
2024-10-11T14:01:13.769+08:00 INFO 692110 --- [nio-8081-exec-4] cn.wh.controller.EmpController : 根据ID査询员工信息，id:63
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6861df20] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@534593694 wrapping com.mysql.cj.jdbc.ConnectionImpl@7109f903] will not be managed by Spring
==> Preparing: select * from emp_wh where id = ?
==> Parameters: 63(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 63 shaseng 123456 沙僧 1 4 2024-10-13 3 2024-10-11 13:57:21 2024-10-11 13:57:21
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6861df20]
2024-10-11T14:01:18.284+08:00 INFO 692110 --- [nio-8081-exec-7] cn.wh.controller.EmpController : 更新员工信息 :Emp(id=63 username=shaseng password=123456 name=沙僧 gender=2 image= job=4 entrydate=2024-10-13 deptId=3 createTime=2024-10-11T13:57:21 updateTime=2024-10-11T13:57:21)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78b554] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@2103942482 wrapping com.mysql.cj.jdbc.ConnectionImpl@7109f903] will not be managed by Spring
==> Preparing: update emp_wh SET username = ? password = ? name = ? gender =? entrydate =? job =? update_time =? dept_id =? where id =?
==> Parameters: shaseng(String) 123456(String) 沙僧(String) 2(Short) 2024-10-13(LocalDate) 4(Short) 2024-10-11T13:57:21(LocalDateTime) 3(Integer) 63(Integer)
<== Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@78b554]
2024-10-11T14:01:18.360+08:00 INFO 692110 --- [nio-8081-exec-8] cn.wh.controller.EmpController : 分页査询，参数:45
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6805828a] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1212240810 wrapping com.mysql.cj.jdbc.ConnectionImpl@5d49310f] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6805828a]
2024-10-11T14:01:18.367+08:00 INFO 692110 --- [nio-8081-exec-8] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:155
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@627ff1a3] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@551629381 wrapping com.mysql.cj.jdbc.ConnectionImpl@5d49310f] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 15(Integer) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 19 whtongxue 123456 王同学 1 http://tlias.itheima.com/1.jpg 1 2015-09-18 1 2024-09-19 11:00:49 2024-09-19 11:00:49
<== Row: 20 zhongli 123456 钟离 1 https://web-wanghao.oss-cn-beijing.aliyuncs.com/29abdd46-a88b-4c98-9af0-3afde9063191_钟离.jpg 2 2024-09-18 1 2024-09-19 19:51:56 2024-09-19 19:51:56
<== Row: 62 wukong 123456 悟空 1 2 2024-10-15 3 2024-10-10 11:43:26 2024-10-10 11:43:26
<== Row: 63 shaseng 123456 沙僧 2 4 2024-10-13 3 2024-10-11 13:57:21 2024-10-11 13:57:21
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@627ff1a3]
2024-10-11T14:01:20.167+08:00 INFO 692110 --- [nio-8081-exec-9] cn.wh.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1ad6e151] was not registered for synchronization because synchronization is not active
2024-10-11T14:01:20.168+08:00 INFO 692110 --- [io-8081-exec-10] cn.wh.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@472cc3e6] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1120046805 wrapping com.mysql.cj.jdbc.ConnectionImpl@5d49310f] will not be managed by Spring
==> Preparing: select count(*) from emp_wh
==> Parameters:
JDBC Connection [HikariProxyConnection@326817088 wrapping com.mysql.cj.jdbc.ConnectionImpl@170ba621] will not be managed by Spring
==> Preparing: select * from dept_wh
==> Parameters:
<== Columns: count(*)
<== Row: 19
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1ad6e151]
2024-10-11T14:01:20.173+08:00 INFO 692110 --- [nio-8081-exec-9] cn.wh.service.impl.EmpServiceImpl : 分页査询，参数:05
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4197762e] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@691745540 wrapping com.mysql.cj.jdbc.ConnectionImpl@5d49310f] will not be managed by Spring
==> Preparing: select * from emp_wh limit ??
==> Parameters: 0(Integer) 5(Integer)
<== Columns: id name create_time update_time
<== Row: 1 王氏学工部 2024-09-06 14:25:41 2024-09-06 14:25:41
<== Row: 2 王氏教研部 2024-09-29 17:01:17 2024-09-29 17:01:21
<== Row: 3 王氏咨询部 2024-09-06 14:25:41 2024-09-06 14:25:41
<== Row: 7 王家就业部 2024-09-06 15:38:12 2024-09-06 15:38:12
<== Row: 8 王家学工部 2024-09-06 15:45:16 2024-09-06 15:45:16
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@472cc3e6]
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 wanghao 123456 王老师 1 1.jpg 4 2000-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 2 jinyong 123456 金庸先生 1 https://web-wanghao.oss-cn-beijing.aliyuncs.com/7e4591a5-b5b8-477c-943f-84c4a631ee81_金庸先生.jpg 4 1999-12-31 1 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 3 zhangwuji 123456 张无忌 2 2.jpg 2 2015-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 14:25:59 2024-09-06 14:25:59
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4197762e]