我用javaBean 写过这样的 也页面 就是从下拉框里选择表名 然后在当前页面输出 你看看
也是动态输出的 一个lib数据库 下面有三个表 分别是 reader book borrow
servlet代码如下
package com.bean;
import java.sql.*;
public class DataBaseQuery
{
String tableName="";
String result="";
public DataBaseQuery(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(Exception e){
e.printStackTrace();
}
}
public String getTableName()
{
return tableName;
}
public void setTableName(String tableName)
{
this.tableName = tableName;
}
public String getResult()
{
if(!tableName.equals("")){
Connection con=null;
Statement stm=null;
ResultSet rs=null;
StringBuffer buffer=new StringBuffer();
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost;databasename=lib;","sa","123456");
stm=con.createStatement();
String cmd="select * from "+tableName;
rs=stm.executeQuery(cmd);
int colNum=rs.getMetaData().getColumnCount();//表格列数
buffer.append("<table border=1 cellpadding=5>");
buffer.append("<tr>");
int i=1;
while(true){
String name=rs.getMetaData().getColumnName(i).toString();
buffer.append("<td>"+name+"</td>");
i++;
if(i>colNum) break;
}
buffer.append("</tr>");
while(rs.next()){
buffer.append("<tr>");
for(i=1;i<=colNum;i++){
buffer.append("<td>"+rs.getString(i)+"</td>");
}
buffer.append("</tr>");
}
buffer.append("</table>");
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs!=null&&stm!=null&&con!=null){
rs.close();
stm.close();
con.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
result=new String(buffer);
}
return result;
}
public void setResult(String result)
{
this.result = result;
}
}
jsp页面如下
<%@ page language="java" import="java.util.*,com.bean.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'showTable.jsp' starting page</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>
<form action="" method="post">
<select name="tableSelected">
<option value="reader">读者信息</option>
<option value="book">书籍信息</option>
<option value="borrow">借阅信息</option>
</select>
<input type="submit" name="g" value="查询"/>
</form>
<jsp:useBean id="database" class="com.bean.DataBaseQuery" scope="request"></jsp:useBean>
<jsp:setProperty name="database" property="tableName" param="tableSelected"/>
<p>您选择的表是</p>
<jsp:getProperty name="database" property="tableName"/>
<p>查询到的数据是</p>
<jsp:getProperty name="database" property="result"/>
</body>
</html>