Java 导出txt文件

来源:互联网 发布:掌上电力显示网络问题 编辑:程序博客网 时间:2024/05/22 04:15

例子一

/** * export导出文件 */@RequestMapping(value="/grab/export/csv",method={RequestMethod.GET})public void exportCsv(HttpServletRequest request,HttpServletResponse response){String userId = ServletRequestUtils.getStringParameter(request, "userId", "test");ModelAndView mav=new ModelAndView();SqlVideoList sqlVideoList =new SqlVideoList();List<VideoListModel> list = new ArrayList<VideoListModel>();try {list = sqlVideoList.selectSuccessDate(userId);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}        //导出txt文件        response.setContentType("text/plain");           String fileName="videolist";try {fileName = URLEncoder.encode("videolist", "UTF-8");} catch (UnsupportedEncodingException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}            response.setHeader("Content-Disposition","attachment; filename=" + fileName + ".txt");            BufferedOutputStream buff = null;               StringBuffer write = new StringBuffer();               String enter = "\r\n";               ServletOutputStream outSTr = null;               try {                    outSTr = response.getOutputStream();  // 建立                    buff = new BufferedOutputStream(outSTr);     //把内容写入文件     if(list.size()>0){     for (int i = 0; i < list.size(); i++) {       write.append(list.get(i).getUrl()+",");       write.append(list.get(i).getTitle());       write.append(enter);               }      }             buff.write(write.toString().getBytes("UTF-8"));                    buff.flush();                    buff.close();               } catch (Exception e) {                   e.printStackTrace();               } finally {                   try {                       buff.close();                       outSTr.close();                   } catch (Exception e) {                       e.printStackTrace();                  }              }        }

例子二:

    /**     * 导出VIP兑换码。     * @throws UnsupportedEncodingException      */    @RequestMapping(value = "/{exchangeId}/{packageId}/export", method = RequestMethod.GET)    public void writeToTxt(@PathVariable String exchangeId,@PathVariable String packageId, HttpServletRequest request,HttpServletResponse response) throws UnsupportedEncodingException {          String schoolId = this.getSchoolId(request); // 网校ID        // 获取网校的VIP套餐相应的兑换码        VipCodeExample example=new VipCodeExample();        example.createCriteria().andSchoolIdEqualTo(schoolId).andPackageIdEqualTo(packageId).andExchangeIdEqualTo(exchangeId);        List<VipCode> vipCodes = vipExchangeManager.getVipCode(example);                       if(vipCodes.size()>0){                response.setContentType("text/plain");// 一下两行关键的设置                  response.addHeader("Content-Disposition",                          "attachment;filename="+java.net.URLEncoder.encode(vipCodes.get(0).getName(),"UTF-8")+".txt");// filename指定默认的名字                                 VipCode vipcode=new VipCode();                BufferedOutputStream buff = null;                  StringBuffer write = new StringBuffer();                  String tab = "      ";                  String enter = "\r\n";                  ServletOutputStream outSTr = null;                  try {                      outSTr = response.getOutputStream();// 建立                      buff = new BufferedOutputStream(outSTr);                      for (int i = 0; i < vipCodes.size(); i++) {                          vipcode =  vipCodes.get(i);                          write.append(i+1); //序号                         write.append(tab);                        write.append(vipcode.getExchangeCode());                         write.append(tab);                        if("normal".equals(vipcode.getStatus())){                            write.append("正常");                                  }else{                            write.append("已兑换");                                  }                        write.append(enter);                    }                      buff.write(write.toString().getBytes("UTF-8"));                      buff.flush();                      buff.close();                  } catch (Exception e) {                      e.printStackTrace();                  } finally {                      try {                          buff.close();                          outSTr.close();                      } catch (Exception e) {                          e.printStackTrace();                      }                  }           }      }  


0 0