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();
}
在java中调用sql语句是 java调用sql文件
转载文章标签 在java中调用sql语句是 Java 怎样快速执行SQL 文件 sql List System 文章分类 Java 后端开发
-
java调用启动ffmpeg命令
java调用启动ffmpeg命令
Java ide shell脚本