<%@ page contentType="text/Html;charset=GB2312"%> <%@ page import="ite.com.*,java.util.*"%> <title>分頁(yè)顯示ForSQLServer使用Select分頁(yè)</title> <style type="text/CSS"> <!-- table { background-color: #000000;} td {background-color: #FFFFFF;} --> </style> <% java.util.List rstlist=new java.util.ArrayList(); //數(shù)據(jù)庫(kù)連接池初始化 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實(shí)現(xiàn)分頁(yè)顯示 //String sql=select top 每頁(yè)顯示記錄數(shù) * from tablename where id not in(select top 每頁(yè)顯示記錄數(shù)*(顯示當(dāng)前頁(yè)-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);
