测试函数代码:伪代码,我加了@Sql注解进行初始化
/**
* 测试分页查询促销活动
*
* @throws Exception
*/
@Test
@Sql({"clean_promotion_activity.sql"})
public void testListByPage() throws Exception {
Integer count = 30;
return db.query(count);
}
Sql脚本放在了当前测试类的同级目录上:
然后执行结果报错:
org.springframework.jdbc.datasource.init.CannotReadScriptException: Cannot read SQL script from class path resource [com/leeue/promotion/dao/clean_promotion_activity.sql]; nested exception is java.io.FileNotFoundException: class path resource [com/leeue/promotion/dao/clean_promotion_activity.sql] cannot be opened because it does not exist
解决方法:
步骤:
1. 在pom.xml 加上如下
<build>
<testResources>
<testResource>
<directory>src/test/java</directory>
<includes>
<include>**/*.sql</include>
</includes>
<filtering>true</filtering>
</testResource>
</testResources>
</build>
2、进行刷新 pom.xml ,我就是开始没刷新,以为这个没有效果。惨。
然后再进行跑单元测试就ok了