日志文件：/home/zwc/photobooking.log 内容 2025年07月04日 星期五 19:05:40
<== Row: 9 2025-04-29 19:40:04 亚克力悬浮相框（12寸） 1 /upload/images/product/3.jpg <> 未来视觉 189.00 200 2025-03-10
<== Row: 10 2025-04-29 19:40:04 无痕挂画系统套装 1 /upload/images/product/4.jpg <> GalleryPro 680.00 50 2025-03-15
<== Row: 11 2025-04-29 19:40:04 手工雕刻木质相框（10寸） 1 /upload/images/product/5.jpg <> 匠人工房 880.00 30 2025-03-20
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c3c0d5c]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c3c0d5c]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c3c0d5c]
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b346bc9]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@2d3532f5] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM peripheral_product WHERE 1 = 1 AND product_type_id = ?
==> Parameters: 3(Long)
<== Columns: total
<== Row: 5
<== Total: 1
==> Preparing: SELECT product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date FROM peripheral_product WHERE 1=1 AND product_type_id = ? LIMIT ?
==> Parameters: 3(Long) 1000(Long)
<== Columns: product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date
<== Row: 17 2025-04-29 19:40:04 全画幅相机防潮箱 3 /upload/images/product/11.jpg <> DryTech 580.00 120 2025-05-01
<== Row: 18 2025-04-29 19:40:04 碳纤维三脚架套装 3 /upload/images/product/12.jpg <> 轻摄 1280.00 60 2025-05-05
<== Row: 19 2025-04-29 19:40:04 专业镜头清洁笔 3 /upload/images/product/13.jpg <> LensCare 89.00 500 2025-05-10
<== Row: 20 2025-04-29 19:40:04 相机快拆背带系统 3 /upload/images/product/14.jpg <> 快摄 199.00 300 2025-05-15
<== Row: 21 2025-04-29 19:40:04 多功能SD卡收纳盒 3 /upload/images/product/15.jpg <> DataGuard 129.00 400 2025-05-20
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b346bc9]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b346bc9]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b346bc9]
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@75ad7103]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@2d3532f5] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM peripheral_product WHERE 1 = 1 AND product_type_id = ?
==> Parameters: 4(Long)
<== Columns: total
<== Row: 5
<== Total: 1
==> Preparing: SELECT product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date FROM peripheral_product WHERE 1=1 AND product_type_id = ? LIMIT ?
==> Parameters: 4(Long) 1000(Long)
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3d678619]
<== Columns: product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date
<== Row: 22 2025-04-29 19:40:04 摄影师多功能马甲 4 /upload/images/product/16.jpg <> 摄界 420.00 150 2025-06-01
<== Row: 23 2025-04-29 19:40:04 复古摄影师围裙 4 /upload/images/product/17.jpg <> 暗房记忆 280.00 200 2025-06-05
<== Row: 24 2025-04-29 19:40:04 户外拍摄防蚊裤 4 /upload/images/product/18.jpg <> 野摄 199.00 300 2025-06-10
<== Row: 25 2025-04-29 19:40:04 模特用丝绸拍摄袍 4 /upload/images/product/19.jpg <> 丝路 680.00 80 2025-06-15
<== Row: 26 2025-04-29 19:40:04 防泼水相机背包罩 4 /upload/images/product/20.jpg <> 雨摄 149.00 400 2025-06-20
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@75ad7103]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@75ad7103]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@75ad7103]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@2d3532f5] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM peripheral_product WHERE 1 = 1 AND product_type_id = ?
==> Parameters: 5(Long)
<== Columns: total
<== Row: 5
<== Total: 1
==> Preparing: SELECT product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date FROM peripheral_product WHERE 1=1 AND product_type_id = ? LIMIT ?
==> Parameters: 5(Long) 1000(Long)
<== Columns: product_id create_time product_name product_type_id product_url product_summary manufacturer price stock availability_date
<== Row: 27 2025-04-29 19:40:04 限量摄影艺术微喷 5 /upload/images/product/21.jpg <> ART+ 2500.00 50 2025-07-01
<== Row: 28 2025-04-29 19:40:04 城市光影明信片集 5 /upload/images/product/22.jpg <> 城市之眼 120.00 500 2025-07-05
<== Row: 29 2025-04-29 19:40:04 摄影诗集《光之语》 5 /upload/images/product/23.jpg <> 纸间光影 360.00 200 2025-07-10
<== Row: 30 2025-04-29 19:40:04 可穿戴摄影胸针 5 /upload/images/product/24.jpg <> 微摄界 480.00 100 2025-07-15
<== Row: 31 2025-04-29 19:40:04 摄影主题香薰蜡烛 5 /upload/images/product/25.jpg <> 暗香 199.00 300 2025-07-20
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3d678619]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3d678619]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3d678619]
2025-07-04 15:22:33 [http-nio-9999-exec-10] INFO com.zwc.pb.controller.UserController - 分页查找用户信息，当前页码：1，每页数据量：100 模糊查询，账号：null，姓名：null，性别：null，手机号：null，邮箱：null，用户类型：1
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44080aa0]
2025-07-04 15:22:33 [http-nio-9999-exec-1] INFO com.zwc.pb.controller.ProductInfoController - pageProductInfo: current=1 size=100 productName=null uploadDate=null photographerId=null
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37284ffe]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@2d3532f5] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM user WHERE 1 = 1 AND user_type = ?
==> Parameters: 1(Integer)
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@37ebf3f6] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM product_info WHERE 1 = 1
==> Parameters:
<== Columns: total
<== Row: 11
<== Total: 1
==> Preparing: SELECT user_id create_time user_account user_name gender user_email user_phone user_url user_type FROM user WHERE 1=1 AND user_type = ? LIMIT ?
==> Parameters: 1(Integer) 100(Long)
<== Columns: total
<== Row: 20
<== Total: 1
==> Preparing: SELECT id create_time product_name product_image upload_date photographer_id FROM product_info WHERE 1=1 LIMIT ?
==> Parameters: 100(Long)
<== Columns: user_id create_time user_account user_name gender user_email user_phone user_url user_type
<== Row: 1001 2025-05-02 21:58:39 photo1 张伟 男 zhangwei@photostudio.com 13800010001 /upload/images/user/1.jpg 1
<== Row: 1002 2025-05-02 21:58:41 photo2 李娜 女 lina@photostudio.com 13800020002 /upload/images/user/2.jpg 1
<== Row: 1003 2025-05-02 21:58:44 photo3 王强 男 wangqiang@photostudio.com 13800030003 /upload/images/user/3.jpg 1
<== Row: 1004 2025-05-02 21:58:50 photo4 陈静 女 chenjing@photostudio.com 13800040004 /upload/images/user/4.jpg 1
<== Row: 1005 2025-05-02 21:58:53 photo5 刘洋 男 liuyang@photostudio.com 13800050005 /upload/images/user/5.jpg 1
<== Row: 1006 2025-05-02 21:58:55 photo6 赵敏 女 zhaomin@photostudio.com 13800060006 /upload/images/user/6.jpg 1
<== Row: 1007 2025-05-02 21:58:58 photo7 孙浩 男 sunhao@photostudio.com 13800070007 /upload/images/user/7.jpg 1
<== Row: 1008 2025-05-02 21:59:02 photo8 周婷 女 zhouting@photostudio.com 13800080008 /upload/images/user/8.jpg 1
<== Row: 1009 2025-05-02 21:59:05 photo9 吴磊 男 wulei@photostudio.com 13800090009 /upload/images/user/9.jpg 1
<== Row: 1010 2025-05-02 21:59:08 photo10 徐丽 女 xuli@photostudio.com 13800100010 /upload/images/user/10.jpg 1
<== Row: 1941027541546438658 2025-07-04 14:53:23 刘昊岩爸爸 刘昊岩爸爸 其他 1355923154@qq.com 18503589882 null 1
<== Total: 11
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44080aa0]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44080aa0]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@44080aa0]
<== Columns: id create_time product_name product_image upload_date photographer_id
<== Row: 6 2025-04-29 19:34:55 暮光之城婚礼 /upload/images/productInfo/1.jpg 2025-03-06 1001
<== Row: 7 2025-04-29 19:34:55 法式庄园复古婚纱 /upload/images/productInfo/2.jpg 2025-04-22 1001
<== Row: 8 2025-04-29 19:34:55 新生儿天使之眠 /upload/images/productInfo/3.jpg 2025-03-12 1003
<== Row: 9 2025-04-29 19:34:55 祖孙三代水墨画 /upload/images/productInfo/4.jpg 2025-05-18 1003
<== Row: 10 2025-04-29 19:34:55 CEO权力肖像 /upload/images/productInfo/5.jpg 2025-03-22 1005
<== Row: 11 2025-04-29 19:34:55 直播带货黄金时刻 /upload/images/productInfo/6.jpg 2025-05-03 1005
<== Row: 12 2025-04-29 19:34:55 赛博霓虹之夜 /upload/images/productInfo/7.jpg 2025-04-03 1007
<== Row: 13 2025-04-29 19:34:55 黑白情绪迷宫 /upload/images/productInfo/8.jpg 2025-05-07 1007
<== Row: 14 2025-04-29 19:34:55 布达拉宫朝圣者 /upload/images/productInfo/9.jpg 2025-06-12 1009
<== Row: 15 2025-04-29 19:34:55 草原马蹄印 /upload/images/productInfo/10.jpg 2025-07-03 1009
<== Row: 16 2025-04-29 19:34:55 轻纱舞动晚宴 /upload/images/productInfo/11.jpg 2025-03-08 1002
<== Row: 17 2025-04-29 19:34:55 都市天际线婚戒 /upload/images/productInfo/12.jpg 2025-04-20 1002
<== Row: 18 2025-04-29 19:34:55 童趣泡泡乐园 /upload/images/productInfo/13.jpg 2025-05-17 1004
<== Row: 19 2025-04-29 19:34:55 汉服全家福 /upload/images/productInfo/14.jpg 2025-06-22 1004
<== Row: 20 2025-04-29 19:34:55 极简产品美学 /upload/images/productInfo/15.jpg 2025-03-27 1006
<== Row: 21 2025-04-29 19:34:55 火锅品牌热力 /upload/images/productInfo/16.jpg 2025-05-26 1006
<== Row: 22 2025-04-29 19:34:55 文艺复兴少女 /upload/images/productInfo/17.jpg 2025-04-07 1008
<== Row: 23 2025-04-29 19:34:55 大唐夜宴 /upload/images/productInfo/18.jpg 2025-06-03 1008
<== Row: 24 2025-04-29 19:34:55 北海道雪之恋曲 /upload/images/productInfo/19.jpg 2025-06-07 1010
<== Row: 25 2025-04-29 19:34:55 游艇日落剪影 /upload/images/productInfo/20.jpg 2025-06-25 1010
<== Total: 20
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37284ffe]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37284ffe]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37284ffe]
2025-07-04 15:22:34 [http-nio-9999-exec-6] INFO com.zwc.pb.controller.CategoryController - 分页查找摄影套餐分类，当前页码: 1 每页数据量100 分类名称null
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17703d1a]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@37ebf3f6] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM category WHERE 1 = 1
==> Parameters:
<== Columns: total
<== Row: 5
<== Total: 1
==> Preparing: SELECT * FROM category WHERE 1=1 LIMIT ?
==> Parameters: 100(Long)
<== Columns: category_id create_time category
<== Row: 1 2025-04-29 19:01:23 婚礼摄影
<== Row: 2 2025-04-29 19:01:23 家庭亲子
<== Row: 3 2025-04-29 19:01:23 商业形象
<== Row: 4 2025-04-29 19:01:23 艺术人像
<== Row: 5 2025-04-29 19:01:23 旅行纪实
<== Total: 5
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17703d1a]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17703d1a]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17703d1a]
2025-07-04 15:22:34 [http-nio-9999-exec-3] INFO com.zwc.pb.controller.PhotographyPackageController - 分页查找，当前页码：1，每页数据量：100 模糊查询，套餐ID：null，套餐名字：null，类别ID：null，摄影师ID：null
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@80fde22]
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@37ebf3f6] will be managed by Spring
==> Preparing: SELECT COUNT(*) AS total FROM photography_package WHERE 1 = 1
==> Parameters:
<== Columns: total
<== Row: 20
<== Total: 1
==> Preparing: SELECT package_id create_time package_name package_image category_id package_summary shooting_location package_details price notes release_date photographer_id FROM photography_package WHERE 1=1 LIMIT ?
==> Parameters: 100(Long)
<== Columns: package_id create_time package_name package_image category_id package_summary shooting_location package_details price notes release_date photographer_id
<== Row: 1 2025-04-29 19:07:26 经典婚礼全日跟拍 /upload/images/package/1.jpg 1 <> 北京市朝阳区 <> 8888.00 需提前30天预约 2025-03-01 1001
<== Row: 2 2025-04-29 19:07:26 轻奢婚宴晚宴拍摄 /upload/images/package/2.jpg 1 <> 上海市浦东新区 <> 5800.00 含夜景灯光布置 2025-03-05 1002
<== Row: 3 2025-04-29 19:07:26 新生儿成长记录套餐 /upload/images/package/3.jpg 2 <> 杭州市西湖区 <> 6600.00 赠送胎毛纪念盒 2025-03-10 1003
<== Row: 4 2025-04-29 19:07:26 全家福新年特辑 /upload/images/package/4.jpg 2 <> 广州市天河区 <> 3200.00 需自备妆发 2025-03-15 1004
<== Row: 5 2025-04-29 19:07:26 企业高管形象照 /upload/images/package/5.jpg 3 <> 深圳市福田区 <> 4500.00 工作日拍摄享9折 2025-03-20 1005
<== Row: 6 2025-04-29 19:07:26 电商产品白底图拍摄 /upload/images/package/6.jpg 3 <> 义务市商贸城 <> 980.00 每增加1件+15元 2025-03-25 1006
<== Row: 7 2025-04-29 19:07:26 赛博朋克风格创作 /upload/images/package/7.jpg 4 <> 成都东郊记忆 <> 6800.00 需提前试妆 2025-04-01 1007
<== Row: 8 2025-04-29 19:07:26 文艺复兴油画风 /upload/images/package/8.jpg 4 <> 北京798艺术区 <> 8800.00 拍摄周期3天 2025-04-05 1008
<== Row: 9 2025-04-29 19:07:26 西藏人文旅拍 /upload/images/package/9.jpg 5 <> 拉萨市 <> 25800.00 需高原适应训练 2025-04-10 1009
<== Row: 10 2025-04-29 19:07:26 三亚海滨旅拍 /upload/images/package/10.jpg 5 <> 三亚亚龙湾 <> 12800.00 包含游艇租赁 2025-04-15 1010
<== Row: 11 2025-04-29 19:07:26 民国风婚纱外拍 /upload/images/package/11.jpg 1 <> 上海市徐汇区 <> 7200.00 外景场地费另计 2025-04-20 1001
<== Row: 12 2025-04-29 19:07:26 孕妈艺术照 /upload/images/package/12.jpg 2 <> 杭州市滨江区 <> 4200.00 建议28-32周拍摄 2025-04-25 1003
<== Row: 13 2025-04-29 19:07:26 直播带货形象打造 /upload/images/package/13.jpg 3 <> 广州市直播基地 <> 6800.00 含提词器支持 2025-05-01 1005
<== Row: 14 2025-04-29 19:07:26 暗黑系情绪肖像 /upload/images/package/14.jpg 4 <> 重庆洪崖洞 <> 9800.00 仅限夜间拍摄 2025-05-05 1007
<== Row: 15 2025-04-29 19:07:26 新疆草原骑马旅拍 /upload/images/package/15.jpg 5 <> 伊犁州 <> 16800.00 旺季需加价30% 2025-05-10 1009
<== Row: 16 2025-04-29 19:07:26 婚礼微电影套餐 /upload/images/package/16.jpg 1 <> 南京市玄武区 <> 18800.00 含专业编剧服务 2025-05-15 1002
<== Row: 17 2025-04-29 19:07:26 宠物家庭照 /upload/images/package/17.jpg 2 <> 成都市锦江区 <> 2800.00 需自带宠物 2025-05-20 1004
<== Row: 18 2025-04-29 19:07:26 餐饮品牌全案拍摄 /upload/images/package/18.jpg 3 <> 长沙市五一广场 <> 12800.00 需配合营业时间 2025-05-25 1006
<== Row: 19 2025-04-29 19:07:26 国潮汉服创作 /upload/images/package/19.jpg 4 <> 西安大唐不夜城 <> 7800.00 含景区门票 2025-06-01 1008
<== Row: 20 2025-04-29 19:07:26 北海道雪景旅拍 /upload/images/package/20.jpg 5 <> 日本札幌 <> 35800.00 需自行办理签证 2025-06-05 1010
<== Total: 20
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@80fde22]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@80fde22]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@80fde22]
2025-07-04 17:55:20 [http-nio-9999-exec-10] 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:833) [?:?]