Spring Boot 与DBunit 配合使用方法

2021-05-31 11:28170901 Java教程

这篇文章主要介绍了Spring Boot 与DBunit 配合使用方法，小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧

本文介绍了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>