国产激情在线,天天操天天操天天,久久免费福利视频

本文介紹了spring boot 與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.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)

									@springboottest

									public 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"));

									}

執行后，將會得到一個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>