一种高效的javabea分页for sqlserver <%@ page contenttype="text/html;charset=gb2312"%> <%@ page import="ite.com.*,java.util.*"%> <title>分页显示forsqlserver使用select分页</title> <style type="text/css"> <!-- table { background-color: #000000;} td {background-color: #ffffff;} --> </style> <% java.util.list rstlist=new java.util.arraylist(); //数据库连接池初始化 dbmanager dbm=new dbmanager(); dbm.setdatasource("java:comp/env/jdbc/lerp"); int pagesize=10; int pageno=0; if (request.getparameter("pageno")==null){ pageno=1; }else{ pageno=integer.parseint(request.getparameter("pageno")); if(pageno<=0){ pageno=1; } } //使用select实现分页显示 //string sql=select top 每页显示记录数 * from tablename where id not in(select top 每页显示记录数*(显示当前页-1) id from tablename) string sql="select top "+pagesize+" * from iokecontent where id not in(select top "+pagesize*(pageno-1)+" id from iokecontent where iokesort=54 order by id desc) and iokesort=54 order by id desc"; rstlist=dbm.querybypage_sql_quick(sql);
