1 @RequestMapping("/downLoadByDate.do") 2 public String downLoadByDate(HttpServletRequest request, HttpServletResponse response){ 3 4 logger.info("sdfsdfs"); 5 String startTime = request.getParameter("startTime"); 6 String endTime = request.getParameter("endTime"); 7 8 SearchPojo sp = new SearchPojo(); 9 sp.setStartTime(startTime); 10 sp.setEndTime(endTime); 11 12 Page page = new Page(); 13 List list = wqinfoService.downLoadByDate(sp, page); 14 15 try { 16 //PrintWriter out = response.getWriter(); 17 String title="旺旺id,实体店地址,创店时间,商品名称,图片地址,商品价格,销售量,店铺级别,店铺地址\n"; 18 String contents=""; 19 WqInfo wqinfo = new WqInfo(); 20 for(int i=0;i<list.size();i++){ 21 wqinfo = (WqInfo) list.get(i); 22 contents+=wqinfo.getWangwang()+","+wqinfo.getAddress().toString()+","+wqinfo.getCreateStoreTime().toString()+ 23 ","+wqinfo.getName()+","+wqinfo.getImgURL()+","+wqinfo.getPrice()+","+wqinfo.getSellCount()+ 24 ","+wqinfo.getStoreLevel()+","+wqinfo.getStroeURL()+"\n"; 25 } 26 27 OutputStream o = null; 28 response.setContentType("application/download;charset=UTF-8"); 29 response.setContentType("Content-type:application/vnd.ms-excel;charset=UTF-8"); 30 response.setHeader("Content-disposition","attachment;filename=\"WQinfo" + startTime+"--"+endTime + ".csv\""); 31 o = response.getOutputStream(); 32 o.write((title+contents).toString().getBytes("GBK")); 33 //out.print(title+title2); 34 } catch (IOException e) { 35 // TODO Auto-generated catch block 36 e.printStackTrace(); 37 } 38 39 return null; 40 }
response返回一个csv,实现下载功能,布布扣,bubuko.com
原文:http://www.cnblogs.com/zlqlpp/p/3579691.html