日志文件：/home/jjx/ch16.log 内容 2025年01月05日 星期日 07:26:07
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 123(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 222(String)
<== Columns: total
<== Row: 2
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 234(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 247(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 302(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 304(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 黑名单表_jjx WHERE (学生学号 = ?)
==> Parameters: 337(String)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abac22d]
2024-11-08 17:26:28 [http-nio-9999-exec-9] 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 [0x030x000x00/*0xe00x000x000x000x000x00Cookie: ]. 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) [?:?]
2024-11-08 22:42:24 [http-nio-9999-exec-9] INFO cn.jjx.sr.controller.IndexController - 用户登录，用户名：admin， 用户密码：123456
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f4519e4]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_jjx WHERE (用户名 = ?)
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1988-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f4519e4]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f4519e4]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f4519e4]
2024-11-08 22:42:24 [http-nio-9999-exec-4] INFO cn.jjx.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@644c1b5e]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_jjx WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1988-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@644c1b5e]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@644c1b5e]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@644c1b5e]
2024-11-08 22:42:24 [http-nio-9999-exec-5] INFO cn.jjx.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ba3776]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_jjx WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1988-08 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ba3776]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ba3776]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ba3776]
2024-11-08 22:42:24 [http-nio-9999-exec-6] INFO cn.jjx.sr.controller.StatisticsController - 查询本月每日使用的座位数，当日日期：2024-11-08 22:42:24
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46ec4848]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_jjx` 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@46ec4848]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46ec4848]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46ec4848]
2024-11-08 22:42:24 [http-nio-9999-exec-7] INFO cn.jjx.sr.controller.StatisticsController - 查询本月每日预约的座位数，当日日期：2024-11-08 22:42:24
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d1aeff9]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_jjx` WHERE YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
<== Total: 0
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d1aeff9]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d1aeff9]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d1aeff9]
2024-11-08 22:42:24 [http-nio-9999-exec-8] INFO cn.jjx.sr.controller.StatisticsController - 查询当日使用和空闲的座位比 当日日期：2024-11-08 22:42:24
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT count(*) FROM `预约记录表_jjx` WHERE 预约状态 = 1 AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) AND DAY(预约时间) = DAY(NOW())
==> Parameters:
2024-11-08 22:42:24 [http-nio-9999-exec-1] INFO cn.jjx.sr.controller.StatisticsController - 查询目前正常和拉黑的学生人数比 当日日期: 2024-11-08 22:42:24
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099]
<== Columns: count(*)
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f] from current transaction
==> Preparing: SELECT sum(总座位数) FROM `自习室表_jjx`
==> Parameters:
<== Columns: sum(总座位数)
<== Row: 140
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4abdb7f]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@5f4e15ba] will be managed by Spring
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_jjx WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 0(Integer)
<== Columns: total
<== Row: 9
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_jjx WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 1(Integer)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1baba099]
2024-11-09 00:57:06 [http-nio-9999-exec-4] 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 [0x000x000x000x1d0xd00xf20x810xf80x8b0xff0x9a0xf70xd50xef0x940xb60xd10xb40xc00x9f0xec0x950xe60x8f0xe10x870xe80xca0xf00x8b0xf60x8b0xf6...]. 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) [?:?]
2024-11-09 21:29:04 [http-nio-9999-exec-6] 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 [0x030x000x00/*0xe00x000x000x000x000x00Cookie: ]. 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) [?:?]
2024-11-10 18:25:26 [http-nio-9999-exec-8] 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 [0x040x010x00P0x000x000x000x010x00example.com0x00...]. 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) [?:?]