jsp页面数据导出

最新推荐文章于 2021-06-21 03:08:28 发布

dijiu8050

最新推荐文章于 2021-06-21 03:08:28 发布

阅读量548

点赞数

文章标签： java javascript json ViewUI

原文链接：http://www.cnblogs.com/Xuesk/p/7097313.html

版权

1、jsp页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.8.3.js"></script>
    <script type="text/javascript">
        $(function(){
            $("#queryByName").click(function(){
                var name=$(this).prev().val();
                location.href="${pageContext.request.contextPath}/employee/queryByName?name="+name;
            });
            $("#import").click(function(){
                var array=$("input[type=checkbox]:checked");
                if(array.length==0){
                    alert("请选择您要导出的数据...");
                }else{
                    var ids=new Array();
                    array.each(function(){
                        ids.push($(this).parent().next().text());
                    });
                    $.post("${pageContext.request.contextPath}/employee/queryByIds","ids="+ids,function(d){
                        if(d=="ok"){
                            alert("数据导入成功！");
                        }else{
                            alert("数据导入失败！");
                        }
                        location.reload();
                    },"json");
                }
            });
        });
    </script>
</head>

<body>
   <div>
       姓名：<input type="text" name="name"/><input type="button" value="查询" id="queryByName"/>
           <input type="button" value="导出" id="import"/>
   </div>
    <table border="1" width="80%">
       <tr>
           <th>选择</th>
           <th>序号</th>
           <th>姓名</th>
           <th>职位</th>
           <th>薪资</th>
           <th>部门</th>
       </tr>
       <c:forEach items="${requestScope.list }" var="e">
           <tr>
               <td><input type="checkbox"></td>
               <td>${e.id }</td>
               <td>${e.name }</td>
               <td>${e.position }</td>
               <td>${e.salary }</td>
               <td>${e.department.name }</td>
           </tr>
       </c:forEach>
    </table>
</body>
</html>

2、controllerl类

@RequestMapping("queryByIds")
   @ResponseBody
   public String queryByName(Model model,String[] ids) throws Exception{
       FileOutputStream outputStream =null;
       OutputStreamWriter writer=null;
       BufferedWriter writer2=null;
       try {
           int[] idss=new int[ids.length];
           for(int i=0;i<ids.length;i++){
               idss[i]=Integer.parseInt(ids[i]);
           }
           List<Employee> list = es.queryByIds(idss);
           outputStream = new FileOutputStream(new File("D://employees.txt"));
           writer=new OutputStreamWriter(outputStream, "utf-8");
           writer2 = new BufferedWriter(writer);
           for (Employee employee : list) {
               writer2.write(employee.getId()+"#"+employee.getName()+"#"+employee.getPosition()+"#"+employee.getSalary()+"#"+employee.getDepartment().getName());
               writer2.newLine();
           }
           return "ok";
       } catch (Exception e) {
           return "error";
       }finally{
           writer2.close();
           writer.close();
           outputStream.close();
       }
   }
}

转载于:https://www.cnblogs.com/Xuesk/p/7097313.html

dijiu8050

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
jsp页面数据导出

1、jsp页面<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><%String path = request.getContextPath...
复制链接

扫一扫