ch16日志

日志文件：/home/du/ch16.log 内容 2024年10月23日星期三 10:31:49

<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@433b0b37]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@433b0b37] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_du WHERE (学生学号 = ?)
==> Parameters: 304(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@433b0b37]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@433b0b37]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@433b0b37]
2024-10-21 17:50:58 [http-nio-9999-exec-6] INFO cn.du.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fd3b84a]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6914a854] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_du WHERE id=?
==> Parameters: admin(String)
2024-10-21 17:50:58 [http-nio-9999-exec-3] INFO cn.du.sr.controller.RoomsController - 分页查找自习室信息，当前页码：1，每页数据量：10 模糊查询，自习室名称：
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52d7b411]
2024-10-21 17:50:58 [http-nio-9999-exec-3] WARN com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor - optimize this sql to a count sql has exception sql:"SELECT id自习室名称 AS 自习室名称自习室信息 AS 自习室信息行数 AS 行数列数 AS 列数总座位数 AS 总座位数最大可用座位数 AS 最大可用座位数 FROM 自习室表_du" exception:
java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1 column 12. Encountered: '33258' (33258)
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@26789337] will be managed by Spring
==> Preparing: SELECT COUNT(*) FROM (SELECT id自习室名称 AS 自习室名称自习室信息 AS 自习室信息行数 AS 行数列数 AS 列数总座位数 AS 总座位数最大可用座位数 AS 最大可用座位数 FROM 自习室表_du) TOTAL
==> Parameters:
<== Columns: id 用户名密码姓名性别出生年月用户身份用户状态
<== Row: admin admin 123456 张三红女 2008-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fd3b84a]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fd3b84a]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fd3b84a]
<== Columns: COUNT(*)
<== Row: 5
<== Total: 1
==> Preparing: SELECT id自习室名称 AS 自习室名称自习室信息 AS 自习室信息行数 AS 行数列数 AS 列数总座位数 AS 总座位数最大可用座位数 AS 最大可用座位数 FROM 自习室表_du LIMIT ?
==> Parameters: 10(Long)
<== Columns: id 自习室名称自习室信息行数列数总座位数最大可用座位数
<== Row: 1 善学楼安静舒适，环境良好光线充足 5 5 25 20
<== Row: 2 躬行楼宽敞明亮，阳光明媚 5 6 30 20
<== Row: 3 文化楼自习室干净整洁空间大安静 5 5 25 20
<== Row: 4 善学楼505 安静明亮 6 5 30 20
<== Row: 5 网络实训室404 安静明亮 6 5 30 20
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52d7b411]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52d7b411]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52d7b411]
2024-10-21 17:50:59 [http-nio-9999-exec-9] INFO cn.du.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@eb3ad3]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@26789337] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_du WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名密码姓名性别出生年月用户身份用户状态
<== Row: admin admin 123456 张三红女 2008-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@eb3ad3]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@eb3ad3]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@eb3ad3]
2024-10-21 17:50:59 [http-nio-9999-exec-1] INFO cn.du.sr.controller.MakeLogsController - 分页查找预约信息，当前页码：1，每页数据量：10 模糊查询，学生ID：，学生name：，自习室名称：
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fdaa556]
2024-10-21 17:50:59 [http-nio-9999-exec-1] WARN com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor - optimize this sql to a count sql has exception sql:"SELECT 学生姓名性别学院名称班级名称自习室名称总座位数行数列数最大可用座位数 id 学生学号预定位置提交时间预约时间登记时间结束时间预约状态自习室编号 FROM 预约记录视图 WHERE 1 = 1 ORDER BY 提交时间 DESC" exception:
java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1 column 8. Encountered: '23398' (23398)
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@26789337] will be managed by Spring
==> Preparing: SELECT COUNT(*) FROM (SELECT 学生姓名性别学院名称班级名称自习室名称总座位数行数列数最大可用座位数 id 学生学号预定位置提交时间预约时间登记时间结束时间预约状态自习室编号 FROM 预约记录视图 WHERE 1 = 1 ORDER BY 提交时间 DESC) TOTAL
==> Parameters:
<== Columns: COUNT(*)
<== Row: 9
<== Total: 1
==> Preparing: SELECT 学生姓名性别学院名称班级名称自习室名称总座位数行数列数最大可用座位数 id 学生学号预定位置提交时间预约时间登记时间结束时间预约状态自习室编号 FROM 预约记录视图 WHERE 1 = 1 ORDER BY 提交时间 DESC LIMIT ?
==> Parameters: 10(Long)
<== Columns: 学生姓名性别学院名称班级名称自习室名称总座位数行数列数最大可用座位数 id 学生学号预定位置提交时间预约时间登记时间结束时间预约状态自习室编号
<== Row: 刘轩女信息工程学院 23数媒技二班善学楼 25 5 5 20 15 222 55 2024-10-12 20:39:31 2024-10-13 null null 0 1
<== Row: 赵辰浩男信息工程学院 23数媒技二班善学楼 25 5 5 20 14 247 33 2024-10-12 16:10:54 2024-10-13 null null 0 1
<== Row: 李超男信息工程学院 23数媒技一班善学楼 25 5 5 20 13 122 23 2024-10-11 15:19:32 2024-10-12 null null 0 1
<== Row: 刘轩女信息工程学院 23数媒技二班文化楼 25 5 5 20 12 222 11 2024-10-10 21:22:00 2024-10-12 null null 0 3
<== Row: 刘轩女信息工程学院 23数媒技二班善学楼 25 5 5 20 11 222 11 2024-10-10 21:21:16 2024-10-11 null null 0 1
<== Row: 杜兆将男信息工程学院 23数媒技一班文化楼 25 5 5 20 10 100 23 2024-10-10 20:35:56 2024-10-12 null null 0 3
<== Row: 杜兆将男信息工程学院 23数媒技一班善学楼 25 5 5 20 9 100 12 2024-10-10 20:32:57 2024-10-11 null null 0 1
<== Row: 刘轩女信息工程学院 23数媒技二班躬行楼 30 5 6 20 2 222 21 2024-10-02 18:10:01 2024-10-03 null null 3 2
<== Row: 刘轩女信息工程学院 23数媒技二班善学楼 25 5 5 20 1 222 21 2024-10-02 18:09:38 2024-10-04 null null 3 1
<== Total: 9
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fdaa556]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fdaa556]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fdaa556]
2024-10-21 20:24:08 [http-nio-9999-exec-4] INFO cn.du.sr.controller.IndexController - 用户登录，用户名：admin，用户密码：123456
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31226454]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_du WHERE (用户名 = ?)
==> Parameters: admin(String)
<== Columns: id 用户名密码姓名性别出生年月用户身份用户状态
<== Row: admin admin 123456 张三红女 2008-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31226454]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31226454]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31226454]
2024-10-21 20:24:08 [http-nio-9999-exec-5] INFO cn.du.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@730d4ae3]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_du WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名密码姓名性别出生年月用户身份用户状态
<== Row: admin admin 123456 张三红女 2008-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@730d4ae3]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@730d4ae3]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@730d4ae3]
2024-10-21 20:24:08 [http-nio-9999-exec-8] INFO cn.du.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39184164]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_du WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名密码姓名性别出生年月用户身份用户状态
<== Row: admin admin 123456 张三红女 2008-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39184164]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39184164]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39184164]
2024-10-21 20:24:08 [http-nio-9999-exec-10] INFO cn.du.sr.controller.StatisticsController - 查询本月每日使用的座位数，当日日期：2024-10-21 20:24:08
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@700f536c]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_du` WHERE (预约状态 = 1 OR 预约状态 = 2) AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
<== Total: 0
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@700f536c]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@700f536c]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@700f536c]
2024-10-21 20:24:08 [http-nio-9999-exec-7] INFO cn.du.sr.controller.StatisticsController - 查询本月每日预约的座位数，当日日期：2024-10-21 20:24:08
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2581533b]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_du` WHERE YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
<== Columns: d total
<== Row: 4 1
<== Row: 3 1
<== Row: 11 2
<== Row: 12 3
<== Row: 13 2
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2581533b]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2581533b]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2581533b]
2024-10-21 20:24:08 [http-nio-9999-exec-6] INFO cn.du.sr.controller.StatisticsController - 查询当日使用和空闲的座位比当日日期：2024-10-21 20:24:08
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT count(*) FROM `预约记录表_du` WHERE 预约状态 = 1 AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) AND DAY(预约时间) = DAY(NOW())
==> Parameters:
2024-10-21 20:24:08 [http-nio-9999-exec-3] INFO cn.du.sr.controller.StatisticsController - 查询目前正常和拉黑的学生人数比当日日期: 2024-10-21 20:24:08
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92]
<== Columns: count(*)
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe] from current transaction
==> Preparing: SELECT sum(总座位数) FROM `自习室表_du`
==> Parameters:
<== Columns: sum(总座位数)
<== Row: 140
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16893efe]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ea8fe1d] will be managed by Spring
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_du WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 0(Integer)
<== Columns: total
<== Row: 11
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_du WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 1(Integer)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15a07e92]
2024-10-21 20:24:35 [http-nio-9999-exec-5] INFO cn.du.sr.controller.IndexController - 用户退出系统并移除登录信息
2024-10-22 10:39:05 [http-nio-9999-exec-7] INFO org.apache.coyote.http11.Http11Processor - Error parsing HTTP request header
Note: further occurrences of HTTP request parsing errors will be logged at DEBUG level.
java.lang.IllegalArgumentException: Invalid character found in method name [0x160x030x010x020x000x010x000x010xfc0x030x030xd40xe2~0xfe0xabO>W<]0x9d0xd60xfb{0xc00xf1AU0xef0xec0xedS-z)0xf50xdc0xe00xca0xda0xaf} ]. HTTP method names must be tokens
at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:407) ~[tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:257) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-embed-core-10.1.30.jar!/:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) [tomcat-embed-core-10.1.30.jar!/:?]
at java.base/java.lang.Thread.run(Thread.java:842) [?:?]

日志文件：/home/du/ch16.log 内容 2024年10月23日 星期三 10:31:49

日志文件：/home/du/ch16.log 内容 2024年10月23日星期三 10:31:49