一、添加依赖到pom.xml

             
                 
      
       commons-io
                  
      
       commons-io
                  
      
       2.6
              
             
             
                 
      
       org.apache.commons
                  
      
       commons-csv
                  
      
       1.6
              
     

二、上代码

package com.yungoal.dbtest.tools;import org.apache.commons.csv.CSVFormat;import org.apache.commons.csv.CSVPrinter;import org.apache.commons.io.FileUtils;import java.io.FileWriter;import java.io.IOException;import java.util.List;public class CsvOutputTool {    /**     * 写入csv文件     * @param headers  列头     * @param data     数据内容     * @param filePath 创建的csv文件路径     **/    public static void writeCsv(Object[] headers, List
     
       data, String filePath) throws IOException {//初始化csvformat        CSVFormat formator = CSVFormat.DEFAULT.withRecordSeparator("\n");        //创建FileWriter对象        FileWriter fileWriter = new FileWriter(filePath, true);        //创建CSVPrinter对象        CSVPrinter printer = new CSVPrinter(fileWriter, formator);        //写入列头数据        printer.printRecord(headers);        if (null != data) {            //循环写入数据            for (Object[] lineData : data) {                printer.printRecord(lineData);            }        }        fileWriter.flush();        printer.close(true);        fileWriter.close();    }}