1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| //前段的js代码 //报告的导出 $("#export").click(function(){ //这个是一个form表单对象 var condition=$("#searcherCondition").serialize(); //实现一个普通的请求 $.download( "${ctx}/ReportManager/exportExcel", condition, "Get" ); }); //后端的java代码: //这个是使用easypoi的到处excel的数据,所以需要的参数比较多,但是主要的参数主要是那个实体类dto,完成参数接收。有人可能会疑惑为什么我采用requestMapping的注解,没有指定GEt或者post的请求方法:这里说明一下request不会区分post和get方法,而这个方法取决于前段的请求。 @RequestMapping("exportExcel") public void exportExcel(ModelMap map, HttpServletResponse response, HttpServletRequest request,PhysicalExaminerDto physicalExaminerDto){ PtYgbm00 principal = (PtYgbm00)SecurityUtils.getSubject().getPrincipal(); physicalExaminerDto.setEmployeeId(principal.getYgbh00().toString()); physicalExaminerDto.setHospitalNo(principal.getYybh00()); List<PhysicalExaminerPoi> examinerPOI = physicalExaminerService.getExaminerPOI(physicalExaminerDto); ExportParams exportparams = new ExportParams("体检者","体检者"); map.put(NormalExcelConstants.DATA_LIST, examinerPOI); map.put(NormalExcelConstants.CLASS, PhysicalExaminerPoi.class); map.put(NormalExcelConstants.FILE_NAME, "体检者信息"); map.put(NormalExcelConstants.PARAMS, exportparams); PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);
}
|