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程序设计有所帮助。