本文實(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ì)有所幫助。
標(biāo)簽：臨汾 白銀 自貢 吉林 山南 開(kāi)封 烏蘭察布 銅川
巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《JSP實(shí)現(xiàn)從數(shù)據(jù)庫(kù)導(dǎo)出數(shù)據(jù)到Excel下載的方法》，本文關(guān)鍵詞 JSP,實(shí)現(xiàn),從,數(shù)據(jù)庫(kù),導(dǎo)出,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
