如何使用jsp将在javabean中取得的recordset显示出来？

<%
   ResultSet rst = null;
   String sqlstr;

   sqlstr = .......;
   rst = DbBean.ExecuteSqlQuery(sqlstr);
   rst.last();
   int count = rst.getRow();

   if(count > 0)
   {
      rst.beforeFirst();
   %>
    <table>
         <tr>
           <td>test<td>
         </tr>
   <%
      while(rst.next())
      {
          String testValue = rst.getString("test");
    %>
         <tr>
           <td><%=testValue%></td>
         </tr>
    <%
      }
    %>
     </table>
  <%
   }
   else
   {
       out.println("暂无数据");
   }
   %>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

简单的说吧，
ResultSet rs;
让你的rs不为空，然后
如果要显示的内容是String类型的就用
System.out.print(rs.getString(1));
如果是int类型的就用
System.out.print(rs.getInt(2));
就是这样的方式，其他类型的你可以自己推理了。
后边括号里的数字是字段所在的位置，从1开始。
如果不知道是第几个用名字也可以，例如一个String类型的，字段名叫NAME就可以是
System.out.print(rs.getString("NAME"));
别忘记了引号。
<%@ page contentType="text/html; charset=GBK" %>
<html>
<head>
<title>
MyJsp
</title>
</head>
<jsp:useBean id="MyJspBeanId" scope="session" class="myprj.MyJspBean" /><body>
<h1>
JBuilder Generated JSP
</h1>
<form method="post">
<br>Enter new value   :  <input name="sample"><br>
<br><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
<br>
Value of Bean property is :<jsp:getProperty name="MyJspBeanId" property="sample" />
</form><jsp:useBean id="DbBean" scope="session" class="myprj.MyBean" />
<br>
value is:<jsp:getProperty name="DbBean" property="value" />
<%
  ResultSet Rs = null;//////////////////////这里有错，不能定义
  String Sql = "select * from customer";  Rs = DbBean.DbQuery( Sql );
  out.println( Rs.getRow() );%>
</body>
</html>
出错信息
"MyJsp.jsp": Error #: 300 : class ResultSet not found in class MyJsp_0002ejsp_jsp at line 27
<%@ page import="java.sql.*" %>
错误：
Apache Tomcat/4.0.3 - HTTP Status 500 - Internal Server Errortype Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.exception javax.servlet.ServletException: Result set type is TYPE_FORWARD_ONLY
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:463)
at org.apache.jsp.MyJsp$jsp._jspService(MyJsp$jsp.java:153)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
root cause java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
at sun.jdbc.odbc.JdbcOdbcResultSet.last(JdbcOdbcResultSet.java:2228)
at org.apache.jsp.MyJsp$jsp._jspService(MyJsp$jsp.java:135)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
jsp源码：
<%@ page contentType="text/html; charset=GBK" import="java.sql.*" %>
<html>
<head>
<title>
MyJsp
</title>
</head>
<jsp:useBean id="MyJspBeanId" scope="session" class="myprj.MyJspBean" /><body>
<h1>
JBuilder Generated JSP
</h1>
<form method="post">
<br>Enter new value   :  <input name="sample"><br>
<br><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
<br>
Value of Bean property is :<jsp:getProperty name="MyJspBeanId" property="sample" />
</form><jsp:useBean id="DbBean" scope="session" class="myprj.MyBean" />
<br>
value is:<jsp:getProperty name="DbBean" property="value" />
<%
  String Sql = "select * from customer";
  ResultSet Rs = DbBean.DbQuery( Sql );  Rs.last();
  out.println( Rs.getRow() );  Rs.first();
  while( Rs.next() )
  {
    System.out.println( Rs.getString("Company"));
  }%>
</body>
</html>
我的bean源码：
package myprj;import java.sql.*;
import java.io.*;public class MyBean {
  private String value = "only a test";  public void setValue(String AValue)
  {
    value = AValue;
  }
  public String getValue()
  {
    return value;
  }  public ResultSet DbQuery(String Sql)
  {
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection Cnn = DriverManager.getConnection("jdbc:odbc:BorlandDemoDb","admin","");
      Statement Stmt = Cnn.createStatement();
      ResultSet Rs = Stmt.executeQuery( Sql );
      return Rs;
    }
    catch( Exception e )
    {
      System.out.println( "my bean's error:" + e.getMessage() );
    }
    return null;
  }
}