Datatable export for dbunit

exportDBunitDataset

package com.cestpasdur;

import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;

import org.dbunit.database.DatabaseConnection;
import org.dbunit.database.IDatabaseConnection;
import org.dbunit.database.QueryDataSet;
import org.dbunit.dataset.xml.FlatXmlDataSet;

public class DatabaseExport {
  public static void main(String[] args) throws Exception {
    // database connection
    Connection jdbcConnection = DriverManager.getConnection("jdbc:mysql://host:3305/dbname", "user", "password");
    IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);

    // partial database export
    QueryDataSet partialDataSet = new QueryDataSet(connection);
    partialDataSet.addTable("MYTABLE", "SELECT * FROM MYTABLE;");
    FlatXmlDataSet.write(partialDataSet, new FileOutputStream("d://datasetExport.xml"));


  }
}