各种分页语句

1hibernate的hql分页语句

public void moveUp(Long id){
	Forum forum = getById(id);
	Forum other = (Forum) getSession().createQuery(
			"FROM Forum f WHERE f.position<? ORDER BY f.position DESC")
			.setParameter(0,forum.getPosition())
			.setFirstResult(0)
			.setMaxResults(1)
			.uniqueResult();
}

<p>public List<Object>queryListObjectAllForPage(String queryString,int pageSize,int page){</p><p>      Sessionsession = this.getHibernateTemplate().getSessionFactory().openSession();</p><p>      Query   query  =  session.createQuery(queryString); </p><p>      query.setFirstResult((page-1)*pageSize);</p><p>      query.setMaxResults(pageSize);</p><p>      List<Object>list= (List<Object>)query.list();</p><p>      session.close();</p><p>      returnlist;</p><p>   }</p><p>query =session.createQuery("from Table as t");//查询第一页，每页显示十条数据</p><p>query.setFirstResult(1);</p><p>query.maxResult(10);</p><p>query.list();</p>

2oracle的分页语句

 
select * from t_xiaoxi where rowid in(select rid from (select rownum rn,ridfrom(select rowid rid,cid from 
t_xiaoxi  order by cid desc) where rownum<10000) where rn>9980)order by cid desc; 
其中t_xiaoxi为表名称，cid为表的关键字段，取按CID降序排序后的第9981-9999条记录

http://blog.csdn.net/zhang6622056/article/details/7381493

3sqlserver

  SELECT TOP  页大小 *  FROM  table1   WHERE id NOT IN   (
     SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id
  )  ORDER BY id 

例子：

select top 3 * from t_user where cid not in (
     select top ((2-1)*3) cid from  t_user order by cid
) order by cid