本文实例讲述了JSP实现从数据库导出数据到Excel下载的方法。分享给大家供大家参考,具体如下:
关键代码:
//response.setHeader("Content-disposition","inline; filename=videos.xls");
response.setHeader("Content-disposition","attachment; filename=test.xls");
//以上这行设定传送到前端浏览器时的档名为test.xls
//就是靠这一行,让前端浏览器以为接收到一个excel档
%>
简单测试例子:
//response.setHeader("Content-disposition","inline; filename=videos.xls");
response.setHeader("Content-disposition","attachment; filename=test.xls");
//以上这行设定传送到前端浏览器时的档名为test.xls
//就是靠这一行,让前端浏览器以为接收到一个excel档
%>
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 testid | name |
List users2=um.getUserList();
for(int i=0;i
{
int t_id2=users2.get(i).getId();
String t_name2=users2.get(i).getName();
%>
}
%>
希望本文所述对大家JSP程序设计有所帮助。