springBoot 数据库内容导出成Excel

最新推荐文章于 2024-08-14 09:40:46 发布

能像风一样

最新推荐文章于 2024-08-14 09:40:46 发布

阅读量2k

点赞数 2

本文链接：https://blog.csdn.net/qxl288882/article/details/123056790

版权

Apache POI Java Excel导出数据库学生信息

关键词由CSDN通过智能技术生成

java 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

第一步：依赖

 <!--      数据库表导出成 Excel -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>

第二步：html页面

 <div> <a href="#"  class="btn btn-primary squer-btn sm-btn" onclick="DownExcel()">点击下载所有学生信息表</a></div>

第三步：js代码块

<script>
  function DownExcel(){
    window.location.href="DownLoadExcel";
  }
</script>

第四步：service层

 //查询所有然后去下载
    public List<DiscountTable> all(){
        return  mapper.selectByExample(null);
    }

第五步：controller层

 //点击下载excel 表格
    @RequestMapping(value = "/DownLoadExcel", method = RequestMethod.GET)
    public void downAll(HttpServletResponse response)throws Exception{
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("信息表");
        List<StudentTable> classmateList = studentService.findAllStu();
        //设置要导出的文件的名字
        String fileName = "1"+ ".xls";
        //新增数据行，并且设置单元格数据
        int rowNum = 1;
        String[] headers = { "学生id", "姓名","密码", "学校名称", "所学专业","学号","学习的课程","学生手机号"};
        //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 (StudentTable table : classmateList) {
            HSSFRow row1 = sheet.createRow(rowNum);
            row1.createCell(0).setCellValue(table.getStuId());
            row1.createCell(1).setCellValue(table.getStuName());
            row1.createCell(2).setCellValue(table.getStuPwd());
            row1.createCell(3).setCellValue(table.getStuSchoolName());
            row1.createCell(4).setCellValue(table.getStuMajor());
            row1.createCell(5).setCellValue(table.getStuStudyNum());
            row1.createCell(6).setCellValue(table.getStuStudyCourse());
            row1.createCell(7).setCellValue(table.getStuPhone());
            rowNum++;
        }
        response.setContentType("application/octet-stream");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName);
        response.flushBuffer();
        workbook.write(response.getOutputStream());
    }