数据库浏览分页功能

<%
   Connection con;
   Statement sql;
   ResultSet rs;
   try{
    Class.forName("com.mysql.jdbc.Driver");  
   }catch(ClassNotFoundException e)
   {
   out.print("类找不到！");
   }
   try{
     con=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp","root","7056503");
     sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.TYPE_FORWARD_ONLY);
     rs=sql.executeQuery("select * from usertable");
     int countRecord=0;//记录总数
     int countPageRecord=0;//每页记录数
     int countPage=0;//总页数
     countPageRecord=5;//每页五条
     rs.last();//得到记录总数
     countRecord=rs.getRow();
     if(countRecord%countPageRecord==0)
      countPage=countRecord/countPageRecord;
     else
     countPage=countRecord/countPageRecord+1;
    
     if((dipage-1)*countPageRecord==0)
     rs.beforeFirst();
     else
     rs.absolute((dipage-1)*countPageRecord) ;
     out.print("<table Border class=datalist align=center >");
     out.print("<tr><td colspan=8 align=center>用户数据</td>");
     out.print("<tr>");
       out.print("<td width=100>用户ID </td>");
         out.print("<td width=50 >用户名 </td>");
           out.print("<td width=60>用户姓名 </td>");
             out.print("<td width=40 >年龄 </td>");
               out.print("<td width=40 >性别</td>");
                 out.print("<td width=60 >联系地址</td>");
                   out.print("<td width=100 >联系电话 </td>");
                     out.print("<td width=75>添加时间 </td>");
                      
     out.print("</tr>");
     int i=0;
     while(rs.next())
     {out.print("<tr>");
          out.print("<td >"+rs.getLong(1)+"</td>");
          out.print("<td >"+rs.getString(2)+"</td>");
          out.print("<td >"+rs.getString(3)+"</td>");
          out.print("<td >"+rs.getInt("age")+"</td>");
          out.print("<td >"+rs.getString("sex")+"</td>");
          out.print("<td >"+rs.getString("address")+"</td>");
          out.print("<td >"+rs.getString("tel")+"</td>");
          out.print("<td >"+rs.getString("settime")+"</td>");
         
     out.print("</tr>");
     i++;
     if(i>=countPageRecord) break; //当前页显示完，则退出循环；
     }
     out.print("<tr><td colspan=8 align=center>");
     out.print("共"+countRecord+"条记录， 共"+countPage+"页， 当前第"+dipage+"页，每页"+countPageRecord+"条记录，");
     if(dipage==1)//当前是首页
     ;
     else//当前不是首页
     {
     out.print("<a href=userpage1.jsp?dipage=1>首页</a>,");
     out.print("<a href=userpage1.jsp?dipage="+(dipage-1)+">上一页</a>,");
     }
     if(dipage==countPage)//当前是末页
     ;
     else
     {
     out.print("<a href=userpage1.jsp?dipage="+(dipage+1)+">下一页</a>,");
     out.print("<a href=userpage1.jsp?dipage="+countPage+">末页</a>");
     }
    
     out.print("</td></tr>");
     out.print("</table>");
     con.close();
    
   }catch(SQLException e1)
   {
    out.print("sql异常！");
   }
    %>