package zhidan.zhidan_demo;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.Scanner;
public class GetInsertSql {
public static void main(String[] args) throws IOException {
FileInputStream inputStream = null;
Scanner sc = null;
try {
inputStream = new FileInputStream("D:\project\server\chuangshitest(1)\chuangshitest.sql");
sc = new Scanner(inputStream, "UTF-8");
//写入中文字符时解决中文乱码问题
FileOutputStream fos=new FileOutputStream(new File("d:/chuangshi.sql"));
OutputStreamWriter osw=new OutputStreamWriter(fos, "UTF-8");
BufferedWriter bw=new BufferedWriter(osw);
while (sc.hasNextLine()) {
String line = sc.nextLine();
if(line.indexOf("INSERT")>-1 && line.indexOf(");")>-1) {
System.out.println(line);
bw.write(line+"
");
}
//bw.close();
//osw.close();
}
// note that Scanner suppresses exceptions
if (sc.ioException() != null) {
throw sc.ioException();
}
} finally {
if (inputStream != null) {
inputStream.close();
}
if(sc != null) {
sc.close();
}
}
}
}