主页 > 编程资料 > JSP(JAVA) >
发布时间:2016-01-01 作者:网络 阅读:182次

本文实例讲述了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"); 
 %> 
 
 
  
   
  spring jdbc test 
   
   
     
   
   
   
  
  

<% List users2=um.getUserList(); for(int i=0;i <% } %>
id name
<%=t_id2 %> <%=t_name2 %>

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

关键字词:JSP编程  

必填

◎已有0人评论

加载更多