ant 连接Mysql

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

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

方法一 ant_script.xml
Java 代码

   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>

方法二 build.properties和build.xml
配置
Java 代码

   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>

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