response返回一个csv，实现下载功能 

 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     }

 

posted @ 2014-03-04 09:20  zlqlpp  阅读(1563)  评论(0)    收藏  举报