81,092
社区成员
发帖
与我相关
我的任务
分享
/**
* 分页查询
*/
@Override
public List findPage(final String hql, final int maxResult,
final int firstResult, final Object... paras) {
List list = hibernateTemplate
.executeFind(new HibernateCallback<List>() {
@Override
public List doInHibernate(Session session)
throws HibernateException, SQLException {
Query q = session.createQuery(hql);
hibernateTemplate.prepareQuery(q);
if (paras != null) {
for (int i = 0; i < paras.length; i++) {
q.setParameter(i, paras[i]);
}
}
q.setFirstResult(firstResult);
q.setMaxResults(maxResult);
return q.list();
}
});
return list;
}
@Override
public List findByHqlInCache(final String hql, final Object... paras) {
return hibernateTemplate
.executeWithNativeSession(new HibernateCallback<List>() {
@Override
public List doInHibernate(Session session)
throws HibernateException, SQLException {
Query q = session.createQuery(hql);
hibernateTemplate.prepareQuery(q);
if (paras != null) {
for (int i = 0; i < paras.length; i++) {
q.setParameter(i, paras[i]);
}
}
return q.list();
}
});
}