使用ant对数据库进行一系列操作

使用ant执行sql文件

<?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&amp;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>