Java Ant - SQLExec .SQL File
来源:互联网 发布:淘宝网店推广方法与营销技巧 编辑:程序博客网 时间:2024/06/05 19:34
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.*;
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 SourcestrFullFile = "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 exceptionSystem.
out.println("Exception:+" +xe.getMessage());}
}
Work by Jianfei is licensed under a Creative Commons wei 3.0 Unported License.
- Java Ant - SQLExec .SQL File
- 使用 Ant SQLExec 执行sql文件中文乱码
- SQLEXEC
- Running Dynamic SQL with SQLEXEC
- SQLExec.c
- SQLExec.c
- A common Ant file format for simple java project
- My Ant file
- ant build file demo
- Ant [Java]
- ant java
- Aother ant Project xml file
- ant pack up ear file
- Using SQLExec and Record Objects
- Ant [SQL] 未完
- 运用ANT地SQL Task来完成自己地Java执行SQL脚本文件地功能
- 利用 Ant 的 SQL Task 来实现自己的 Java 执行 SQL 脚本文件的功能
- Ant Task check if a file exists
- Removing reports / report folder by SSRS (SQL SERVER REPORTING SERVICE)
- Create SQL server job with SQL SERVER.
- C# UnInstall Application by name.
- C# Get a folder or file list which finished sequence line. 直接得到 排序后 的 文件列表
- 当前 IT 行业是否同样适用刘易斯拐点的思考.
- Java Ant - SQLExec .SQL File
- Eclipse User Defined Code Statement Block.
- Change Silk Recording type like multi-tag or only for Windows ID
- FTP 文件 循环 Copy
- SQL Profiler Practice.
- Get all tables list form current DB.
- Using C# Generics read & update XML file .
- Java method Exception throw with return instance.
- Get user name from the web client in Active Directories. [ No using Page.user]