DBUnit

data.xml

<?xml version="1.0" encoding="UTF-8" ?>
<dataset>
    <User id="1" name="foo" />
    <User id="2" />
</dataset>

data_with_null.xml

<?xml version="1.0" encoding="UTF-8" ?>
<dataset>
    <User id="1" name="{null}" />
    <User id="2" name="foo" />
</dataset>

data_without_column.xml

<?xml version="1.0" encoding="UTF-8" ?>
<dataset>
    <User id="1" />
    <User id="2" name="foo" />
</dataset>

replace.java

@RunWith(SpringRunner.class)
@SpringBootTest
public class DBUnitTest {

	@Autowired
	private DataSource dataSource;

	@Before
	public void test() throws SQLException, DatabaseUnitException {
		DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
		IDataSet iDataSet = new FlatXmlDataSetBuilder().build(getClass().getResourceAsStream("/data_with_null.xml"));
		ReplacementDataSet replacementDataSet = new ReplacementDataSet(iDataSet);
		replacementDataSet.addReplacementObject("{null}", null);
		DatabaseOperation.CLEAN_INSERT.execute(connection, replacementDataSet);
	}

}

springboot_dbunit.java

@RunWith(SpringRunner.class)
@SpringBootTest
@TestExecutionListeners({
		DependencyInjectionTestExecutionListener.class,
		DbUnitTestListener.class
})
public class DBUnitTest {

	@DataSet("/test.xml")
	@Test
	public void test() {
	...
	}

}

string.java

@RunWith(SpringRunner.class)
@SpringBootTest
public class DBUnitTest {

	@Autowired
	private DataSource dataSource;

	@Before
	public void test() throws SQLException, DatabaseUnitException {
		DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
		IDataSet iDataSet = new FlatXmlDataSetBuilder().build(getClass().getResourceAsStream("/data.xml"));
		DatabaseOperation.CLEAN_INSERT.execute(connection, iDataSet);
	}

}