李海洋导出excel功能.docVIP

/** * @author 李海洋 * @version taodou 1.0 * @time 2013/12/17 * @params null * @return null */ @SuppressWarnings(serial) public class ExportCashExcelAction extends BaseAction{ @Resource private ExportCashService exportCashService; private ListObject records; public ListObject getRecords() { return records; } public void setRecords(ListObject records) { this.records = records; } public ExportCashService getExportCashService() { return exportCashService; } public void setExportCashService(ExportCashService exportCashService) { this.exportCashService = exportCashService; } /** * @function 跳转到导出现金券界面 * @author 李海洋 * @version taodou 1.0 * @time 2013/12/17 * @params null * @return exportList */ @SuppressWarnings(rawtypes) public String findCashCoupon(){ Map loginInfo = (Map) request.getSession().getAttribute(loginInfo); String accountId=loginInfo.get(accountId).toString(); ListAccount list=this.exportCashService.findByAccountId(accountId); PageView pageView = this.exportCashService.findIntegralListByPage(page, pageSize,list.get(0).getAgentId()); request.setAttribute(pageView, pageView); request.setAttribute(page, page); return exportList; } /** * @function 导出现金券到Excel * @author 李海洋 * @version taodou 1.0 * @time 2013/12/18 * @params null * @return null */ @SuppressWarnings({ rawtypes }) public String exportToExcel(){ Map loginInfo = (Map) request.getSession().getAttribute(loginInfo); String accountId=loginInfo.get(accountId).toString(); ListAccount list=this.exportCashService.findByAccountId(accountId); //获取导出的表头和数据 //获取表头,存放到ArrayList filedName对象中(序号 用户名 积分 现金券面额 数量 是否发放 ) ArrayList filedName =exportCashService.getExcelFiledNameList(); ArrayList filedData =exportCashService.updateExcelFiledDataList(list.get(0).getAgentId()); HttpServletResponse response=ServletActionContext.getResponse();