Java Ant - SQLExec .SQL File
![知识共享许可协议](http://i.creativecommons.org/l/by/3.0/80x15.png)
Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.
Goal: Using java to run one SQL script file directly .
Resource : Download the Java-Ant jar package from http://ant.apache.org/bindownload.cgi
import org.apache.tools.ant.taskdefs.*;
import org.apache.tools.ant.types.*;
public void ExecSQLFileByAnt(String strFullFile)
{
JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //SQL DB Engine
connectDB = "jdbc:sqlserver://" + strDBServer +":1433;DatabaseName=" + strDBName;// Data Source
strFullFile = "I:\\dwei\\MO-SQL\\MO_NAV_Insert.sql";
try {
org.apache.tools.ant.taskdefs.SQLExec sqlExec = new SQLExec();
sqlExec.setDriver(JDriver);
String url;
url = connectDB;
sqlExec.setUrl(url);
sqlExec.setUserid(strUser);
sqlExec.setPassword(strPwd);
strFullFile = strFullFile; //"I:\\dwei\\MO-SQL\\MO_NAV_Insert.sql";
sqlExec.setSrc(new File(strFullFile));
sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance( SQLExec.OnError.class, "abort")));
sqlExec.setPrint(true);
sqlExec.setProject(new Project());
sqlExec.execute();
} catch (Exception xe) {
// TODO: handle exception
System.out.println("Exception:+" +xe.getMessage());
}
}
![知识共享许可协议](http://i.creativecommons.org/l/by/3.0/80x15.png)
Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.
- Make people around you successful is the biggest contribution to ourselves. -