Spring中集成dbunit进行单元测试

Dbunit的几种数据格式

?

其他：

xml的数据准备和维护太复杂

xls的格式什么的一点不对就报错

?

比较一下，还是CSV的比较靠谱

?

用在Spring里集成DbUnit写一测试基类，同时使用CSV作为准备数据源

?

?

/** * 测试基类. * * @author buming.pl */@RunWith(SpringJUnit4ClassRunner.class)  @ContextConfiguration(locations={"classpath:/springbeans-data-source-test.xml","classpath:/springbeans-rpt-ds-test.xml","classpath:/ehcache.xml","classpath:/springbeans-web-manager.xml","classpath:/springbeans-dozer.xml","classpath:/springbeans-hsf-remote.xml","classpath:/springbeans-tbuic-client-test.xml","classpath:/springbeans-web-bo.xml"})@TransactionConfiguration(transactionManager="txManager",defaultRollback=true)@Transactional@ITestDataSetpublic abstract class BaseTestCase extends AbstractTransactionalDataSourceSpringContextTests{/** The log. */protected final Log log = LogFactory.getLog(getClass());/** The data source. */@Resource    private DataSource dataSource;          /** The database tester. */    private DataSourceDatabaseTester databaseTester;      /**     * Inits the dbunit.     *     * @throws Exception the exception     */    @Before    public void initDbunit() throws Exception {        databaseTester = new DataSourceDatabaseTester(dataSource);        databaseTester.setTearDownOperation(DatabaseOperation.DELETE_ALL);        databaseTester.setSchema("zuanshi_test");        setUpCsvDataSet();    }        /**     * Tear down database.     *     * @throws Exception the exception     */    @After    public void tearDownDatabase() throws Exception {      if (databaseTester != null && databaseTester.getDataSet()!=null) {          databaseTester.onTearDown();      }    }    /**     * 设置CSV格式的初始化数据.     *     * @param file the new up csv data set     * @throws Exception the exception     */    protected void setUpCsvDataSet(String file){    try {    IDataSet dataset = new CsvDataSet(new ClassPathResource(file).getFile());   ;            databaseTester.setDataSet(dataset);            databaseTester.onSetup();  } catch (Exception e) {e.printStackTrace();}     }        /**     * 设置CSV格式的初始化数据.     *     * @param file the new up csv data set     * @throws Exception the exception     */    protected void setUpCsvDataSet() {    try {    File file = new File(this.getClass().getResource("").getPath()+"/csv");    if(file.exists()){                IDataSet dataset = new CsvDataSet(file);                databaseTester.setDataSet(dataset);                databaseTester.onSetup();    }} catch (Exception e) {e.printStackTrace();}    }}

?

?

开始一直报错说：

org.dbunit.database.AmbiguousTableNameException

?

后来发现是其他的Schema下有相同的表名引起的，所以要制定Schema

?

?

databaseTester.setSchema("zuanshi_test");

?

?

使用的时候，只要在测试类下建立 ?csv 目录，在里面放入文件

?

?

table-ordering.txt

?

内容为表名的列表，一个表一行

?

其他就是以 ? ?表名.csv 的文件，一个表一个文件

?

?

例如：

?

memberid,contractver,createtime,updatetime,status,nickname

99999901,1,2011-08-24 11:11:00,2011-08-24 11:11:00,1,zuanshi001

99999902,1,2011-08-24 11:11:01,2011-08-24 11:11:01,1,zuanshi002

99999903,1,2011-08-24 11:11:02,2011-08-24 11:11:02,1,zuanshi003

99999904,1,2011-08-24 11:11:03,2011-08-24 11:11:03,1,zuanshi004

99999905,1,2011-08-24 11:11:04,2011-08-24 11:11:04,1,zuanshi005

99999906,1,2011-08-24 11:11:05,2011-08-24 11:11:05,1,zuanshi006

99999907,1,2011-08-24 11:11:06,2011-08-24 11:11:06,1,zuanshi007

99999908,1,2011-08-24 11:11:07,2011-08-24 11:11:07,1,zuanshi008

99999909,1,2011-08-24 11:11:08,2011-08-24 11:11:08,1,zuanshi009

?

每个方法都会加载数据，方法结束后清除数据

?

使用的时候和使用JUNIT一样

?

?

public class MemberBOImplTest extends BaseTestCase {@Autowiredprivate IMemberBO memberBO;/** * Test method for {@link com.taobao.ad.zuanshi.biz.bo.member.impl.MemberBOImpl#getMemberById(java.lang.Long)}. */@Testpublic void testGetMemberById(){MemberDO memberDO = memberBO.getMemberById(99999901L);assertEquals(memberDO.getMemberid().longValue(), 99999901L);assertEquals(memberDO.getNickname(), "zuanshi001");}}

?

?

?

?