下载页面信息的两种方式

最新推荐文章于 2023-07-03 16:34:16 发布

LvJinYang

最新推荐文章于 2023-07-03 16:34:16 发布

阅读量491

点赞数 3

文章标签：下载

本文链接：https://blog.csdn.net/LvJinYang/article/details/96022071

版权

下载页面信息的两种方式

js实现下载为Excel 表格

<table border="0" cellspacing="0" cellpadding="0" id="item">
   <thead >
   <td>姓名</td>
   <td>年龄</td>
   <td>生日</td>
   <td>电话</td>
   <td>QQ</td>
   <td>学生班级</td>
   <td>学生小组</td>
   <td>学生就业城市</td>
   <td>学生标签</td>
<c:if test="${login.role=='0'}">
   <td>操作</td>
</c:if>
   </thead>

<c:forEach items="${students}" var="s">

   <tr>
      <td>${s.name}</td>
      <td>${s.age}</td>
      <td><fmt:formatDate value="${s.bir}"/></td>
      <td>${s.tel}</td>
      <td>${s.qq}</td>
      <td>${s.clazz.name}</td>
      <td>${s.team.name}</td>
      <td>${s.city.name}</td>
      <td><c:forEach items="${s.tag}" var="t">${t.name}&nbsp;&nbsp;</c:forEach></td>
      <c:if test="${login.role=='0'}">
      <td><a href="${pageContext.request.contextPath }/student/findOne?&id=${s.id}">详细</a>|<a href="${pageContext.request.contextPath }/student/remove?&id=${s.id}">删除</a>|<a href="${pageContext.request.contextPath }/student/beforeUpdate?&id=${s.id}">修改</a></td>
      </c:if>
   </tr>
</c:forEach>


</table>

<hr/>
   <script type="text/javascript">
      function base64 (content) {
         return window.btoa(unescape(encodeURIComponent(content)));
      }
      /*
        *@tableId: table的Id
        *@fileName: 要生成excel文件的名字（不包括后缀，可随意填写）
        */
      function tableToExcel(tableID,fileName){
         var table = document.getElementById(tableID);
         var excelContent = table.innerHTML;
         var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
         excelFile += "<head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head>";
         excelFile += "<body><table>";
         excelFile += excelContent;
         excelFile += "</table></body>";
         excelFile += "</html>";
         var link = "data:application/vnd.ms-excel;base64," + base64(excelFile);
         var a = document.createElement("a");
         a.download = fileName+".xls";
         a.href = link;
         a.click();
      }
   </script>

<a href="" id="a1"  onclick="tableToExcel('item','学生信息表')">导出学生信息</a>

后台java代码实现信息的下载

//    导出学生信息
    public void exportStudentInfo() throws IOException {
        List<Student> studentList = studentService.queryAll();
        StringBuilder sb = new StringBuilder();
        studentList.forEach(s->{
            sb.append(s.toString());//把遍历出来的学生拼接到一起
            sb.append("\n");//拼接一个换行
        });
        // 将字符串转为流                                                                       必须大写
        ByteArrayInputStream bis = new ByteArrayInputStream(sb.toString().getBytes("UTF-8"));
        HttpServletResponse response = ServletActionContext.getResponse();
        //请求头
        response.setHeader("content-disposition","attachment;fileName="+ URLEncoder.encode("学生信息.txt","UTF-8"));
        ServletOutputStream ots = response.getOutputStream();
        IOUtils.copy(bis,ots);//流的copy
        IOUtils.closeQuietly(bis);
        IOUtils.closeQuietly(ots);
    }

LvJinYang

关注

3
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
下载页面信息的两种方式

下载页面信息的两种方式js实现下载为Excel 表格<table border="0" cellspacing="0" cellpadding="0" id="item"> <thead > <td>姓名</td> <td>年龄</td> <td>生日</td> &lt...
复制链接

扫一扫