java 读取csv文件demo_java批处理csv文件简单demo

import java.io.*;importjava.io.BufferedReader;importjava.io.BufferedWriter;importjava.io.File;importjava.util.ArrayList;importjava.util.List;public classProcessCSV {public static voidmain(String[] args) {

File inputFile= new File("/Users/sunxianyan/Desktop/input.csv");

File outputFile= new File("/Users/sunxianyan/Desktop/output.csv");

List dataList =ProcessCSV.importCsv(inputFile);

List outputList=new ArrayList();if(dataList!=null && !dataList.isEmpty()) {for (int i = 0; i < dataList.size(); i++) {

String s=dataList.get(i);

String[] as= s.split(",");

String [] str= as[0].split(".com/");

String targetUrl= "http://xxx.com/" + str[str.length-1];

outputList.add(targetUrl+","+as[1]);boolean isSuccess=ProcessCSV.exportCsv(outputFile, outputList);

System.out.println(isSuccess+":"+targetUrl+","+as[1]);

}

}

}/*** 写入

*@paramfile csv文件(路径+文件名)，csv文件不存在会自动创建

*@paramdataList 数据

*@return

*/

public static boolean exportCsv(File file, ListdataList){boolean isSucess=false;

FileOutputStream out=null;

OutputStreamWriter osw=null;

BufferedWriter bw=null;try{

out= newFileOutputStream(file);

osw= newOutputStreamWriter(out);

bw=newBufferedWriter(osw);if(dataList!=null && !dataList.isEmpty()){for(String data : dataList){

bw.append(data).append("\r");

}

}

isSucess=true;

}catch(Exception e) {

isSucess=false;

}finally{if(bw!=null){try{

bw.close();

bw=null;

}catch(IOException e) {

e.printStackTrace();

}

}if(osw!=null){try{

osw.close();

osw=null;

}catch(IOException e) {

e.printStackTrace();

}

}if(out!=null){try{

out.close();

out=null;

}catch(IOException e) {

e.printStackTrace();

}

}

}returnisSucess;

}/*** 读取

*@paramfile csv文件(路径+文件)

*@return

*/

public static ListimportCsv(File file){

List dataList=new ArrayList();

BufferedReader br=null;try{

br= new BufferedReader(newFileReader(file));

String line= "";while ((line = br.readLine()) != null) {

dataList.add(line);

}

}catch(Exception e) {

}finally{if(br!=null){try{

br.close();

br=null;

}catch(IOException e) {

e.printStackTrace();

}

}

}returndataList;

}

}