jsp使用javabean实现分页问题？帮我测试，谢谢

Question

     public String getRsString()
          throws Exception
     {
  
  ResultSetMetaData md = rs.getMetaData();
          int colCount = md.getColumnCount();
          String colLabel[] = new String[colCount + 1];
          StringBuffer sb = new StringBuffer();
          sb.append("<table border=0 align=center>");
          sb.append("<tr class=title>");
          if(radio != null)
               sb.append("<td>&nbsp;</td>");
               sb.append("<td><b>#</b></td>");
          if(col != 0 && colCount > col)
               colCount = col;
          for(int i = 1; i <= colCount; i++)
          {
               colLabel[i] = md.getColumnLabel(i);
               sb.append(String.valueOf(String.valueOf((new StringBuffer("<td><b>")).append(colLabel[i]).append("</b></td>"))));
          }           sb.append("</tr>");
  
  //Seperating Page Transaction
  RsBeginLocation=PageSize*(PageNO-1);
  RsEndLocation=PageSize*PageNO;
  //取得总页数
  PageCount=((RsCount%PageSize)==0?(RsCount/PageSize):(RsCount/PageSize)+1);
  
  for(int i=0;i<RsBeginLocation;i++)
  {
   rs.next();
  }
  
    for(int k=RsBeginLocation+1; rs.next()&&(k<=RsEndLocation); k++,sb.append("</tr>"))
          {               if(k % 2 != 0)
                    sb.append(String.valueOf(String.valueOf((new StringBuffer("<tr class=detail align=left bgcolor=")).append(color1).append(" onMouseOver=mouseOver(this,'").append(color3).append("'); onMouseOut=mouseOut(this,'").append(color1).append("');>"))));
               else
                    sb.append(String.valueOf(String.valueOf((new StringBuffer("<tr class=detail align=left bgcolor=")).append(color2).append(" onMouseOver=mouseOver(this,'").append(color3).append("'); onMouseOut=mouseOut(this,'").append(color2).append("');>"))));
               if(radio != null)
               {
                    String tmp = "";
                    if(param != null)
                    {
                         for(int i = 0; i < param.length; i++)
                              tmp = tmp.equalsIgnoreCase("") ? rs.getString(param[i]) : String.valueOf(String.valueOf((new StringBuffer(String.valueOf(String.valueOf(tmp)))).append("#").append(rs.getString(param[i]))));                    }
                    sb.append(String.valueOf(String.valueOf((new StringBuffer("<td><input type=radio name=radio value=\"")).append(tmp).append("\" onclick=\"").append(radio).append("\"></td>"))));
               }
               if(images != null)
                    sb.append(String.valueOf(String.valueOf((new StringBuffer("<td><div align=left><image width=15,height=20 src=\"")).append(images).append("\">").append(k).append("</div></td>"))));
               else
                    sb.append(String.valueOf(String.valueOf((new StringBuffer("<td><div align=left>")).append(k).append("</div></td>"))));
               for(int i = 1; i <= colCount; i++)
               {
                    String s = rs.getString(i);
                    sb.append("<td><div align=left>");
                    boolean dourl = false;
                    boolean docolor = false;
                    if(color != null)
                    {
                         for(int j = 0; j < color.length; j++)
                              if(Integer.parseInt(color[j][0], 10) == i)
                              {
                                   docolor = true;
                                   sb.append(String.valueOf(String.valueOf((new StringBuffer("<font color=\"")).append(color[j][1]).append("\">"))));
                              }                    }
                    if(url != null)
                    {
                         for(int j = 0; j < url.length; j++)
                              if(Integer.parseInt(url[j][0], 10) == i)
                              {
                                   dourl = true;
                                   sb.append(String.valueOf(String.valueOf((new StringBuffer("<a href=\"")).append(url[j][1]).append("param1=").append(s).append("\" target=\"").append(target).append("\">"))));
                              }                    }
                    sb.append(s);
                    if(dourl)
                         sb.append("</a>");
                    if(docolor)
                         sb.append("</font>");
                    sb.append("</div></td>");
               }//  for 结束
          }// for; sb.append("</tr>" 结束  sb.append(String.valueOf(String.valueOf((new StringBuffer("<tr ><td colspan=")).append(colCount).append(" align=\"right\">"))));
 
 if(PageNO>1)
 {
    sb.append(String.valueOf(String.valueOf((new StringBuffer("<a href=\"javascript:")).append(FormName).append(".PageNO.value=").append(PageNO-1).append(";").append(FormName).append(".submit();\">&nbsp;Back<<</a>"))));
 }
 
 sb.append(String.valueOf(String.valueOf((new StringBuffer("Total&nbsp;")).append(PageCount).append("Pages&nbsp;"))));
 sb.append(String.valueOf(String.valueOf((new StringBuffer("Turn to<select name=\"PageNO\" onChange=\"javascript:")).append(FormName).append(".submit();\">"))));
 for(int p=1;p<=PageCount;p++)
 {
  if((PageNO-p)==0)
{
sb.append(String.valueOf(String.valueOf((new StringBuffer("<option value=\"")).append(p).append("\" selected>").append(p).append("</option>"))));
}
else
{
sb.append(String.valueOf(String.valueOf((new StringBuffer("<option value=\"")).append(p).append("\">").append(p).append("</option>"))));
}
 
 }
 sb.append("</select>Page");
 
 if(PageNO<PageCount)
 {
    sb.append(String.valueOf(String.valueOf((new StringBuffer("<a href=\"javascript:")).append(FormName).append(".PageNO.value=").append(PageNO+1).append(";").append(FormName).append(".submit();\">&nbsp;>>Next</a>"))));
 }
 
 sb.append("</td></tr>");
   
          sb.append("</table>");
          return sb.toString();
     }// throws Exception 结束
}//  implements Serializable 结束我的jsp程序，test.jsp
<%@page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.String"%>
<%@ page import="java.sql.ResultSet"%><jsp:useBean id="rsBean" scope="page" class="rs.RsBean" />
<html>
<head><title>test Multipage</title></head>
<body>
<%
out.print("hello , This is a test");
try 
 { 
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
 catch ( ClassNotFoundException e )
 {out.println("kfgd");
 }
 Connection con = DriverManager.getConnection("jdbc:odbc:testmulti");
 Statement stmt=con.createStatement();
 ResultSet  rs=stmt.executeQuery("select * from employee");
 rsBean.setRs(rs);
  String rsString = rsBean.getRsString();
 out.print(rsString);
 %>
</body>
</html>

Answer 1

小兄弟，不要为难大家了，没有人会愿意看这么一大堆代码的，还是结贴吧！