/** 
* 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 block 
   e.printStackTrace(); 
  } 
  //導出txt文件 
  response.setContentType("text/plain");  
  String fileName="videolist"; 
  try { 
   fileName = URLEncoder.encode("videolist", "UTF-8"); 
  } catch (UnsupportedEncodingException e1) { 
   // TODO Auto-generated catch block 
   e1.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); 
    //把內(nèi)容寫入文件 
    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); // 網(wǎng)校ID 
 // 獲取網(wǎng)校的VIP套餐相應(yīng)的兌換碼 
 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");// 一下兩行關(guān)鍵的設(shè)置
   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(); 
    } 
   } 
  } 
}