日志文件：/home/lhy/ch16.log 内容 2024年10月23日 星期三 10:26:21
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47a2ac59]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47a2ac59]
2024-10-18 14:48:46 [http-nio-9999-exec-3] INFO cn.lhy.sr.controller.StatisticsController - 查询本月每日使用的座位数，当日日期：2024-10-18 14:48:46
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c5e22d8]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@642b4620] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_lhy` WHERE (预约状态 = 1 OR 预约状态 = 2) AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
2024-10-18 14:48:46 [http-nio-9999-exec-8] INFO cn.lhy.sr.controller.StatisticsController - 查询本月每日预约的座位数，当日日期：2024-10-18 14:48:46
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@11817854]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@616ff688] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_lhy` WHERE YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
<== Total: 0
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c5e22d8]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c5e22d8]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c5e22d8]
<== Columns: d total
<== Row: 4 1
<== Row: 3 1
<== Total: 2
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@11817854]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@11817854]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@11817854]
2024-10-18 14:48:46 [http-nio-9999-exec-1] INFO cn.lhy.sr.controller.StatisticsController - 查询目前正常和拉黑的学生人数比 当日日期: 2024-10-18 14:48:46
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@616ff688] will be managed by Spring
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_lhy WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 0(Integer)
<== Columns: total
<== Row: 9
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_lhy WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 1(Integer)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4df5222f]
2024-10-18 15:03:37 [http-nio-9999-exec-7] INFO cn.lhy.sr.controller.IndexController - 用户登录，用户名：admin， 用户密码：123456
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@569963a9]
2024-10-18 15:03:37 [http-nio-9999-exec-7] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. jdbcUrl : jdbc:mysql://47.121.213.4:3306/self_study_rooms?zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 jdbcUrl : jdbc:mysql://47.121.213.4:3306/self_study_rooms?zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 lastPacketReceivedIdleMillis : 890882
2024-10-18 15:03:37 [http-nio-9999-exec-7] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. jdbcUrl : jdbc:mysql://47.121.213.4:3306/self_study_rooms?zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 jdbcUrl : jdbc:mysql://47.121.213.4:3306/self_study_rooms?zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8 lastPacketReceivedIdleMillis : 890913
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_lhy WHERE (用户名 = ?)
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1980-02 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@569963a9]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@569963a9]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@569963a9]
2024-10-18 15:03:37 [http-nio-9999-exec-6] INFO cn.lhy.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6602af07]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_lhy WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1980-02 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6602af07]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6602af07]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6602af07]
2024-10-18 15:03:37 [http-nio-9999-exec-3] INFO cn.lhy.sr.controller.IndexController - 依据登陆标识获取用户信息
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31026b7c]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT id用户名 AS 用户名密码 AS 密码姓名 AS 姓名性别 AS 性别出生年月 AS 出生年月用户身份 AS 用户身份用户状态 AS 用户状态 FROM 用户表_lhy WHERE id=?
==> Parameters: admin(String)
<== Columns: id 用户名 密码 姓名 性别 出生年月 用户身份 用户状态
<== Row: admin admin 123456 张三丰 男 1980-02 0 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31026b7c]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31026b7c]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31026b7c]
2024-10-18 15:03:37 [http-nio-9999-exec-8] INFO cn.lhy.sr.controller.StatisticsController - 查询本月每日使用的座位数，当日日期：2024-10-18 15:03:37
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@233f4d69]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_lhy` WHERE (预约状态 = 1 OR 预约状态 = 2) AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
2024-10-18 15:03:37 [http-nio-9999-exec-1] INFO cn.lhy.sr.controller.StatisticsController - 查询本月每日预约的座位数，当日日期：2024-10-18 15:03:37
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@725d746f]
<== Total: 0
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@233f4d69]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@233f4d69]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@233f4d69]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT DAY(预约时间) d count(*) total FROM `预约记录表_lhy` WHERE YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) GROUP BY DAY(预约时间)
==> Parameters:
2024-10-18 15:03:37 [http-nio-9999-exec-10] INFO cn.lhy.sr.controller.StatisticsController - 查询当日使用和空闲的座位比 当日日期：2024-10-18 15:03:37
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b]
2024-10-18 15:03:37 [http-nio-9999-exec-9] INFO cn.lhy.sr.controller.StatisticsController - 查询目前正常和拉黑的学生人数比 当日日期: 2024-10-18 15:03:37
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1]
<== Columns: d total
<== Row: 4 1
<== Row: 3 1
<== Total: 2
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@725d746f]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@725d746f]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@725d746f]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT count(*) FROM `预约记录表_lhy` WHERE 预约状态 = 1 AND YEAR(预约时间) = YEAR(NOW()) AND MONTH(预约时间) = MONTH(NOW()) AND DAY(预约时间) = DAY(NOW())
==> Parameters:
<== Columns: count(*)
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b] from current transaction
==> Preparing: SELECT sum(总座位数) FROM `自习室表_lhy`
==> Parameters:
<== Columns: sum(总座位数)
<== Row: 140
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@259ff39b]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@77612adf] will be managed by Spring
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_lhy WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 0(Integer)
<== Columns: total
<== Row: 9
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1]
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1] from current transaction
==> Preparing: SELECT COUNT( * ) AS total FROM 用户表_lhy WHERE (用户身份 = ? AND 用户状态 = ?)
==> Parameters: 2(Integer) 1(Integer)
<== Columns: total
<== Row: 0
<== Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@681844a1]
2024-10-18 15:03:41 [http-nio-9999-exec-5] INFO cn.lhy.sr.controller.IndexController - 用户退出系统并移除登录信息
2024-10-18 15:05:21 [http-nio-9999-exec-8] INFO cn.lhy.sr.controller.IndexController - 依据登陆标识获取用户信息
java.lang.NullPointerException
2024-10-18 15:05:22 [http-nio-9999-exec-1] INFO cn.lhy.sr.controller.IndexController - 依据登陆标识获取用户信息
java.lang.NullPointerException
2024-10-19 15:50:10 [http-nio-9999-exec-3] 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 [0x050x010x00...]. 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-10-20 16:04:54 [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 [0x160x030x010x000xee0x010x000x000xea0x030x030xb80x050xd19(0xcf0x820x920x0fI0xcaP0xf0wK10xfc0xe10xa0{B!0xc40xf2{0xe30xfb0xcf0xfb0x8f0x050x0e ]. 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-10-21 16:39:31 [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 [0x160x030x010x000xee0x010x000x000xea0x030x03I0x060xb20xf90xbc0x99i0xc0Y0xfb0xf80xbae-0x83Ud]0x0e0x8d0xb7b80xb4g0xc60xdd9dZ8f ]. 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-10-22 16:54:24 [http-nio-9999-exec-1] 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) [?:?]