Java 怎样快速执行SQL 文件_用java执行SQL文件?

List

sqlFileList = new ArrayList

();

//从文件读放内容到按分号放到sqlFileList

public List

readSqlFiles(List

fileNameList) {

List sqlList = new ArrayList

();

for (String fileName : fileNameList) {

File myFile = new File(fileName);

if (!myFile.exists()) {

System.err.println("Can't Find " + fileName);

continue;

}

StringBuffer temp = new StringBuffer();

try {

BufferedReader in = new BufferedReader(new

FileReader(myFile));

String str;

while ((str = in.readLine()) != null) {

temp.append(str);

}

in.close();

} catch (IOException e) {

e.getStackTrace();

}

String sqls[] = temp.toString().split(";");

for (String sql : sqls) {

sqlList.add(sql);

}

}

return sqlList;

}

//然后一句句的执行

for (String sql : sqlList) {

pstmt = con.prepareStatement(sql,

ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY);

pstmt.execute();

}