直接贴代码
用java简单筛选
package com.sdkn;
import java.io.*;
public class FileHand {
public static String txt2String(File file) {
StringBuilder result = new StringBuilder();
try {
BufferedReader br = new BufferedReader(new FileReader(file));//构造一个BufferedReader类来读取文件
String s = null;
while ((s = br.readLine()) != null) {//使用readLine方法,一次读一行
result.append( s);
}
br.close();
} catch (Exception e) {
e.printStackTrace();
}
return result.toString();
}
public static void main(String[] args) throws IOException {
String dir = "C:\\Users\\Administrator\\Documents\\WeChat Files\\wxid_laynlw5dtz4q22\\FileStorage\\File\\2020-09\\lvchyg_temp\\";
File file = new File(dir);
String[] fileArr = file.list();
FileWriter fileWritter = new FileWriter("C:\\Users\\Administrator\\Desktop\\111.txt",true);
for (String str : fileArr){
File f = new File(dir+str);
String strTemp = txt2String(f);
String[] split1 = strTemp.split(";");
for (String str1 : split1) {
if (str1.indexOf("insert into eq_idsd") != -1) {
fileWritter.write(str1+";");
// System.out.println("执行文件:"+str1);
}
}
fileWritter.flush();
}
}
}
写入文件之后查看sql,是否有分号分割。
-------------------------------------------------------------------------------------------------另外感谢我领导。