csv 是以逗号进行分隔的文件,以换行符表示下一条记录
读文件:构建hashmap
Map<String, Integer> tempMap = new HashMap<String, Integer>();
String filePath = "******";
BufferedReader bufReader = new BufferedReader(new FileReader(filePath));
String lineStr = "";
int rowNumber = 0;
while ((lineStr = bufReader.readLine()) != null) {
tempMap.put(lineStr.split(",")[0],
Integer.parseInt(lineStr.split(",")[7]));
rowNumber++;
System.out.printf("xx:%d...\n ", rowNumber);
}
bufReader.close();
根据hashmap 匹配然后补上最后一列:
String filePath1 = "D:\\Users\\YUYI179\\Desktop\\work\\hz.csv";
BufferedReader bufReader1 = new BufferedReader(
new FileReader(filePath1));
int rowNumber1 = 0;
StringBuffer nContent = new StringBuffer();
while ((lineStr = bufReader1.readLine()) != null) {
int addValue = 0;
if (rowNumber1 != 0) {
try{
if(tempMap.get(lineStr.split(",")[0].substring(12))!=null)
addValue = tempMap.get(lineStr.split(",")[0].substring(12));
}catch(Exception ee){
@SuppressWarnings("unused")
int jj=0;
}
}
if (lineStr.endsWith(",")) {
nContent.append(lineStr).append("\"" + addValue + "\"");
} else {
nContent.append(lineStr).append(",\"" + addValue + "\"");
}
rowNumber1++;
nContent.append("\r\n");
}
bufReader1.close();
把流进制文件写入文件。
FileOutputStream fileOs = new FileOutputStream(new File(filePath1),
false);true表示如果文件已经存在,没执行程序一次便往文件追加一次内容,false会每一次的执行结果会覆盖文件上一次执行结果
fileOs.write(nContent.toString().getBytes());
fileOs.close();