package com.parami.utils;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.List;/**
* CSV操作(导出和导入)
*
* @author 林计钦
* @version 1.0 Jan 27, 2014 4:30:58 PM*/
public classCSVUtils {/**
* 导出
*
* @param file csv文件(路径+文件名),csv文件不存在会自动创建
* @param dataList 数据
* @return*/
public static boolean exportCsv(File file, ListdataList){
boolean isSucess=false;
FileOutputStreamout=null;
OutputStreamWriter osw=null;
BufferedWriter bw=null;try{out = newFileOutputStream(file);
osw= new OutputStreamWriter(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;
}/**
* 导入
*
* @param file 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;
}
}