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

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模板