ant 连接Mysql

ant 连接Mysql
一个.sql数据库脚本如何通过Ant构建到数据库中，例子是网上的，调试过程中遇到不少问题，记录如此：

你所需要的文件：
ant.sql 测试用的文件，可以自己编写
mysql-connector-java-5.1.6-bin.jar 连接数据库驱动jar包

方法一 ant_script.xml
Java 代码
[code]
1. <?xml version="1.0" encoding="UTF-8"?>
2. <project basedir="." default="DBrestore" name="DBrestorProject">
3. <target description="Executes an SQL Script" name="DBrestore">
4. <sql classpath="mysql-connector-java-5.1.6-bin.jar"
5. driver="com.mysql.jdbc.Driver"
6. src="ant.sql"
7. url="jdbc:mysql://localhost:3306/?autoReconnect=true"
8. userid="root"
9. password="root"/>
10. </target>
11. </project>

<?xml version="1.0" encoding="UTF-8"?>
<project basedir="." default="DBrestore" name="DBrestorProject">
<target description="Executes an SQL Script" name="DBrestore">
<sql classpath="mysql-connector-java-5.1.6-bin.jar"
driver="com.mysql.jdbc.Driver"
src="ant.sql"
url="jdbc:mysql://localhost:3306/?autoReconnect=true"
userid="root"
password="root"/>
</target>
</project>
[/code]


方法二 build.properties和build.xml
配置
Java 代码
[code]
1. # Sample ant build properties file
2.
3. #Database URL
4. test.database.url=jdbc\:mysql\://localhost\:3306/?autoReconnect\=true
5.
6. # Database JDBC Library and Driver
7. test.jdbc.jar=mysql-connector-java-5.1.6-bin.jar
8. test.jdbc.driver=com.mysql.jdbc.Driver
9.
10. #Database username and password, used for connecting database
11. test.database.user=root
12. #Database password
13. test.database.pass=root
14.
15. #Autopopulate sql file
16. test.sql.src=ant.sql

# Sample ant build properties file

#Database URL
test.database.url=jdbc\:mysql\://localhost\:3306/?autoReconnect\=true

# Database JDBC Library and Driver
test.jdbc.jar=mysql-connector-java-5.1.6-bin.jar
test.jdbc.driver=com.mysql.jdbc.Driver

#Database username and password, used for connecting database
test.database.user=root
#Database password
test.database.pass=root

#Autopopulate sql file
test.sql.src=ant.sql


ant脚本
Java 代码

1. <?xml version="1.0" ?>
2.
3. <project name="MySQLDB" default="restoredatabase">
4. <property location="build.properties" name="build.settings" />
5. <property file="${build.settings}"/>
6.
7. <!-- Loads an SQL file and Updates the database -->
8. <target description="Executes an SQL Script" name="restoredatabase">
9. <sql classpath="${test.jdbc.jar}"
10. driver="${test.jdbc.driver}"
11. src="${test.sql.src}"
12. url="${test.database.url}"
13. userid="${test.database.user}"
14. password="${test.database.pass}" />
15. </target>
16.
17. </project>

<?xml version="1.0" ?>

<project name="MySQLDB" default="restoredatabase">
<property location="build.properties" name="build.settings" />
<property file="${build.settings}"/>

<!-- Loads an SQL file and Updates the database -->
<target description="Executes an SQL Script" name="restoredatabase">
<sql classpath="${test.jdbc.jar}"
driver="${test.jdbc.driver}"
src="${test.sql.src}"
url="${test.database.url}"
userid="${test.database.user}"
password="${test.database.pass}" />
</target>

</project>

[/code]

运行：
1、 >ant -buildfile ant_script.xml
2、 >ant
结果一样。
注意编写脚本时候一定要非常小心对应名称，哪怕多写一个空格都会出现问题。