ant sql

 

    <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>