一种高效的javabea分页For SqlServer

<%@ page contentType="text/html;charset=GB2312"%>

<%@ page import="ite.com.*,java.util.*"%>

<%

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);

out.println("");

out.println("

");

for(int i=0;i

out.println("

");

}

out.println("

字段一	字段二
"+((java.util.ArrayList)rstlist.get(i)).get(0)+"	"+((java.util.ArrayList)rstlist.get(i)).get(2)+"

");

out.println("上一页");

out.println("下一页");

%>