oracle 笔记 VII 之 大数据量下的分页

 在ORACLE 大数据量下的分页解决方法。一般用截取ID 方法，还有是三层 嵌套方法

一种分页方法

<%

    int i = 1;

    int numPages = 14;

    String pages = request.getParameter("page");

    int currentPage = 1;

    currentPage = (pages == null)?1:Integer.parseInt(pages);

    sql = "select count(*) from tables";

    ResultSet rs = DBLink.executeQuery(sql);

    

    第36页 共 59 页

    while(rs.next())

     i = rs.getInt(1);

     int PageCount = 1;

     PageCount = (i%numPage == 0) ?(i/numPages):(i/numPages+1);

     int nextPage;

     int up Page;

     nextPage = currentPage + 1;

    if(nextPage > = PageCount)

     nextPage = PageCount;

     upPage = currentPage - 1;

     if(upPage <=1)

      upPage = 1;

      rs.close();

 

      sql="select * from tables";

      rs = DBLink.executeQuery(sql);

      i = 0;

      while((i<numPages*(currentPage-1)) && rs.next())

        { i++;}

 //输出内容

//输出翻页连接

 

合计：<%=currentPage%>/<%=intPageCount%>页

        <a href="List.jsp?page=1">第一页</a>

        <a href="List.jsp?page=<%=upPage%>">上一页</a>

 

<%

      for(int j=1;j<PageCount;j++){

          if(currentPage != j)

           {

 %>

    }else{

     out.println(j);

 

       }

 }

%>

 

<a href="List.jsp?page=<%=nextPage%>">下一页</a>

<a href="List.jsp?page=<%=PageCount%>">最后页</a>

 

%>