代码如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/><%
ResultSet rs=connBean.executeQuery("select * from v_board");
ResultSet rs_user=connBean.executeQuery("select * from tb_user where username='"+session.getAttribute("username")+"'and status='版主'");
ResultSet rs_reply=null;
ResultSet rs_topic=connBean.executeQuery("select * from tb_topic");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="CSS/style.css" rel="stylesheet">
<title>在水一方留言簿</title>
</head>
<body onLoad="clockon()">
<jsp:include page="top.jsp"/>
<table width="777" height="197"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="53%" height="5" valign="top"></td>
  </tr>
  <tr>
    <td valign="top"><table width="100%" height="171"  border="0" cellpadding="0" cellspacing="0" class="table">
      <tr>
        <td width="2%" height="26" background="images/bg_banner.GIF">&nbsp;</td>
        <td width="98%" background="images/bg_banner.GIF" class="word">≡查看留言≡</td>
      </tr>
      <tr valign="top">
        <td colspan="2">
<%
boolean tj=rs_user.next();
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=5;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);int Page=Integer.parseInt(str);
if(Page<1){
Page=1;
}else{
if(((Page-1)*pagesize+1)>RecordCount){
Page=maxPage;
}
}
rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++)
{
  %>
<table width="100%" height="192"  border="0" cellpadding="0" cellspacing="0" class="table_B">
          <tr align="center">
            <td width="115" rowspan="3" align="center"><%=rs.getString("UserName")%>(<%=rs.getString("status")%>)<p>
<%=rs.getString("sex")%>生
<p>
表情:<%=rs.getString("face")%>
</td>
            <td width="2" rowspan="3" align="center" valign="bottom"><hr size="100%" width="1px" color="#FFCCCC">
</td>
            <td width="447" align="left" style="padding-left:10pt"  class="word">
<img src="images/email.GIF" alt="Email:<%=rs.getString("email")%>" width="16" height="16">
 <img src="images/home-menu.gif" alt="个人主页:<%=rs.getString("homepage")%>" width="26" height="20">
 <img src="images/atusers.gif" alt="OICQ号码:<%=rs.getString("OICQ")%>" width="14" height="16">
 <img src="images/datetime.gif" alt="<%=rs.getString("datetime")%>" width="18" height="18">&nbsp;留言时间:<%=rs.getString("datetime")%></td>
            <td width="195" align="right" style="padding-left:10pt"  class="word">
 <% out.println("<a href='reply.jsp?TopicID="+rs.getInt("ID")+"'>回复&nbsp;</a>");
                        if(tj){out.println("<a href='Del.jsp?TopicID="+rs.getInt("ID")+"'>删除</a>");           }
%>
</td>
            <td width="14" align="right" style="padding-left:10pt"  class="word">&nbsp;</td>
          </tr>
          <tr>
            <td height="20" colspan="3" style="padding-left:10pt"><hr width="98%" color="#FFCCCC" size="1"></td>
          </tr>
          <tr>
            <td height="109" colspan="3" valign="top" style="padding-left:10pt"><pre><%=rs.getString("content")%></pre></td>
          </tr>
          <tr>
            <td height="2" colspan="5" align="center" valign="top" class="word"><hr width="98%" color="#FFCCCC" size="1"></td>
            </tr>            <%
              rs_reply=connBean.executeQuery("select * from tb_reply where TopicID="+rs.getInt("ID"));
              while(rs_reply.next())
  {
            %>
          <tr>
            <td height="39" align="center" valign="top" class="word"><%=rs_reply.getString("replyuser")%>回复</td>
            <td align="center" valign="top"><hr size="20%" width="1px" color="#FFCCCC"></td>
            <td colspan="3" valign="top" class="word" style="padding-left:10pt"><%=rs_reply.getString("content")%>
              <hr width="98%" color="#FFCCCC" size="1"></td>
          </tr>
          <tr>
            <td height="20" colspan="3" style="padding-left:10pt">&nbsp;</td>
          </tr>
  <%
  }
  %>
        </table> <br>
<%
try{
if(!rs.next()){break;}
}
catch(Exception e)
{}
}
%>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="right">当前页数:[<%=Page%>/<%=maxPage%>]&nbsp;
<%
if(Page>1){
%>
<a href="index.jsp?Page=1">第一页</a> <a href="index.jsp?Page=<%=Page-1%>">上一页</a>
<%
}
if(Page<maxPage)
{
%>
 <a href="index.jsp?Page=<%=Page+1%>">下一页</a> <a href="index.jsp?Page=<%=maxPage%>">最后一页&nbsp;</a>
<%
}
%>
</td>
  </tr>
</table>
</td>
        </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
报错:
exception org.apache.jasper.JasperException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
org.apache.jsp.me.index_jsp._jspService(index_jsp.java:243)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5699)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:410)
org.apache.jsp.me.index_jsp._jspService(index_jsp.java:116)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)