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

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

程序员文章站 2022-05-18 12:37:39
本文实例讲述了jsp实现从数据库导出数据到excel下载的方法。分享给大家供大家参考,具体如下: 关键代码: <%@ page contenttype="...

本文实例讲述了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档 
%>

简单测试例子:

<%@ 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下载的方法

希望本文所述对大家jsp程序设计有所帮助。