一种高效的Javabea分页For SqlServer
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="ite.com.*,java.util.*"%>
分页显示ForSQLServer使用Select分页
<%
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("
%>