java导出csv

导出数据
public  boolean exportCsv(File file, List<String> dataList ,String checkUser ,BigCustomerOrderVo vo){
    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();
            }
        }
    }
    try {
        FlowLogPo flowLogPo = new FlowLogPo("project","",checkUser,"大客户订单导出操作", com.jd.payment.paycommon.utils.GsonUtils.toJson(vo));
        flowLogDao.insertFlowLog(flowLogPo);
    } catch (Exception e) {
        logger.error("大客户订单导出操作,插入日志流水表异常",e);
    }
    return isSucess;
}



输出并下载
    public static void outputNewExcel (HttpServletRequest req, HttpServletResponse response, String filename, String path) {
        response.setHeader ("Content-Transfer-Encoding", "binary");
        response.setHeader ("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
        response.setHeader ("Pragma", "public");
        response.setHeader ("Pragma", "no-cache"); // 禁止数据缓存。
        response.setDateHeader ("Expires", 0);
        response.setContentType ("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");// 设置响应的类型格式为电子表格格式
        response.setHeader ("Content-disposition", "attachment;filename="
                + filename);

        try {
            ServletOutputStream sos = response.getOutputStream ();
            File f = new File (path + filename);
            FileInputStream fi = new FileInputStream (f);
//            byte[] buf = new byte[(int) f.length ()];
//            fi.read(buf, 0, (int) f.length());
//            sos.write (buf);
            byte[] buf = new byte[1024*4];
            int sizetag =0;
            while ((sizetag= fi.read (buf, 0, 1024*4))!=-1){
                sos.write (buf,0,sizetag);
            }
            sos.flush();
            fi.close();
            sos.close();
        } catch (Exception e) {
            e.printStackTrace ();
        } finally {
            File f = new File (path + filename);
            if (f.exists ()) {
                f.delete ();
            }
            System.gc();
        }
    }