本文實(shí)例講述了JSP實(shí)現(xiàn)從數(shù)據(jù)庫(kù)導(dǎo)出數(shù)據(jù)到Excel下載的方法。分享給大家供大家參考，具體如下：
關(guān)鍵代碼：
%@ page contentType="application/msexcel" %>
%
//response.setHeader("Content-disposition","inline; filename=videos.xls");
response.setHeader("Content-disposition","attachment; filename=test.xls");
//以上這行設(shè)定傳送到前端瀏覽器時(shí)的檔名為test.xls
//就是靠這一行，讓前端瀏覽器以為接收到一個(gè)excel檔
%>
簡(jiǎn)單測(cè)試?yán)樱?/p>
%@ 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");
//以上這行設(shè)定傳送到前端瀏覽器時(shí)的檔名為test.xls
//就是靠這一行，讓前端瀏覽器以為接收到一個(gè)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>
希望本文所述對(duì)大家JSP程序設(shè)計(jì)有所幫助。
您可能感興趣的文章:- 使用IDEA編寫(xiě)jsp時(shí)EL表達(dá)式不起作用的問(wèn)題及解決方法
- springMVC如何將controller中Model數(shù)據(jù)傳遞到j(luò)sp頁(yè)面
- 實(shí)例解析JSP中EL表達(dá)式的各種運(yùn)用
- JSP入門(mén)之HelloWorld程序?qū)嵗?/li>
- JSP上傳excel及excel插入至數(shù)據(jù)庫(kù)的方法
- JSP 不能解析EL表達(dá)式的解決辦法
- JSP EL表達(dá)式詳細(xì)介紹
- jsp 不支持EL表達(dá)式，解決辦法
- JSP頁(yè)面無(wú)法識(shí)別EL表達(dá)式問(wèn)題解決方案
