JeeSite导出多条数据(加复选框)demo

 

表格图:

jsp:

 

 

后台:

@RequiresPermissions("shwindow:advertisementPutInList:view")
	@RequestMapping(value = "export", method=RequestMethod.POST)
	@ResponseBody
	public String exportFile(AdvertisementPutInList advertisementPutInList,HttpServletRequest request,String[] oddNumbers, HttpServletResponse response, RedirectAttributes redirectAttributes) {
		List<AdvertisementPutInList> list=new ArrayList<AdvertisementPutInList>();
		try {
			String fileName = "广告单数据"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx";
			if(oddNumbers!=null){//用户有勾选需要导出的数据记录
				for(int i=0;i<oddNumbers.length;i++){
				System.out.println(oddNumbers[i]+"&&&");		
				AdvertisementPutInList apils=advertisementPutInListService.getByDNum(oddNumbers[i]);
				//Page<AdvertisementPutInList>  page =advertisementPutInListService.findAdvertisementPutInList(new Page<AdvertisementPutInList>(request, response, -1), apils);
				list.add(apils);				
			}
				ExportExcel ExportExcel=new ExportExcel("广告单数据", AdvertisementPutInList.class).setDataList(list).write(response, fileName).dispose();
				}else {//用户没有勾选,则导出页面展示的数据记录
					Page<AdvertisementPutInList>  page = advertisementPutInListService.findAdvertisementPutInList(new Page<AdvertisementPutInList>(request, response, -1), advertisementPutInList);
					new ExportExcel("广告单数据", AdvertisementPutInList.class).setDataList(page.getList()).write(response, fileName).dispose();	
				}
		} catch (Exception e) {
			addMessage(redirectAttributes, "导出失败!失败信息:"+e.getMessage());
		}
		return "redirect:" + adminPath+"/shwindow/advertisementPutInList/?repage";
	}

  

posted @ 2017-08-05 15:41  ATJAVA  阅读(1397)  评论(0编辑  收藏  举报