用dbunit导入和导出数据库测试数据
<project name="dbdata" default="export" basedir=".">
<taskdef name="dbunit" classname="org.dbunit.ant.DbUnitTask"/>
<target name="import">
<dbunit driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://192.168.0.199:1433;SelectMethod=cursor"
userid="me" password="me" supportBatchStatement="true">
<classpath>
<pathelement path="${java.class.path}/"/>
</classpath>
<operation type="CLEAN_INSERT" src="data.xml"/>
</dbunit>
</target>
<target name="export">
<dbunit driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://192.168.0.199:1433;User=me;Password=me;SelectMethod=cursor"
userid="me" password="me" supportBatchStatement="true">
<classpath>
<pathelement path="${java.class.path}/"/>
</classpath>
<export dest="data.xml">
<table name="salprov_plan"/>
<table name="SA_COURSE"/>
<table name="SALTYPE"/>
</export>
</dbunit>
</target>
</project>
