Dbunit and Ant

The initial use of Ant DBUnit, can be implemented with ANT, or you can directly write DBUnit test code. Dataset.xml

Code:

Build.xml

Code: < / Target> <

/ Project> Direct test code, run the JUnit test to import the data into the database:

Code: / * * Created on 2004-10-12 * / package com.sager.dbunit; import java.io.FileInputStream; import java.sql.Connection; import java.sql.DriverManager; import org.dbunit.DatabaseTestCase; import org.dbunit.database.DatabaseConnection; import org.dbunit.database.IDatabaseConnection; import org.dbunit.dataset.IDataSet; import org.dbunit.dataset.xml.FlatXmlDataSet; import org.dbunit.operation.DatabaseOperation; / ** * @author Sager * * / public class SampleTest extends DatabaseTestCase {public SampleTest (String name) {super (name);} / ** * @see org.dbunit.DatabaseTestCase # getConnection () * / protected IDatabaseConnection getConnection () throws Exception { class driverClass = Class.forName ( "com.mysql.jdbc.Driver"); Connection jdbcConnection = DriverManager.getConnection ( "jdbc: mysql: // localhost / test", "root", "sql"); return new DatabaseConnection ( JDBCConnection;} / ** * @see org.dbunit.DatabaseTabasetestcas e # getDataSet () * / protected IDataSet getDataSet () throws Exception {return new FlatXmlDataSet (new FileInputStream ( "dataset.xml"));} protected DatabaseOperation getSetUpOperation () throws Exception {return DatabaseOperation.REFRESH;} protected DatabaseOperation getTearDownOperation () THROWS Exception {Return DatabaseOperation.none;} public void testme () {system.out.println ("Testing ...");}}