使用ant执行sql文件
[code]
<?xml version="1.0" encoding="UTF-8"?>
<project basedir="." default="CreateLsal" name="CreateLsalProject">
<target name="CreateLsal" description="recreate tables and sequences">
<sql driver="com.mysql.jdbc.Driver" showheaders="true" print="true" encoding="utf-8" autocommit="true" url="jdbc:mysql://localhost:3306/?autoReconnect=true;useUnicode=true&characterEncoding=UTF-8" userid="root" password="root" classpath="WebContent/WEB-INF/lib/mysql-connector-java-3.0.16-ga-bin.jar" delimiter=";">
<fileset file="src/com/lxitedu/sql/lsal.sql" />
<fileset file="src/com/lxitedu/sql/dictionaries.sql" />
<fileset file="src/com/lxitedu/sql/dict_items.sql" />
<fileset file="src/com/lxitedu/sql/city1.sql" />
<fileset file="src/com/lxitedu/sql/city2.sql" />
<fileset file="src/com/lxitedu/sql/city3.sql" />
<fileset file="src/com/lxitedu/sql/city4.sql" />
<fileset file="src/com/lxitedu/sql/city5.sql" />
<fileset file="src/com/lxitedu/sql/other.sql" />
</sql>
</target>
</project>
[/code]
[code]
<?xml version="1.0" encoding="UTF-8"?>
<project basedir="." default="CreateLsal" name="CreateLsalProject">
<target name="CreateLsal" description="recreate tables and sequences">
<sql driver="com.mysql.jdbc.Driver" showheaders="true" print="true" encoding="utf-8" autocommit="true" url="jdbc:mysql://localhost:3306/?autoReconnect=true;useUnicode=true&characterEncoding=UTF-8" userid="root" password="root" classpath="WebContent/WEB-INF/lib/mysql-connector-java-3.0.16-ga-bin.jar" delimiter=";">
<fileset file="src/com/lxitedu/sql/lsal.sql" />
<fileset file="src/com/lxitedu/sql/dictionaries.sql" />
<fileset file="src/com/lxitedu/sql/dict_items.sql" />
<fileset file="src/com/lxitedu/sql/city1.sql" />
<fileset file="src/com/lxitedu/sql/city2.sql" />
<fileset file="src/com/lxitedu/sql/city3.sql" />
<fileset file="src/com/lxitedu/sql/city4.sql" />
<fileset file="src/com/lxitedu/sql/city5.sql" />
<fileset file="src/com/lxitedu/sql/other.sql" />
</sql>
</target>
</project>
[/code]