SpringBoot将数据库信息导入到Excle表格中

service和mapper层代码如下：

//mapper接口代码

   @Select("select * from teacher")
    public List<Teacher> teacherinfor()
 
  //service层代码
    public List<Teacher> teacherinfor(){
    return teachermapper.teacherinfor();

//同时要建立一个Teacher实体类，类中存放的属性名要和导出的数据库中的表的属性名一样

后台Controller层代码如下：

@RequestMapping(value = "UserExcelDownloads", method = RequestMethod.GET)
 public void downloadAllClassmate(HttpServletResponse response) throws IOException {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("信息表");

    List<Teacher> classmateList = teacherservice.teacherinfor();

    String fileName = "userinf"  + ".xls";//设置要导出的文件的名字
    //新增数据行，并且设置单元格数据

    int rowNum = 1;

    String[] headers = { "学号", "姓名", "身份类型", "登录密码"};
    //headers表示excel表中第一行的表头

    HSSFRow row = sheet.createRow(0);
    //在excel表中添加表头

    for(int i=0;i<headers.length;i++){
        HSSFCell cell = row.createCell(i);
        HSSFRichTextString text = new HSSFRichTextString(headers[i]);
        cell.setCellValue(text);
    }

    //在表中存放查询到的数据放入对应的列
    for (Teacher teacher : classmateList) {
        HSSFRow row1 = sheet.createRow(rowNum);
        row1.createCell(0).setCellValue(teacher.getTno());
        row1.createCell(1).setCellValue(teacher.getTname());
        row1.createCell(2).setCellValue(teacher.getType());
        row1.createCell(3).setCellValue(teacher.getTpassword());
        rowNum++;
    }

    response.setContentType("application/octet-stream");
    response.setHeader("Content-disposition", "attachment;filename=" + fileName);
    response.flushBuffer();
    workbook.write(response.getOutputStream());
}

---

原文：https://blog.csdn.net/wilson_m/article/details/79021458