Java Ant - SQLExec .SQL File

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. * ;
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());

}

}

 

 

 

 

Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.

转载于:https://www.cnblogs.com/zencorn/archive/2011/01/27/1946348.html