                        課程
                    
                        /后端開發
                        
                            /Java
                        
                        /Java高并發秒殺API之Service層

executeSeckill測試問題?

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'uesrphone' not found. Available parameters are [seckillId, userphone, param1, param2]

我已經加了@Param可是沒用，回去發現之前Dao層中的queryByIdWithSeckill()方法也出了這個問題，在沒有寫Service層之前都沒有出現問題,結果寫完后測試發現都不行了。

搬磚工學編程

2016-10-11

源自：Java高并發秒殺API之Service層 4-1

關注問題我要回答

1518

操作

收起

2 回答

搬磚工學編程提問者
2016-10-12

真的是打錯了！！真是粗心！

但是新的問題又來了?

@Test
public void executeSeckill() throws Exception {
? ?long id = 1000;
? ?long phone = 13877093290L;
? ?String ?md5 = "42d56fec120bf23e3af750569ca017c3";
? ?SeckillExcution seckillExcution = seckillService.executeSeckill(id,phone,md5);
? ?logger.info("SeckillExcution={}"+seckillExcution);

輸出結果

18:14:52.931 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Creating a new SqlSession

18:14:52.935 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:52.940 ?[main] ?DEBUG o.m.s.t.SpringManagedTransaction - ?JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@616ac46a] will be managed by Spring

18:14:52.943 ?[main] ?DEBUG o.s.dao.SeckillDao.reduceNumber - ?==> ?Preparing: update seckill set number = number - 1 where seckill_id = ? and start_time <= ? and end_time >= ? and number > 0?

18:14:52.965 ?[main] ?DEBUG o.s.dao.SeckillDao.reduceNumber - ?==> Parameters: 1001(Long), 2016-10-12 18:14:52.923(Timestamp), 2016-10-12 18:14:52.923(Timestamp)

18:14:52.973 ?[main] ?DEBUG o.s.dao.SeckillDao.reduceNumber - ?<== ? ?Updates: 1

18:14:52.973 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:52.974 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff] from current transaction

18:14:52.974 ?[main] ?DEBUG o.s.d.S.insertSuccessKilled - ?==> ?Preparing: insert ignore into success_killed (seckill_id,user_phone) value (?,?)?

18:14:52.975 ?[main] ?DEBUG o.s.d.S.insertSuccessKilled - ?==> Parameters: 1001(Long), 13877093293(Long)

18:14:52.983 ?[main] ?DEBUG o.s.d.S.insertSuccessKilled - ?<== ? ?Updates: 1

18:14:52.983 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:52.984 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff] from current transaction

18:14:52.985 ?[main] ?DEBUG o.s.d.S.queryByIdWithSeckill - ?==> ?Preparing: select sk.seckill_id, sk.user_phone, sk.create_time, sk.state, s.seckill_id "seckill.seckill_id", s.name "seckill.name", s.number "seckill.number", s.start_time "seckill.start_time", s.end_time "seckill.end_time", s.create_time "seckill.create_time" from success_killed sk inner join seckill s on sk.seckill_id = s.seckill_id where sk.seckill_id = ? and sk.user_phone = ??

18:14:52.985 ?[main] ?DEBUG o.s.d.S.queryByIdWithSeckill - ?==> Parameters: 1001(Long), 13877093293(Long)

18:14:53.002 ?[main] ?DEBUG o.s.d.S.queryByIdWithSeckill - ?<== ? ? ?Total: 1

18:14:53.006 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:53.007 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:53.007 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:53.007 ?[main] ?DEBUG org.mybatis.spring.SqlSessionUtils - ?Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b3f61ff]

18:14:53.098 ?[main] ?INFO ?o.seckill.service.SeckillServiceTest - ?SeckillExcution={}org.seckill.dto.SeckillExcution@1672fe87

為什么SeckillExcution ={} 里面沒有信息的？