JSP实现的Java通用简单分页算法

如果您喜欢这些文章，欢迎点击此处订阅本Blog

<script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470";/* 728x90, 大横幅正文上方 */google_ad_slot = "4725362798";google_ad_width = 728;google_ad_height = 90;// --></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>

这段代码被广泛转载，在此仅作收藏之用。

Jsp如下：**********************<%@ page language="java" import="java.util.*,java.sql.*" %><%@ page contentType="text/html;charset=gb2312"%><jsp:useBean id="cn" scope="page" class="myConnection.Conn" /><!--引用数据库操作的bean，自己完成，这里不再赘述--><%int curpage=1;//当前页int page_record=20;//每页显示的记录数//用下面的方法（sql查询完成，速度快）curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页ResultSet rs=cn.rsexecuteQuery("select top " page_record " * from tablename where id not in (select top " (curpage*page_record) " id from tablename order by id desc) order by id desc");//本查询语句得到的是所要显示的1000页的20条记录，大致思路为——子查询排除需要显示的记录前的所有记录，父查询则对余下的记录进行降序排列while(rs.next) {out.println(rs.getInt("id").toString());}rs.close();%>

<script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470";/* 728x90, 大横幅正文下方 */google_ad_slot = "4725362798";google_ad_width = 728;google_ad_height = 90;// --></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>

<script type="text/javascript"><!-- google_ad_client = "pub-7343546549496470";/* 468x15 横链接单元 */google_ad_slot = "5785741422";google_ad_width = 468;google_ad_height = 15;// --></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>