支付宝付款成功,但是订单状态一直就是未支付,这是怎么回事? 下面是ping回调地址的结果和服务器日志

Question

[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]

Answer 1

止于平凡 2019-06-01 23:40:52

操蛋的，我也遇到这个问题了，朋友，请问你解决了吗

Answer 2

慕移动8085108 2018-11-30 18:15:22

同学你解决了吗

Answer 3

polo哦 2018-08-19 11:32:16

numberformat嘛，就是你的数字格式出错了，你可以debug下，因为你的日志没有报错，那正常来说你的其他业务逻辑都是正确的，你把断点设置在回调函数的开头，然后一步步走，看看哪步传的数据是错误的

• 提问者 weibo_只是很孤单_3027_0 #1

  就没进回调函数

• java搬砖 回复 提问者 weibo_只是很孤单_3027_0 #2

  你现在解决了么，我也进不了回调函数，natapp能打开自己首页，自己项目也配置了回调地址，支付宝页面也配置了回调地址，但是就是不进回调