定义数据库连接属性:
static String diverName="oracle.jdbc.driver.OracleDriver";
static String url = "jdbc:oracle:thin:@192.168.90.11:1521:ucap";
static String user="armyoa73015";
static String pwd = "armyoa73015";
1. 运行的方法(依赖ant.jar):
static String fileName = "D:\\workspace\\huzhou\\jd-txt73015\\sql\\f_xxyr_xlcjdj.sql";
public static void runSqlFile(){
SQLExec sqlExec = new SQLExec();
sqlExec.setDriver(diverName);
sqlExec.setUrl(url);
sqlExec.setUserid(user);
sqlExec.setPassword(pwd);
sqlExec.setSrc(new File(fileName));
sqlExec.setEncoding("GBK");
DelimiterType dt = new DelimiterType();
dt.setValue("row");
sqlExec.setDelimiterType(dt);
sqlExec.setDelimiter("/");
sqlExec.setKeep