<target name="db-table-create">
<echo message="Creating table: ${target_table}" />
<sql driver="${jdbc.driverClassName}" url="${jdbc.url}" userid="${jdbc.username}" password="${jdbc.password}" src="${mysql-create-db}">
<classpath refid="classpath" />
</sql>
</target>
<!-- clear the database -->
<target name="db-table-drop">
<echo message="Deleting data from database..." />
<sql driver="${jdbc.driverClassName}" url="${jdbc.url}" userid="${jdbc.username}" password="${jdbc.password}">
<classpath refid="classpath" />
<![CDATA[
DELETE FROM ${target_table};
]]>
</sql>
</target>
<target name="db-table-select">
<echo message="Selecting data from database..." />
<sql driver="${jdbc.driverClassName}"
url="${jdbc.url}"
userid="${jdbc.username}"
password="${jdbc.password}">
<classpath refid="classpath" />
<![CDATA[
SELECT * FROM ${target_table};
]]>
</sql>
</target>
