Question

如何使用 Java 实现对比两个 sql 文件

Answer 1

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();}