java导出为CSV文件

1.整理需要导出的实体类

//将取出的漂移数据导出到csv
public void exportCSV(Trip driftTripDetail) throws Exception {
    List<List<String>> contents = new ArrayList<>();
    List<String> result = new ArrayList<>();

    result.add(people.getName());
    result.add(String.valueOf(people.getAge()));
    contents.add(result);

    CsvExportUtil.doExport("people",contents,"姓名","年龄");
}

2.导出csv工具类

import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVPrinter;

import java.io.FileOutputStream;
import java.io.OutputStreamWriter;
import java.util.List;

/**
 * 项目名: tripscheck
 * 文件名: CsvExportUtil
 * 创建者: LCK
 * 创建时间:2021/8/17 14:53
 * 描述: TODO
 */
public class CsvExportUtil {
    /**
     * 将处理后的数据以CSV格式导出到本地
     * @throws Exception
     */
    public static void doExport(String tablename,  List<List<String>> contents,String... header) throws Exception {
        //设置文件存储位置，字符集格式
        FileOutputStream fileOutputStream = new FileOutputStream("D:\\data\\data_export\\"+tablename+".csv");
        OutputStreamWriter outputStreamWriter = new OutputStreamWriter(fileOutputStream, "GBK");
        //添加表头
        CSVFormat csvFormat = CSVFormat.DEFAULT.withHeader(header);
        CSVPrinter csvPrinter = new CSVPrinter(outputStreamWriter, csvFormat);
        //将数据循环放进csv文件中
        for (List<String> content : contents) {
            csvPrinter.printRecord(content);
        }

        csvPrinter.flush();
        csvPrinter.close();
    }
}