导出数据我用的是poi导出excel文件在pom文件中引入
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<!-- poi-ooxml XSSF is our port of the Microsoft Excel XML (2007+) file format (OOXML) to pure Java -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.17</version>
</dependency>
获取任意表名和表中的字段参考文章
Mybatis 动态传sql可以查询表名,任意表名,不固定字段的个数返回未定义的类型以及增删改
之后再controller层引用
@ApiOperation(value = "导出任意表中的数据", notes = "")
@GetMapping("/executeTableInfo")
@SystemControllerLog(title = "导出数据",businessType = BusinessType.EXPORT)
public void executeTableInfo(@RequestParam("tableName")String tableName,HttpServletRequest request,
HttpServletResponse response) throws IOException {
List<Map<String, String>> maps = managerTableService.executeTableInfo(tableName);
List<String> tableCloumName = managerTableService.getTableCloumName("'"+tableName+"'");
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet=workbook.createSheet(tableName);
//设置导出的文件的名字
String filename=tableName+".xls";
//创建表头
HSSFRow tablerow = sheet.createRow(0);
//循环添加表头数据
for (int i = 0; i < tableCloumName.size(); i++) {
HSSFCell cell=tablerow.createCell(i);
HSSFRichTextString text=new HSSFRichTextString(tableCloumName.get(i));
cell.setCellValue(text);
}
for (int i = 0; i < maps.size(); i++) {
// 一个List对象是一个Map,一行数据,一个Map对象对应一行里的一条数据
Map tableMap = maps.get(i);
//表头是第0行,所以从第一行开始创建
Row row = sheet.createRow(i + 1);
//循环创建单元格
for (int j = 0; j < tableCloumName.size(); j++) {
//获取指定字段的值,判断是否为空
Object object=tableMap.get(tableCloumName.get(j));
String val="";
if(object!=null){
val=object.toString();
}
row.createCell(j).setCellValue(val);
}
}
response.setContentType("application/octet-stream");
response.setHeader("Content-disposition", "attachment;filename="+filename);
try {
response.flushBuffer();
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}
这么写就可以导出任何表中的数据,亲测可行