程序如下: 
 <jsp:useBean id="sqlBean" scope="page" class="guestbook.Sql"/>
  <%
    String name,email,content,ptime,sql,p;
int i=0,pagesize=5,tpage,pagecount,a=1,count=0;
p=request.getParameter("page");
if (p==null)
 tpage=1;
    else
  tpage=Integer.parseInt(p);    
if(tpage<=0)
 tpage=1;
sql="select name,email,content,ptime from guestbook order by id desc";
ResultSet rs;
rs=sqlBean.pageselect(sql,"sa","55555",pagesize,tpage);
count=sqlBean.getCount();
    pagecount=sqlBean.getPageCount();
    while(rs!=null && !rs.isAfterLast() && i<pagesize){

name=new String(rs.getString("name").getBytes("8859_1"));
email=new String(rs.getString("email").getBytes("8859_1"));
content=new String(rs.getString("content").getBytes("8859_1"));
ptime=new String(rs.getString("ptime").getBytes("8859_1"));
  %>
  <tr>
    <td style="border-bottom:1px solid #000000">
  <div><%=name%> 于 <%=ptime%> 留言到:</div>
  <div><textarea name="" rows="" cols="60" style="font-size:12px;overflow-y:visible;line-height:150%;padding:5;font-family:verdana" readonly><%=content%></textarea></div>
</td>
  </tr>
  <%  
rs.next();  
i+=1;  
    }
  %>
  <tr bgcolor=#EAB68A>
    <td style="padding-top:8">共有 <%=count%> 条记录 共 <%=pagecount%> 页
<span style="background-color:#cccccc;padding-top:2;padding-left:5;border:1px solid #000000">
<%
  for(a=1;a<pagecount+1;a++){
    String u="",eu="";
if (a!=tpage){
      u="<a href=index.jsp?page="+a+">";
  eu="</a>"; 
    }
      out.print(u+String.valueOf(a)+eu+" ");
  }
%></span></td>
  </tr>