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> 
% 
    ListUser> users2=um.getUserList(); 
    for(int i=0;iusers2.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>