package com.sxd.test.util;

 import java.io.BufferedReader;

 import java.io.BufferedWriter;

 import java.io.File;

 import java.io.FileInputStream;

 import java.io.FileOutputStream;

 import java.io.IOException;

 import java.io.InputStreamReader;

 import java.io.OutputStreamWriter;

 import org.junit.Test;

 public class CreateInsert {

     @Test

     public void test() throws IOException{

         //1.读取文件

         File file = new File("d:/new4.txt");

         InputStreamReader read = new InputStreamReader(new FileInputStream(file),"utf-8");//考虑到编码格式

         BufferedReader bu = new BufferedReader(read);

         //2.拼接字符串

         String lineText = null;

         String insert = "INSERT INTO [report].[dbo].[process] ([bgid]) VALUES ('";

         String insert2 = "');";

         //3.边读边写

         OutputStreamWriter out = new OutputStreamWriter(new FileOutputStream(new File("d:/写出文件.txt")));

         BufferedWriter wr = new BufferedWriter(out);

         while((lineText = bu.readLine()) != null){

             System.out.println(insert+lineText+insert2);

             wr.write(insert+lineText+insert2+"\r\n");

         }

         read.close();

         wr.close();

     }

 }