首页 > 其他 > 详细

剔出insert语句

时间:2019-04-10 11:50:16      阅读:114      评论:0      收藏:0      [点我收藏+]
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+"\t\n");
         }
         
         //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();
        }
        }
    }

}

 

剔出insert语句

原文:https://www.cnblogs.com/longsanshi/p/10682379.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!