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

}