老师好,就是测试更新店铺JUnit报错java.lang.AssertionError: expected:<1> but was:<0>

Question

控制台信息:
2018-07-11 19:50:10.477 [main] DEBUG com.o2o.dao.ShopDao.updateShop - ==>  Preparing: update tb_shop SET shop_desc=?, shop_addr=?, last_edit_time=? where shop_id=?
2018-07-11 19:50:10.519 [main] DEBUG com.o2o.dao.ShopDao.updateShop - ==> Parameters: 测试描述(String), 测试地址(String), 2018-07-11 19:50:10.025(Timestamp), 1(Long)
2018-07-11 19:50:10.521 [main] DEBUG com.o2o.dao.ShopDao.updateShop - <==    Updates: 0

Jniut信息:

java.lang.AssertionError: expected:<1> but was:<0>
    at org.junit.Assert.fail(Assert.java:88)
    at org.junit.Assert.failNotEquals(Assert.java:834)
    at org.junit.Assert.assertEquals(Assert.java:645)
    at org.junit.Assert.assertEquals(Assert.java:631)
    at com.o2o.dao.ShopDaoTest.testUpdateShop(ShopDaoTest.java:52)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206)

主要百度也百度不到,实在没办法来问问老师

Answer 1

翔仔 2018-07-11 23:40:51

同学好，同学可以把这句拷贝出来

update tb_shop SET shop_desc=?, shop_addr=?, last_edit_time=? where shop_id=?

放到你的mysql客户端里执行，传入控制台里的参数

Parameters: 测试描述(String), 测试地址(String), 2018-07-11 19:50:10.025(Timestamp), 1(Long)

你就会发现shop_id=1应该是在你数据库里不存在的，更新了一个不存在的值所以返回值就成了0

java.lang.AssertionError: expected:<1> but was:<0>

然而给的预期值是1，所以也就是更新了一个不存在的记录，因此想要成功得必须有shop_id为1这条记录。这个是比较基础的sql知识，希望同学课下花时间去学习一下，再来学习本门实战，这样效果会更好：）

• 提问者 Gronbu1 #1

  谢谢老师,确实是没有shop_id=1,不知道怎么就只有一条shop_id=2,再问下老师怎么把自动获取主键再从1开始,就是插入的shop_id再从1开始.打扰老师了,祝老师工作顺利

• 翔仔 回复 提问者 Gronbu1 #2

  从1开始的话需要全部清空表即truncate table xxxx 但是里面数据会被清空，或者硬插入一条id为1的也可以