CSV导出使用实例

package com.cdel.portal.stage.appointment.util;

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.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.servlet.http.HttpServletResponse;

import com.cdel.portal.stage.appointment.entity.AppointmentSign;
import com.cdel.portal.stage.appointment.entity.MemberAccTicket;


/**
 * csv 导出工具类
 * @author zhangheng
 * @date 2017年7月7日下午1:27:07
 */
public class CSVUtils {
    /**
     * 导出签到信息
     * @date 2017年7月7日下午1:27:07
     * @param response
     * @param courseOrders
     */
    public static void exportCvs(HttpServletResponse response ,List<AppointmentSign> appointmentSigns){
        try {
            response.reset();
            response.setContentType("application/csv;charset=GBK");
            response.setHeader("Content-Disposition",
                      "attachment;filename=Sign.csv");
            response.setCharacterEncoding("GBK");
            PrintWriter out = response.getWriter();
            out.print("姓名,联系电话,听课城市,签到时间 \r");
            for (AppointmentSign appointmentSign:appointmentSigns) {


                Date createDate =appointmentSign.getAppointmentTime();
                String date ="";
                if(createDate!=null){
                    SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
                    date =sdf.format(createDate);
                }
                String str = "\t"+appointmentSign.getUserName()+" ,"
                            +"\t"+appointmentSign.getPhone()+" ,"
                            +"\t"+appointmentSign.getCityName()+" ,"      
                            +"\t"+date;
                str = str.replace("null", "");
                out.print(str+"\r");
            }
            out.flush();
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static void exportCvs1(HttpServletResponse response ,List<MemberAccTicket> memberAccTickets){
        try {
            response.reset();
            response.setContentType("application/csv;charset=GBK");
            response.setHeader("Content-Disposition",
                      "attachment;filename=AppointMent.csv");
            response.setCharacterEncoding("GBK");
            PrintWriter out = response.getWriter();
            out.print("姓名,联系电话,听课城市,签到时间 \r");
            for (MemberAccTicket memberAccTicket:memberAccTickets) {


                Date createDate =memberAccTicket.getCreateDate();
                String date ="";
                if(createDate!=null){
                    SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
                    date =sdf.format(createDate);
                }
                String str = "\t"+memberAccTicket.getUserName()+" ,"
                            +"\t"+memberAccTicket.getMobile()+" ,"
                            +"\t"+memberAccTicket.getCityName()+" ,"
                            +"\t"+date;
                str = str.replace("null", "");
                out.print(str+"\r");
            }
            out.flush();
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static void exportCvs2(HttpServletResponse response ,List<MemberAccTicket> memberAccTickets){
        try {
            response.reset();
            response.setContentType("application/csv;charset=GBK");
            response.setHeader("Content-Disposition",
                      "attachment;filename=AppointMent.csv");
            response.setCharacterEncoding("GBK");
            PrintWriter out = response.getWriter();
            out.print("姓名,联系电话,听课城市,QQ,签到时间 \r");
            for (MemberAccTicket memberAccTicket:memberAccTickets) {


                Date createDate =memberAccTicket.getCreateDate();
                String date ="";
                if(createDate!=null){
                    SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
                    date =sdf.format(createDate);
                }
                String str = "\t"+memberAccTicket.getUserName()+" ,"
                            +"\t"+memberAccTicket.getMobile()+" ,"
                            +"\t"+memberAccTicket.getCityName()+" ,"
                            +"\t"+memberAccTicket.getEmail()+" ,"
                            +"\t"+date;
                str = str.replace("null", "");
                out.print(str+"\r");
            }
            out.flush();
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static boolean exportCsv(File file, List<String> dataList){
        boolean isSucess=false;

        FileOutputStream out=null;
        OutputStreamWriter osw=null;
        BufferedWriter bw=null;
        try {
            out = new FileOutputStream(file);
            osw = new OutputStreamWriter(out);
            bw =new BufferedWriter(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();
                } 
            }
        }

        return isSucess;
    }

    /**
     * 导入
     * 
     * @param file csv文件(路径+文件)
     * @return
     */
    public static List<String> importCsv(File file){
        List<String> dataList=new ArrayList<String>();

        BufferedReader br=null;
        try { 
            br = new BufferedReader(new FileReader(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();
                }
            }
        }

        return dataList;
    }
}