java 入门测试代码(spring boot 15) MyBatis 生成数据导出excel

在mybatis 里边查询出数据，想导出怎么办？

 

1.

pom.xml 加入：

<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>4.0.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-web</artifactId>
    <version>4.0.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-annotation</artifactId>
    <version>4.0.0</version>
</dependency>

2. DO 头上边加入数据：

@Excel(name = "姓名", orderNum = "0")
private String name;

@Excel(name = "性别", replace = {"男_1", "女_2"}, orderNum = "1")
private String sex;

@Excel(name = "生日", exportFormat = "yyyy-MM-dd", orderNum = "2")
private Date birthday;

3. 导出：

void main(){
            List<userDO> user = userPapper.selectStats(date);
            String ret = exportExcel(user,date,"当天的数据",userDO.class,filename,response);
}

4. 函数字义：

    public static String exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,String fileName,boolean isCreateHeader, HttpServletResponse response){
        ExportParams exportParams = new ExportParams(title, sheetName);
        exportParams.setCreateHeadRows(isCreateHeader);
        return defaultExport(list, pojoClass, fileName, response, exportParams);
    }

    public static String exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,String fileName, HttpServletResponse response){
        return defaultExport(list, pojoClass, fileName, response, new ExportParams(title, sheetName));
    }

    private static String defaultExport(List<?> list, Class<?> pojoClass, String fileName, HttpServletResponse response, ExportParams exportParams) {
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams,pojoClass,list);
        if (workbook != null) {
            return downLoadExcel(fileName, response, workbook);
        }
        return "defaultExport error";
    }

    private static String downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
        try {
            response.reset();
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));

            OutputStream out = response.getOutputStream();
            workbook.write(out);
            out.flush();
        } catch (IOException e) {
            return e.getMessage();
        }

        return "下载成功！";
    }

可以了，调用后自动下载到浏览器的下载路径。