java 解析csv文件

package csv.test;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class csvFileParseTest {

private InputStreamReader fr = null;
private BufferedReader br = null;

public csvFileParseTest(String f) throws IOException {
fr = new InputStreamReader(new FileInputStream(f));
}

/**
* 解析csv文件 到一个list中 每个单元个为一个String类型记录，每一行为一个list。 再将所有的行放到一个总list中
*/
public List<List<String>> readCSVFile() throws IOException {
br = new BufferedReader(fr);
String rec = null;// 一行
String str;// 一个单元格
List<List<String>> listFile = new ArrayList<List<String>>();
try {
// 读取一行
while ((rec = br.readLine()) != null) {
Pattern pCells = Pattern.compile("(\"[^\"]*(\"{2})*[^\"]*\")*[^,]*,");
Matcher mCells = pCells.matcher(rec);
List<String> cells = new ArrayList<String>();// 每行记录一个list
// 读取每个单元格
while (mCells.find()) {
str = mCells.group();
str = str.replaceAll("(?sm)\"?([^\"]*(\"{2})*[^\"]*)\"?.*,", "$1");
str = str.replaceAll("(?sm)(\"(\"))", "$2");
cells.add(str);
}
listFile.add(cells);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (fr != null) {
fr.close();
}
if (br != null) {
br.close();
}
}
return listFile;
}

public static void main(String[] args) {
csvFileParseTest test;
List<List<String>> csvList = null;
try {
test = new csvFileParseTest("F:/WorkSpace01/stringAndFileTest/src/csv/test/cstTest.csv");
csvList = test.readCSVFile();
} catch (IOException e) {
e.printStackTrace();
}
if(csvList != null){
for(int i=0; i<csvList.size(); i++){
for(int j=0; j<csvList.get(i).size(); j++){
System.out.println("line :" + i + " column :" + j + " " + csvList.get(i).get(j));
}
}
}
}
}