txt 导出数据

最新推荐文章于 2024-10-05 15:32:05 发布

v6351270

最新推荐文章于 2024-10-05 15:32:05 发布

阅读量487

点赞数

文章标签： date list string 任务工具手机

本文链接：https://blog.csdn.net/v6351270/article/details/7755957

版权

List<VisitPlayLog> list = visitPlayLogService.findVisitPlayLogList(cond);//数据
  String dateStr = DateUtil.changeDateToStr(new Date(), DateUtil.DEFAULT_SHORT_DATE_FORMAT);//时间工具
  response.setContentType("application/x-download");
  response.addHeader("Content-Disposition","attachment;filename=VisitPlayLog"+dateStr+".txt");
  BufferedWriter fw;

  fw = new BufferedWriter(new OutputStreamWriter(response.getOutputStream(), "utf-8"));     //设置写内容的编码格式
  fw.write("任务ID,手机号码,页面地址,播放时长,状态");
  fw.newLine();
  for (VisitPlayLog visitPlayLog : list) {

   fw.write(visitPlayLog.getTaskId().intValue()+",");
   fw.write(visitPlayLog.getPhone()+",");
   int index = visitPlayLog.getVisitPageLogs().indexOf("http://");
   fw.write(visitPlayLog.getVisitPageLogs().substring(index)+",");
   fw.write(visitPlayLog.getPlayLength()+",");
   long status = visitPlayLog.getPageStatus();
   if(status == 0)
    fw.write("成功");
   if(status == 1)
    fw.write("访问页面失败");
   if(status == 2)
    fw.write("获取RTSP失败");
   if(status == 3)
    fw.write("播放视频失败");
   fw.newLine();// 断行

  }
  fw.flush();
  fw.close();