本文介绍了Spring Boot 与DBunit 配合使用方法,分享给大家,具体如下:

DBUnit

快速上手

Springboot 添加 DBunit 依赖

// https://mvnrepository.com/artifact/org.dbunit/dbunit
testCompile group: 'org.dbunit', name: 'dbunit', version: '2.5.4'

编写Test.java

import org.dbunit.DBTestCase;
import org.dbunit.Data UnitException;
import org.dbunit.data .Data Connection;
import org.dbunit.data .IData Connection;
import org.dbunit.data .QueryDataSet;
import org.dbunit.dataset.DataSetException;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset. .Flat DataSet;
import org.dbunit.dataset. .Flat DataSetBuilder;
import org.dbunit.operation.Data Operation;

@RunWith(SpringRunner.class)
@SpringBootTest
public class DBunit extends DBTestCase {

  @Resource
  DataSource dataSource;
  IData Connection iData Connection;


  @Override
  protected IDataSet getDataSet() throws Exception {
    return iData Connection.createDataSet();
  }

  @Before
  public void before() throws Exception{
      iData Connection = new Data Connection(dataSource.getConnection());
    
  }
}

将数据库数据转换为Flat

  @Test
  public void testPartialExport() throws DataSetException, IOException {
    QueryDataSet queryDataSet = new QueryDataSet(iData Connection);
    queryDataSet.addTable("user", "select * from user");
    Flat DataSet.write(queryDataSet, new FileOutputStream("user. "));
  }

执行后,将会得到一个user. 文件,里面记录了数据库user表的所有数据,看起来大概是这个样子

<?  version='1.0' encoding='UTF-8'?>
<dataset>
 <user id="1" username="mechanists" password="ABA3FC1EB2997E318E43CA099AE175CA"/>
 <user id="2" username="reporter" password="ABA3FC1EB2997E318E43CA099AE175CA" />
 
</dataset>

IDataSet

官网文档地址

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。

收藏 打印