导出csv格式的文件

import java.io.FileWriter;  import java.io.IOException;    public class CsvExporter {        public static void main(String[] args) {          String csvFile = "path/to/your/file.csv";          FileWriter writer = null;            try {              writer = new FileWriter(csvFile);                // 写入标题行              String header = "Column1,Column2,Column3";              writer.append(header);              writer.append('\n');                // 写入一些数据              String data1 = "Data1";              String data2 = "Data2";              String data3 = "Data3";                String line = data1 + "," + data2 + "," + data3;              writer.append(line);              writer.append('\n');                // 这只是一个例子，你可以根据需要添加更多数据                System.out.println("CSV file was created successfully !!!");            } catch (Exception e) {              System.out.println("Error in CsvFileWriter...");              e.printStackTrace();          } finally {              try {                  writer.flush();                  writer.close();              } catch (IOException e) {                  System.out.println("Error while flushing/closing writer...");                  e.printStackTrace();              }          }      }  }

List<List<Object>> dataList=new ArrayList<>();            for (TestEntitytestEntity:            addTest) {                List<Object> data= new ArrayList<>();                data.add(testEntity.getName());                data.add(testEntity.getUserid());                if (stringListMap.size()>0){                    data.add(stringListMap.get(testEntity.getOwOpenid()).getPhone());                    data.add(stringListMap.get(testEntity.getOwOpenid()).getNickName());                }                dataList.add(data);            }
// poi导出csv            List<Object> headList=new ArrayList<>();            headList.add("name");            headList.add("userId");            headList.add("phone");            headList.add("nickname");      Date date = new Date();            String format = new SimpleDateFormat("yyyy-mm-dd").format(date);            String hh = new SimpleDateFormat("HH").format(date);            String fileName=format+"快照数据"+hh;            CSVUtil.createCSVFile(response,headList,dataList,fileName);

package com.zkys.product.common.utils;
import javax.servlet.http.HttpServletResponse;import java.io.*;import java.net.URLEncoder;import java.util.List; /** * * CSV文件导出工具类 * * @author qixin * @description TODO * @data 2018/7/10 19:25 * Version 1.0 */public class CSVUtil{     /**     * CSV文件生成方法     * @param     * @param head     * @param dataList     * @param filename     */    public static void createCSVFile(HttpServletResponse response, List<Object> head, List<List<Object>> dataList,                                     String filename) {        File csvFile = null;        BufferedWriter csvWtriter = null;        InputStream in = null;        OutputStream out = null;        try {            csvFile=new File("./"+filename+".csv");
            // GB2312使正确读取分隔符","            csvWtriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(                    csvFile), "GBK"), 1024);
            // 写入文件头部            writeRow(head, csvWtriter);             // 写入文件内容            for (List<Object> row : dataList) {                writeRow(row, csvWtriter);            }            csvWtriter.flush();
            in = new FileInputStream(csvFile);            int len = 0;            byte[] buffer = new byte[1024*1024*5];            out = response.getOutputStream();            response.reset();
            // 设置此response为文件下载响应            response.setContentType("application/csv;charset=UTF-8");            response.setHeader("Content-Disposition",                    "attachment; filename=" + URLEncoder.encode(csvFile.getName(), "UTF-8"));            response.setCharacterEncoding("UTF-8");            // 先写UTF-8文件标志头            out.write(new byte[] { (byte) 0xEF, (byte) 0xBB, (byte) 0xBF });            while ((len = in.read(buffer)) > 0) {                out.write(buffer, 0, len);            }            out.flush();        } catch (Exception e) {            e.printStackTrace();        } finally {            try {                if (in != null) {                    in.close();                }                if (out != null) {                    out.close();                }                if (csvFile != null) {                    csvFile.delete();                }                if (csvWtriter != null) {                    csvWtriter.close();                }            } catch (IOException e) {                e.printStackTrace();            }        }    }     /**     * 写一行数据方法     * @param row     * @param csvWriter     * @throws IOException     */    private static void writeRow(List<Object> row, BufferedWriter csvWriter) throws IOException {        // 写入文件头部        for (Object data : row) {            StringBuffer sb = new StringBuffer();            String rowStr = sb.append("\"").append(data).append("\",").toString();            csvWriter.write(rowStr);        }        csvWriter.newLine();    }}