StringdriverClassName=pro.getProperty("jdbc.driverClassName");StringjdbcUrl=pro.getProperty("jdbc.url");StringuserName=pro.getProperty("jdbc.username");StringuserPassword...
String driverClassName = pro.getProperty("jdbc.driverClassName");
String jdbcUrl = pro.getProperty("jdbc.url");
String userName = pro.getProperty("jdbc.username");
String userPassword = pro.getProperty("jdbc.password");
sqlExec.setDriver(driverClassName);
sqlExec.setUrl(jdbcUrl+"?useUnicode=true&characterEncoding=utf-8");
sqlExec.setUserid(userName);
sqlExec.setPassword(userPassword);
//要执行的脚本
sqlExec.setSrc(new File(sqlPath+fileName));
//有出错的语句终止执行
//sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance(SQLExec.OnError.class, "abort")));
//如果有出错的语句继续执行.
sqlExec.setOnerror((SQLExec.OnError) (EnumeratedAttribute.getInstance(SQLExec.OnError.class, "continue")));
sqlExec.setPrint(true); //设置是否输出
//输出到文件 sql.out 中;不设置该属性,默认输出到控制台
//sqlExec.setOutput(new File("src/sql.out"));
sqlExec.setProject(new Project()); // 要指定这个属性,不然会出错
sqlExec.setEncoding("UTF8");
sqlExec.execute();
展开