本文介紹了Spring Boot 與DBunit 配合使用方法，分享給大家，具體如下：
DBUnit
快速上手
Springboot 添加 DBunit 依賴
// https://mvnrepository.com/artifact/org.dbunit/dbunittestCompile group: 'org.dbunit', name: 'dbunit', version: '2.5.4'
編寫Test.java
import org.dbunit.DBTestCase;import org.dbunit.DatabaseUnitException;import org.dbunit.database.DatabaseConnection;import org.dbunit.database.IDatabaseConnection;import org.dbunit.database.QueryDataSet;import org.dbunit.dataset.DataSetException;import org.dbunit.dataset.IDataSet;import org.dbunit.dataset.xml.FlatXmlDataSet;import org.dbunit.dataset.xml.FlatXmlDataSetBuilder;import org.dbunit.operation.DatabaseOperation;@RunWith(SpringRunner.class)@SpringBootTestpublic class DBunit extends DBTestCase { @Resource DataSource dataSource; IDatabaseConnection iDatabaseConnection; @Override protected IDataSet getDataSet() throws Exception { return iDatabaseConnection.createDataSet(); } @Before public void before() throws Exception{ iDatabaseConnection = new DatabaseConnection(dataSource.getConnection()); }}將數據庫數據轉換為FlatXml
@Test public void testPartialExport() throws DataSetException, IOException { QueryDataSet queryDataSet = new QueryDataSet(iDatabaseConnection); queryDataSet.addTable("user", "select * from user"); FlatXmlDataSet.write(queryDataSet, new FileOutputStream("user.xml")); }執(zhí)行后，將會得到一個user.xml文件，里面記錄了數據庫user表的所有數據，看起來大概是這個樣子
<?xml version='1.0' encoding='UTF-8'?><dataset> <user id="1" username="mechanists" password="ABA3FC1EB2997E318E43CA099AE175CA"/> <user id="2" username="reporter" password="ABA3FC1EB2997E318E43CA099AE175CA" /> </dataset>
IDataSet
官網文檔地址
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持VeVb武林網。
新聞熱點
疑難解答
圖片精選
