一種高效的javabea分頁ForSqlServer

一種高效的Javabea分頁For SqlServer
    <%@ page contentType="text/html;charset=GB2312"%>
    <%@ page import="ite.com.*,java.util.*"%>
    
    
    <%
    java.util.List rstlist=new java.util.ArrayList();
    //數(shù)據(jù)庫連接池初始化
    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實現(xiàn)分頁顯示
    //String sql=select top 每頁顯示記錄數(shù) * from tablename where id not in(select top 每頁顯示記錄數(shù)*(顯示當(dāng)前頁-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("下一頁");
    %>