数据库数据存到本地EXCEL

    private static final String basicDataExcelPath = "/F:/基础数据.csv";


    public static void writebasicDataCsvFile( List<ExportDataRes> input) throws Exception {
        File writeFile = new File(basicDataExcelPath);
        BufferedWriter bw = new BufferedWriter(new FileWriter(writeFile));
        bw.newLine();
        bw.write("时间,当日新增下载量,当日活跃总量,当日活跃登录总量,完成设备数,下载设备数");
        for (int i = 0; i < input.size(); i++) {
            bw.newLine();
            final ExportDataRes exportDataRes = input.get(i);
            bw.write(exportDataRes.getTime()+","+exportDataRes.getNewDownloadCount()+","+
                    exportDataRes.getActiveDevice()+","+exportDataRes.getActivePhone()+","+exportDataRes.getASOFinish()+","+exportDataRes.getASODownload());
        }
        bw.flush();
        bw.close();
    }