spring+strust2+mybatis框架下的导出功能的实现

àì夳堔傛蜴生んèń 2022-07-17 01:29 109阅读 0赞

1.html中：
    
    <button style="float: right" type="button" id="btnDownload"  class="btn btn-primary">导出</button>
    
    2.js中：
    
    //下载按钮绑定事件
    $("#btnDownload").bind("click", function() {        
        var iframe = document.createElement("iframe");
        iframe.src = "/CaiYiJia/detailPaymentOP_excelDataExport.do?";
        iframe.style.display = "none";
        document.body.appendChild(iframe);
    });
    
    3.Action:
    
    /**
         * excel导出加计扣除
         *
         * @return
         * @throws
         */
        public String excelDataExport() {
    
            log.info("方法excelDataExport开始");
    
            selectPagingAddDeduction();
            // 输入流定义
            InputStream in = null;
    
            try {
                // 获取对象一览的流定义
                in = this.getClass().getResourceAsStream(
                        "/template/additional_deduction_list.xls");
                // 读入模版到工作簿中
                HSSFWorkbook work = new HSSFWorkbook(in);
                // 表格定义
                HSSFSheet sheet = null;
                // 克隆sheet
                sheet = work.cloneSheet(0);
                // 设置该sheet的sheetName
                work.setSheetName(1, "加计扣除表");
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
                // 判断是否含有数据
                for (int i = 1; i < aaData.size() + 1; i++) {
    
                    // 如果行数>8行
                    if (i >= 2) {
                        // 从备份的表格中复制一行空行给当前表格
                        copyRow(sheet, work.getSheetAt(0), i, 1);
                    }
                    if (aaData.get(i - 1).getOrgVouDate() != null) {
                        sheet.getRow(i).getCell(0).setCellValue(sdf.format(aaData.get(i - 1).getOrgVouDate()));
                    }
                    sheet.getRow(i).getCell(1).setCellValue(aaData.get(i - 1).getOrgVouNo());
                    sheet.getRow(i).getCell(2).setCellValue(aaData.get(i - 1).getOrgVouSubject());
                    sheet.getRow(i).getCell(3).setCellValue(aaData.get(i - 1).getOrgVouAmount().toString());
                    if (aaData.get(i - 1).getWeightedDeductionFlag() == 1) {
                        sheet.getRow(i).getCell(4).setCellValue("是");
                    }
                    if (aaData.get(i - 1).getWeightedDeductionFlag() == 0) {
                        sheet.getRow(i).getCell(4).setCellValue("否");
                    }
                }
                // 删除第一个表格
                work.removeSheetAt(0);
    
                // 获取页面的响应信息
                HttpServletResponse response = ServletActionContext.getResponse();
                // 取得输出流
                OutputStream os = response.getOutputStream();
                response.setContentType("application/vnd.ms-excel");
                response.setHeader("Content-disposition","attachment;filename="+ java.net.URLEncoder.encode("additional_deduction_list", "UTF-8")+ ".xls");
                work.write(os);
                os.close();
                work.close();
                in.close();
                return null;
            } catch (FileNotFoundException ex) {
                ex.printStackTrace();
            } catch (IOException ex) {
                ex.printStackTrace();
            }
    
            log.info("方法excelDataExport结束");
    
            return SUCCESS;
        }
    
        /*
         * 复制sheet的指定行到操作表格的指定行
         *
         * @param sheet
         *
         * @param copySheet
         *
         * @param rowNum
         *
         * @param copyRowNum
         */
        private void copyRow(HSSFSheet sheet, HSSFSheet copySheet, int rowNum,
                int copyRowNum) {
            HSSFRow copyRow = copySheet.getRow(copyRowNum);
            HSSFRow row = sheet.createRow(rowNum);
            Iterator<Cell> iter = copyRow.cellIterator();
            while (iter.hasNext()) {
                HSSFCell copyCell = (HSSFCell) iter.next();
                int index = copyCell.getColumnIndex();
                HSSFCell cell = row.createCell(index);
                cell.setCellStyle(copyCell.getCellStyle());
                cell.setCellType(copyCell.getCellType());
                cell.setCellValue(copyCell.getStringCellValue());
            }
        }
    
    4.项目中建一个文件夹放Excel模板