Java 导出txt文件

83 篇文章 0 订阅
54 篇文章 0 订阅

例子一

/**
	 * 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);
	     		//把内容写入文件
	     		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();  
                    }  
                }  
         }
  
    }  


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值