Java Excel导出

前端jsp

   
      导出excel
   

js根据查询 字段填写下面的代码

$("#printExcelButton").click(function () {
    var buildFloorId = $.trim($("#buildFloorId").val());
    var parkId = $.trim($("#parkId").val());
    var cubicleNo = $.trim($("#cubicleNo").val());
    var workerName = $.trim($("#workerName").val());
    var workerType = 1;

    var url = basePath + "work/printExcelStationInfoList?workerName=" + workerName + "&parkId=" + parkId + "&cubicleNo=" + cubicleNo + "&buildFloorId=" + buildFloorId+ "&workerType=" + 1;
    window.location.href = encodeURI(url);
});

work/printExcelStationInfoList：调用后端路径

        work：controller层

 printExcelStationInfoList：

controller层

@GetMapping("/printExcelStationInfoList")
public String putExcelContent(HttpServletRequest request, HttpServletResponse httpServletResponse) throws Exception {
   workCubicleService.printExcelStationInfoList(request,httpServletResponse);
   return "SUCCESS";
}

service层

public void printExcelStationInfoList(HttpServletRequest request, HttpServletResponse response) throws Exception {
   String buildFloorId = request.getParameter("buildFloorId");//拿到前端数据
   String parkId = request.getParameter("parkId");
   String cubicleNo = request.getParameter("cubicleNo");
   String workerName = request.getParameter("workerName");
   String workerType = request.getParameter("workerType");

   Map queryParam = new HashMap();//定义一个map
   queryParam.put("buildFloorId", buildFloorId);//把数据存到map
   queryParam.put("parkId", parkId);
   queryParam.put("cubicleNo", cubicleNo);
   queryParam.put("workerName", workerName);
   queryParam.put("workerType", workerType);

   if (workerType == "1"){
      String fileName = "员工工位信息";
      List list = workCubicleMapper.selectWorkCubicle(queryParam);//从表中查询到信息存入WorkCubicle
      Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(fileName, fileName), WorkCubicle.class, list);
      String fileName2 = URLEncoder.encode("员工工位信息.xls", "UTF-8");
      response.setHeader("content-Type", "application/vnd.ms-excel");
      response.setHeader("Content-Disposition", "attachment;filename=" + fileName2);
      OutputStream outputStream = response.getOutputStream();//传到前端
      workbook.write(outputStream);
      outputStream.close();
      workbook.close();
   }else {
      String fileName = "厂商工位信息";//excel表名
      List list = workCubicleMapper.selectWorkCubicle(queryParam);
      Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(fileName, fileName), WorkCubicle.class, list);
      String fileName2 = URLEncoder.encode("厂商工位信息.xls", "UTF-8");//excel文件名
      response.setHeader("content-Type", "application/vnd.ms-excel");
      response.setHeader("Content-Disposition", "attachment;filename=" + fileName2);
      OutputStream outputStream = response.getOutputStream();
      workbook.write(outputStream);
      outputStream.close();
      workbook.close();
   }
}