📄 browsetable.jsp
字号:
<!-- BrowseTable.jsp -->
<%@ page import = "chapter27.DBBean" %>
<jsp:useBean id="dBBeanId" scope="session" class="chapter27.DBBean" >
</jsp:useBean>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>BrowseTable</TITLE>
</HEAD>
<BODY>
<%String tableName = request.getParameter("tablename");
ResultSet rsColumns = dBBeanId.getConnection().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.getConnection().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>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -