Question

SSH 框架+ orcal怎么用sql实现页面查询分页？

Answer 1

给你一段
/**
* 实现分页查询
* @param offset 开始索引 start:0
* @param length 查询长度
* @return
*/
public List getListForPage4SQL(final String sql, final int offset, final int length) {
List retList = getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createSQLQuery(sql);
query.setFirstResult(offset);
query.setMaxResults(length);
List list = query.list();
return list;
}
});
return retList;
}