用java执行SQL文件?

List <String> sqlFileList = new ArrayList <String>();
//从文件读放内容到按分号放到sqlFileList
public List <String> readSqlFiles(List <String> fileNameList) {
List <String> sqlList = new ArrayList <String>();
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();

} 

 

 这是在网上找的  不知道还有没有更好的方法!~?

评论

1 楼 finallygo 2009-10-28  

我前几天也写了一个,是类似的,不同是我是读一句就执行一句,还有就是加上了事务控制