数据导出功能

​​​​​​​

private void  export(String sheetName, String fileName, List<Map<String,Object>>  listDate, LinkedHashMap<String,String> linkMap)
        throws  Exception{
    //linkedHashMap的键存做英文，值存做中文
    if(linkMap.size()!=listDate.get(0).size()){
        System.out.println("导出"+fileName+"===失败");
        return;
    }
    List<String>  titlelist=new ArrayList<>();
    List<String>  keyList=new ArrayList<>();
    Set<Map.Entry<String, String>> entries = linkMap.entrySet();
    for(Map.Entry<String,String> entrie : entries){
        titlelist.add(entrie.getValue());
        keyList.add(entrie.getKey());
    }

    HSSFWorkbook wb = new HSSFWorkbook();//创建对象文档
    HSSFSheet sheet = wb.createSheet(sheetName);//创建excel表单
    //生成字体对象
    HSSFFont font = wb.createFont();
    font.setFontHeightInPoints((short)12);
    font.setFontName("新宋体");

    //生成单元格样式对象
    HSSFCellStyle style = wb.createCellStyle();
    style.setFont(font);//将字体样式添加到单元格
    //style.setWrapText(true);//设置是否换行
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//设置居中样式

    //创建表头
    HSSFRow row = sheet.createRow(0);
    for(int i=0;i<titlelist.size();i++){
        HSSFCell cell = row.createCell(i);
        cell.setCellValue(titlelist.get(i));
        cell.setCellStyle(style);
    }

    for(int j=0;j<listDate.size();j++){
        HSSFRow rowx = sheet.createRow(j + 1);
        Map map = listDate.get(j);
        for(int k=0;k<keyList.size();k++){
            HSSFCell cellx = rowx.createCell(k);
            cellx.setCellStyle(style);
            cellx.setCellValue(String.valueOf( map.get(keyList.get(k))));
        }

    }
    FileOutputStream out = new FileOutputStream("D:"+fileName+".xls");
    wb.write(out);
    System.out.println("导出"+fileName+"===成功");
    out.close();


}

 

 

public  List<Map<String, Object>> selectAllFeedBackProblemList()throws  Exception{
    Map<String,Object>  map =null;
    List<Map<String, Object>> resultList= managerMapper.selectAllFeedBackProblemList();
    // seqID,proTitle,proType,proContent,proProgress,submitter,CONVERT(varchar(10),submitTime,20) as submitTime
    LinkedHashMap<String,String> paramMap = new LinkedHashMap<>();
    paramMap.put("seqID","编号");
    paramMap.put("proTitle","标题");
    paramMap.put("proType","类型");
    paramMap.put("proContent","内容");
    paramMap.put("proProgress","进度");
    paramMap.put("submitter","作者");
    paramMap.put("submitTime","时间");


    export("用户问题反馈", "用户反馈数据统计", resultList,
            paramMap);
    return  resultList;
}