支付宝付款成功,但是订单状态一直就是未支付,这是怎么回事? 下面是ping回调地址的结果和服务器日志
来源:11-10 支付模块所有功能自测
weibo_只是很孤单_3027_0
2018-08-18
[2018-08-18 05:45:20,318] Artifact mmall:war: Artifact is deployed successfully
[2018-08-18 05:45:20,318] Artifact mmall:war: Deploy took 8,995 milliseconds
18-Aug-2018 17:45:21.040 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory F:\tomcat\webapps\manager
18-Aug-2018 17:45:21.121 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory F:\tomcat\webapps\manager has finished in 79 ms
[17:45:36.027][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] Creating a new SqlSession
[17:45:36.055][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@72459d90] was not registered for synchronization because synchronization is not active
[17:45:36.799][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-8] JDBC Connection [jdbc:mysql://127.0.0.1:3306/mmall?characterEncoding=utf-8, UserName=root@localhost, MySQL-AB JDBC Driver] will not be managed by Spring
[17:45:36.807][DEBUG][com.mmall.dao.UserMapper.checkUsername][http-nio-8088-exec-8] ==> Preparing: select count(1) from mmall_user where username = ?
[17:45:36.849][DEBUG][com.mmall.dao.UserMapper.checkUsername][http-nio-8088-exec-8] ==> Parameters: 帅帅(String)
[17:45:36.872][DEBUG][com.mmall.dao.UserMapper.checkUsername][http-nio-8088-exec-8] <== Total: 1
[17:45:36.876][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@72459d90]
[17:45:36.888][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] Creating a new SqlSession
[17:45:36.888][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5632a590] was not registered for synchronization because synchronization is not active
[17:45:36.889][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-8] JDBC Connection [jdbc:mysql://127.0.0.1:3306/mmall?characterEncoding=utf-8, UserName=root@localhost, MySQL-AB JDBC Driver] will not be managed by Spring
[17:45:36.889][DEBUG][com.mmall.dao.UserMapper.selectLogin][http-nio-8088-exec-8] ==> Preparing: SELECT -- *???//这样真的好么?答案就是,这样不好. id, username, password, email, phone, question, answer, role, create_time, update_time from mmall_user where username = ? and password = ?
[17:45:36.890][DEBUG][com.mmall.dao.UserMapper.selectLogin][http-nio-8088-exec-8] ==> Parameters: 帅帅(String), C59B3E57EC17F178FCAE709535295121(String)
[17:45:36.899][DEBUG][com.mmall.dao.UserMapper.selectLogin][http-nio-8088-exec-8] <== Total: 1
[17:45:36.899][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-8] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5632a590]
[17:45:43.254][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] Creating a new SqlSession
[17:45:43.255][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@885262f] was not registered for synchronization because synchronization is not active
[17:45:43.256][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-9] JDBC Connection [jdbc:mysql://127.0.0.1:3306/mmall?characterEncoding=utf-8, UserName=root@localhost, MySQL-AB JDBC Driver] will not be managed by Spring
[17:45:43.257][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-9] ==> Preparing: SELECT id, order_no, user_id, shipping_id, payment, payment_type, postage, status, payment_time, send_time, end_time, close_time, create_time, update_time from mmall_order where order_no = ? and user_id = ?
[17:45:43.258][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-9] ==> Parameters: 1534576731245(Long), 24(Integer)
[17:45:43.262][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-9] <== Total: 1
[17:45:43.262][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@885262f]
[17:45:43.265][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] Creating a new SqlSession
[17:45:43.265][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66da528] was not registered for synchronization because synchronization is not active
[17:45:43.266][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-9] JDBC Connection [jdbc:mysql://127.0.0.1:3306/mmall?characterEncoding=utf-8, UserName=root@localhost, MySQL-AB JDBC Driver] will not be managed by Spring
[17:45:43.267][DEBUG][c.m.d.OrderItemMapper.getByOrderNoUserId][http-nio-8088-exec-9] ==> Preparing: SELECT id, order_no, product_id, product_name, product_image, current_unit_price, quantity, total_price, create_time, update_time, user_id from mmall_order_item where order_no = ? and user_id = ?
[17:45:43.267][DEBUG][c.m.d.OrderItemMapper.getByOrderNoUserId][http-nio-8088-exec-9] ==> Parameters: 1534576731245(Long), 24(Integer)
[17:45:43.271][DEBUG][c.m.d.OrderItemMapper.getByOrderNoUserId][http-nio-8088-exec-9] <== Total: 1
[17:45:43.271][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-9] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66da528]
18-Aug-2018 17:45:43.385 信息 [http-nio-8088-exec-9] com.alipay.demo.trade.service.impl.AbsAlipayTradeService.tradePrecreate trade.precreate bizContent:{"out_trade_no":"1534576731245","seller_id":"","total_amount":"76989.00","undiscountable_amount":"0","subject":"happymmall扫码支付,订单号:1534576731245","body":"订单1534576731245购买商品共76989.00元","goods_detail":[{"goods_id":"26","goods_name":"Apple iPhone 7 Plus (A1661) 128G 玫瑰金色 移动联通电信4G手机","quantity":11,"price":"6999"}],"operator_id":"test_operator_id","store_id":"test_store_id","extend_params":{"sys_service_provider_id":"2088100200300400500"},"timeout_express":"120m"}
18-Aug-2018 17:45:44.588 信息 [http-nio-8088-exec-9] com.alipay.demo.trade.service.impl.AbsAlipayService.getResponse {"alipay_trade_precreate_response":{"code":"10000","msg":"Success","out_trade_no":"1534576731245","qr_code":"https:\/\/qr.alipay.com\/bax03078htf5zs51rnl400c4"},"sign":"ljY22gC6UmE4FsBwdT6jM2ceX5G9AjQqZja9YP4FTCz7LdlfQOZ1QqAhy4xVftP5TEmFghwP+WwpJhIo70n/ZVnaykJ4JrfSQRZWjxh6XQugQxihkr4JZv5XzBIE7UCx6l/T0TtAURVQRH8RHLyt3mBXGOVizwi+IDVNfamJ3kmjiMuCHbDekeMSOOWO39CuFCidD+2Z1Cid/D4tJGRQRVPbRNqRF+t/mkNyhM4gPvQNeHLpIa19y1eeXTmoqUz/n9wgrIJ4Kyg/iHjzK5U7SaAKhWJrrnlnBFDc6UkcVqIzwgBspXvayP26LEG0s0ZnO9KE/xHHn3RF0SEuNiNY0w=="}
[17:45:44.596][INFO][com.mmall.service.impl.OrderServiceImpl][http-nio-8088-exec-9] 支付宝预下单成功: )
[17:45:44.596][INFO][com.mmall.service.impl.OrderServiceImpl][http-nio-8088-exec-9] code:10000, msg:Success
[17:45:44.596][INFO][com.mmall.service.impl.OrderServiceImpl][http-nio-8088-exec-9] body:{"alipay_trade_precreate_response":{"code":"10000","msg":"Success","out_trade_no":"1534576731245","qr_code":"https:\/\/qr.alipay.com\/bax03078htf5zs51rnl400c4"},"sign":"ljY22gC6UmE4FsBwdT6jM2ceX5G9AjQqZja9YP4FTCz7LdlfQOZ1QqAhy4xVftP5TEmFghwP+WwpJhIo70n/ZVnaykJ4JrfSQRZWjxh6XQugQxihkr4JZv5XzBIE7UCx6l/T0TtAURVQRH8RHLyt3mBXGOVizwi+IDVNfamJ3kmjiMuCHbDekeMSOOWO39CuFCidD+2Z1Cid/D4tJGRQRVPbRNqRF+t/mkNyhM4gPvQNeHLpIa19y1eeXTmoqUz/n9wgrIJ4Kyg/iHjzK5U7SaAKhWJrrnlnBFDc6UkcVqIzwgBspXvayP26LEG0s0ZnO9KE/xHHn3RF0SEuNiNY0w=="}
[17:45:44.754][INFO][com.mmall.util.FTPUtil][http-nio-8088-exec-9] 开始连接ftp服务器
[17:45:44.798][INFO][com.mmall.util.FTPUtil][http-nio-8088-exec-9] 开始连接ftp服务器,结束上传,上传结果:{}
[17:45:44.798][INFO][com.mmall.service.impl.OrderServiceImpl][http-nio-8088-exec-9] qrPath:F:\tomcat\webapps\ROOT\upload/qr-1534576731245.png
[17:45:50.787][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-10] Creating a new SqlSession
[17:45:50.788][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-10] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@14e0ca29] was not registered for synchronization because synchronization is not active
[17:45:50.789][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-10] JDBC Connection [jdbc:mysql://127.0.0.1:3306/mmall?characterEncoding=utf-8, UserName=root@localhost, MySQL-AB JDBC Driver] will not be managed by Spring
[17:45:50.789][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-10] ==> Preparing: SELECT id, order_no, user_id, shipping_id, payment, payment_type, postage, status, payment_time, send_time, end_time, close_time, create_time, update_time from mmall_order where order_no = ? and user_id = ?
[17:45:50.789][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-10] ==> Parameters: 1534576731245(Long), 24(Integer)
[17:45:50.792][DEBUG][c.m.d.O.selectByUserIdAndOrderNo][http-nio-8088-exec-10] <== Total: 1
[17:45:50.792][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-10] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@14e0ca29]
3回答
-
止于平凡
2019-06-01
操蛋的,我也遇到这个问题了,朋友,请问你解决了吗
00 -
慕移动8085108
2018-11-30
同学你解决了吗
00 -
polo哦
2018-08-19
numberformat嘛,就是你的数字格式出错了,你可以debug下,因为你的日志没有报错,那正常来说你的其他业务逻辑都是正确的,你把断点设置在回调函数的开头,然后一步步走,看看哪步传的数据是错误的
022019-01-22
相似问题