87,907
社区成员
发帖
与我相关
我的任务
分享紧急求助，我想在这个页面中将table的内容导出成excel格式和word文档的文件，可以用excel和word打开，应该怎么做，希望有完整的参考代码
我这个table里的内容是从数据库里查出来的整张表，
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import = "com.excel.bean.DbAccess" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dBBeanId" scope ="session" class = "com.excel.bean.DbAccess">
</jsp:useBean>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>显示数据库数据表</title>
<style type="text/css">
#navmenu-primary {
position: relative;
z-index: 2;
margin-bottom: 34px;
min-width: 990px;
height: 80px;
border-bottom: 1px solid #343738;
background: #303030;
line-height: 80px;
}
#navmenu-primary .navmenu-primary-content {
position: relative;
display: block;
height: 80px;
}
.grid-full {
width: 100%;
}
.clearfix::after {
display: block;
visibility: hidden;
clear: both;
height: 0;
content: ".";
}
Inherited from div#navmenu-primary
#navmenu-primary {
line-height: 80px;
}
html, body, div, span, figure, h1, h2, h3, h4, p, a, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, article, aside, details, figure, figcaption, footer, header, hgroup, nav, section, img {
font: inherit;
font-size: 100%;
}
Inherited from body
body {
color: #414141;
font: 12px/16px 'Open Sans',sans-serif;
}
#navmenu-primary {
line-height: 80px;
}
#navmenu-primary .navmenu-left .nav-item.first {
border-left: none;
}
#navmenu-primary .nav-item {
position: relative;
display: block;
float: left;
height: 80px;
withth:230px;
}
html, body, div, span, figure, h1, h2, h3, h4, p, a, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, article, aside, details, figure, figcaption, footer, header, hgroup, nav, section, img {
margin: 0;
padding: 0;
border: 0;
vertical-align: baseline;
font: inherit;
font-size: 100%;
}
#navmenu-primary {
line-height: 80px;
}
body {
color: #414141;
font: 12px/16px 'Open Sans',sans-serif;
}
#navmenu-primary .nav-item-logo .nav-text {
position: relative;
top: -12px;
}
html, body, div, span, figure, h1, h2, h3, h4, p, a, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, article, aside, details, figure, figcaption, footer, header, hgroup, nav, section, img {
margin: 0;
padding: 0;
border: 0;
vertical-align: baseline;
font: inherit;
font-size: 100%;
}
user agent stylesheetdiv {
display: block;
}
Inherited from a.nav-item-logo-link.nav-sprite.nav-sprite-logo
.nav-sprite-logo {
text-indent: -99999px;
}
#navmenu-primary {
line-height: 80px;
line-withth: 230px;
}
#navmenu-primary .navmenu-right {
right: 20px;
}
#navmenu-primary .navmenu-left, #navmenu-primary .navmenu-right {
position: absolute;
top: 0;
height: 80px;
width:230px;
}
.right {
float: right;
}
.clearfix {
display: block;
}
.left {
float: left;
}
.clearfix {
display: block;
}
ol, ul, dl {
margin: 0;
padding: 0;
}
html, body, div, span, figure, h1, h2, h3, h4, p, a, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, article, aside, details, figure, figcaption, footer, header, hgroup, nav, section, img {
margin: 0;
padding: 0;
border: 0;
vertical-align: baseline;
font: inherit;
font-size: 100%;
}
user agent stylesheetul, menu, dir {
display: block;
list-style-type: disc;
-webkit-margin-before: 1em;
-webkit-margin-after: 1em;
-webkit-margin-start: 0px;
-webkit-margin-end: 0px;
-webkit-padding-start: 40px;
}
Pseudo ::after element
.clearfix::after {
display: block;
visibility: hidden;
clear: both;
height: 0;
content: ".";
}
#d03 {
background-color:#FDF5E6;
margin : 60px 400px 20px 300px;
padding: 10px 10px 40px 10px;
}
#body01 {
background-color:#FAEBD7;
}
</style>
</head>
<body id="body01">
<div id="navmenu-primary" class="">
<div class="navmenu-primary-content grid-full clearfix">
<div class="navmenu-left left clearfix">
<div id="nav_item_logo" class="nav-item nav-item-logo clearfix first">
<!-- <a class="nav-item-logo-link nav-sprite nav-sprite-logo" >
<img src="F:\2.jpg" width="" height="">
</a> -->
<a class="navbar-brand" href="DBLogin.html"><strong><font
size=5 color=#da5867>校园管理员</font></strong><font color=#FAEBD7>查询数据库</font></a>
</div>
</div>
<div class="navmenu-right right clearfix">
<ul class="left nav-large nav-items clearfix">
<li id="nav-item-question" class="nav-item nav-item-question clearfix">
<span class="nav-link"><a href="http://jwc.jit.edu.cn/" class="nav-btn-question" target="_blank">教务处</a></span>
</li>
</ul>
</div>
</div>
</div>
<div id="d03">
<%String tableName=request.getParameter("tablename");
ResultSet rsColumns = dBBeanId.getConn().getMetaData().getColumns(null,null,tableName,null);
%>
<table border="1">
<tr>
<%
//Add column names to the table
while(rsColumns.next()){%>
<td><%= rsColumns.getString("COLUMN_NAME") %></td>
<%} %>
</tr>
<% Statement statement =dBBeanId.getConn().createStatement();
ResultSet rs = statement.executeQuery(
"select * from " + tableName);
//Get column count
int columnCount =rs.getMetaData().getColumnCount();
//Store rows to rowData
while(rs.next()){
out.println("<tr>");
for(int i =0;i<columnCount;i++){%>
<td><%= rs.getObject(i+1) %></td>
<% }
out.println("</tr>");
} %>
</table>
</div>
</body>
</html>
...全文
请发表友善的回复…
发表回复
