mybatis plus 导出sql_springBoot+mybatisPlus+hutool 实现输入sql导出 excel表格

支持pom包

com.baomidou

mybatis-plus-boot-starter

3.1.1

cn.hutool

hutool-all

4.5.10

org.apache.poi

poi-ooxml

3.17

rest代码

@GetMapping(value = "download")public voiddownload(String sqlString, HttpServletResponse response) throws IOException {

List> hashMaps =checkOrderService.invokeSql(sqlString);//Map row1 = new LinkedHashMap<>();//row1.put("姓名", "张三");//row1.put("年龄", 23);//row1.put("成绩", 88.32);//row1.put("是否合格", true);//row1.put("考试日期", DateUtil.date());//

//Map row2 = new LinkedHashMap<>();//row2.put("姓名", "李四");//row2.put("年龄", 33);//row2.put("成绩", 59.50);//row2.put("是否合格", false);//row2.put("考试日期", DateUtil.date());

ArrayList> rows =(ArrayList) hashMaps;//通过工具类创建writer，