分页`

[color=black][color=white] 分页sql代码


String sql="select top "+pageRowCount+" * from mybook ";
sql+="where bid not in(select top "+(currentPage-1)*pageRowCount+ " bid from mybook) ";
sql+=" order by bid" ;

if(bname!=null){
sql="select top "+pageRowCount+" * from mybook " +
"where bid not in(select top "+(currentPage-1)*pageRowCount+ " bid from mybook) "+
" and bname like '%"+bname+"%' order by bid ";

}

分页菜单
StringBuffer bf=new StringBuffer();
for(int i=1;i<=this.pagecount;i++){
bf.append("<option value="+i+">"+i+"</option>");
}
str.append("<table><tr><td>共<font color=red>"+pagecount+"</font>页 " +
"第<font color=red>"+curpage+"</font>页 <a href="+f.getUrl()+
"?curpage=1>首页</a> <a href="+f.getUrl()+"?curpage="+(this.curpage-1)+">上一页</a>" +
" <a href="+f.getUrl()+"?curpage="+(this.curpage+1)+">下一页</a> " +
"<a href="+f.getUrl()+"?curpage="+pagecount+">尾页</a> " +
"跳至<select name=size onchange=change(this.value)>"+bf.toString()+"</select>页</td></tr></table>");


pageCount=recordCount%pageRowCount==0?recordCount/pageRowCount:recordCount/pageRowCount+1;

hibernate分页 

(currentPage-1)*ss  ss:为size  可设置hibernate分页中的  setFirst...
String hql="from Book b order by b.bid";
Query q=sn.createQuery(hql);
q.setFirstResult((currentPage-1)*showCount);
q.setMaxResults(showCount);

orcle分页

sqlmain="(select * from emp)";

sql="select * from (select row_number() over(order by rowid) rn,s.* from "+sqlmain+" s)"

+" where rn between "+((currentPage-1)*showCount+1) +" and "+currentPage*showCount;

ResultSet rs=stmt.executeQuery(sql);[/color][/color]