首页 > 其他 > 详细

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

时间:2014-03-04 20:45:27      阅读:622      评论:0      收藏:0      [点我收藏+]
bubuko.com,布布扣
 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     }
bubuko.com,布布扣

response返回一个csv,实现下载功能,布布扣,bubuko.com

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

原文:http://www.cnblogs.com/zlqlpp/p/3579691.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!