package test4; import java.io.BufferedReader;import java.io.FileReader;import java.io.IOException; public class ExplaceSql {	public static void main(String[] args) {		 String filePath = ExplaceSql.class.getResource("").getPath()+"aaa.txt"; // 文件路徑		 read(filePath);	}		/**	 * 讀取內容	 */	public static String read(String filePath){		BufferedReader br = null;		String line =null;		//StringBuffer buf = new StringBuffer();		try {			//根據文件路徑創建緩沖輸入流			br = new BufferedReader(new FileReader(filePath));//filePath中是aaa.txt文件			String str = "";						//循環讀取文件的每一行，對需要修改的行進行修改，放入緩沖對象中			 while ((line = br.readLine()) != null) {				 //設置正則將多余空格都轉為一個空格				 str=line+"/r/n";				 String[] dictionary = str.split("//s{2,}|/t");				 for(int i=0;i<dictionary.length;i++){					str = "insert into tablename values("+ dictionary[0]+",'"+dictionary[1]+"',"+dictionary[2]+"')";				 }				 System.out.println(str);				 			 }		} catch (Exception e) {			e.printStackTrace();		}finally {	   if (br != null) {// 關閉流	    try {	     br.close();	    } catch (IOException e) {	      br = null;		  }		  }		}		return null;	}	}

package help; import java.io.BufferedReader;import java.io.BufferedWriter;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.InputStreamReader;import java.io.OutputStreamWriter;import java.util.HashMap;import java.util.Map; public class TXTParseUtils {  private static final Integer ONE = 1;  public static void main(String[] args) {  Map<String, Integer> map = new HashMap<String, Integer>();   /* 讀取數據 */  try {   BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(new File("D:/報銷.txt")),                   "UTF-8"));   String lineTxt = null;   while ((lineTxt = br.readLine()) != null) {    String[] names = lineTxt.split(",");    for (String name : names) {     if (map.keySet().contains(name)) {      map.put(name, (map.get(name) + ONE));     } else {      map.put(name, ONE);     }    }   }   br.close();  } catch (Exception e) {   System.err.println("read errors :" + e);  }   /* 輸出數據 */  try {   BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(new File("D:/結果.txt")),                   "UTF-8"));    for (String name : map.keySet()) {    bw.write(name + " " + map.get(name));    bw.newLine();   }   bw.close();  } catch (Exception e) {   System.err.println("write errors :" + e);  } }}