java分页

来源：互联网发布：json文件注释怎么写编辑：程序博客网时间：2024/05/17 03:41

<%
int dipage=1;//定义当前页
      String pages=request.getParameter("dipage");//本页的局部变量
      if(pages==null)//判断本页条件
      {
        pages="1";
      }
      try
      {
        dipage=Integer.parseInt(pages);

      }
      catch(Exception e)
      {
        dipage=1;
      }
%>
<%int countrecord=0;//总记录
        int countpagerecord=5;//每页的记录
        int countpage=0;//总页数
        ResultSet rs=null;//数据集
        SQL sql=null;//调用的SQL
        try
        {
         sql = new SQL("driver={Microsoft Access Driver (*.mdb)};DBQ=C://Documents and Settings//Administrator//My Documents//JSP//JSP//Exam.mdb", "Exam", "", "", 1);//调用类
         rs=sql.getData("select * from Teacher");//调用类
         rs.last();//把指针放到最后一行
          countrecord=rs.getRow();//得到总记录
          if(countrecord%countpagerecord==0)//判断总记录能否被页记录整除,若能,则直接整除否则出后加1
          countpage=countrecord/countpagerecord;
          else
          countpage=countrecord/countpagerecord+1;

          if((dipage-1)*countpagerecord==0)//若是第一页则返回到第一记录之前
          rs.beforeFirst();
          else
          rs.absolute((dipage-1)*countpagerecord);否则返回到本页最后一条记录
        }
        catch(SQLException e)
        {
        }
   try {
          //输出查询结果
          int i=0;
          while (rs.next()) {
            out.print("<tr>");
            out.print("<td align=center height=2 width='16%'>" + rs.getString("Tea_Number") + "</td>");
            out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Name") + "</td>");
            out.print("<td align=center height=2 width='16%'>" + rs.getString("Tea_Sex") + "</td>");
            out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Phone") + "</td>");
            out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Type") + "</td>");
            out.print("<td align=center height=2 width='10%'><a href=''>修改</a></td>");
            out.print("<td align=center height=2 width='10%'><a href=''>删除</a></td>");
            out.print("</tr>");
            i++;
            if(i>=countpagerecord)break;

          }
   out.print("<tr><td colspan='7' height=2 align=right>");
        out.print("一共的"+countrecord+"个教师基本信息,当前第"+dipage+"页");
         out.print("/b"+"/b"+"/b");
      if(dipage==1)//若是当前地一页
      {out.print("首页");
        out.print("上一页");
      }
      else
      {
        out.print("<a href=Main.jsp?dipage=1>首页</a>");否则执行
        if(dipage<=1)
         out.print("上一页");
         else
        out.print("<a href=Main.jsp?dipage="+(dipage-1)+">上一页</a>");

      }
      if(dipage==countpage)
      {
        out.print("下一页");
        out.print("末页");
      }
      else
      {
       out.print("<a href=Main.jsp?dipage="+(dipage+1)+">下一页</a>");
        out.print("<a href=Main.jsp?dipage="+countpage+">末页</a>");
      }
        out.print("</td></tr>");
        rs.close();