Spring Boot 与DBunit 配合使用方法

// https://mvnrepository.com/artifact/org.dbunit/dbunit

testcompile group: 'org.dbunit' , name: 'dbunit' , version: '2.5.4'

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());

   }

}

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

}

<?xml version= '1.0' encoding= 'utf-8' ?>

<dataset>

  <user id= "1" username= "mechanists" password= "aba3fc1eb2997e318e43ca099ae175ca" />

  <user id= "2" username= "reporter" password= "aba3fc1eb2997e318e43ca099ae175ca" />

</dataset>