欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

JSP从数据库导出数据到Excel下载的实现

程序员文章站 2022-05-03 19:35:02
JSP从数据库导出数据到Excel下载的实现 关键代码: <%@ page contentType="application/msexcel" %&g...
JSP从数据库导出数据到Excel下载的实现

关键代码:

<%@ page contentType="application/msexcel" %>

<%

   //response.setHeader("Content-disposition","inline; filename=videos.xls");

   response.setHeader("Content-disposition","attachment; filename=test.xls");

   //以上这行设定传送到前端浏览器时的档名为test.xls

   //就是靠这一行,让前端浏览器以为接收到一个excel档 

%>

简单测试例子:

[java] view plaincopy

<%@ page language="java" import="java.util.*,java.io.*" pageEncoding="GBK"%>  

<%@ page contentType="application/msexcel" %>  

<%  

   //response.setHeader("Content-disposition","inline; filename=videos.xls");  

   response.setHeader("Content-disposition","attachment; filename=test.xls");  

   //以上这行设定传送到前端浏览器时的档名为test.xls  

   //就是靠这一行,让前端浏览器以为接收到一个excel档   

%>  

<%@ page import="org.springframework.web.context.WebApplicationContext"%>  

<%@ page import="com.test.*"%>  

<%@ page import="org.springframework.web.context.support.WebApplicationContextUtils"%>  

<%  

String path = request.getContextPath();  

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";  

%>  

<%  

WebApplicationContext ctx = WebApplicationContextUtils.getWebApplicationContext(this.getServletContext());  

UserManager um = (UserManager) ctx.getBean("userManager");  

 %>  

  

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  

<html>  

  <head>  

    <base href="<%=basePath%>">  

    <title>spring jdbc test</title>  

    <meta http-equiv="pragma" content="no-cache">  

    <meta http-equiv="cache-control" content="no-cache">  

    <meta http-equiv="expires" content="0">      

    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">  

    <meta http-equiv="description" content="This is my page">  

    <!--  

    <link rel="stylesheet" type="text/css" href="styles.css">  

    -->  

  </head>  

    

  <body>  

<br>  

<table border="1" width="100%">  

<tr> <td>id</td> <td>name</td>  

    </tr>  

<%  

  

        List<User> users2=um.getUserList();  

        for(int i=0;i<users2.size();i++)  

        {  

            int t_id2=users2.get(i).getId();  

            String t_name2=users2.get(i).getName();  

            %>  

            <tr>  

     <td><%=t_id2 %></td> <td><%=t_name2 %></td>  

    </tr>  

            <%  

  

        }  

     

 %>  

</table>  

  </body>  

</html>  

 

JSP从数据库导出数据到Excel下载的实现