81,092
社区成员
发帖
与我相关
我的任务
分享
public List queryObjectsToPages(final HQuery hquery) {
HibernateTemplate hibernateTemplate = new HibernateTemplate(getSessionFactory());
return (List) hibernateTemplate.execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
List itr = null;
try {
StringBuffer query_str = new StringBuffer(hquery.getQueryString());
if (hquery.getOrderby() != null) {
query_str.append(hquery.getOrderby());
}
// 是否要分组
if (hquery.getGroupby() != null) {
query_str.append(hquery.getGroupby());
}
Query query = session.createQuery(query_str.toString());
setQueryParams(hquery, query);
// 是否存在分页,当hquery.getPageStartNo()==0是不分页
if (hquery.getPageStartNo() != 0) {
long pageno = hquery.getPageStartNo();
query.setFirstResult(Integer.parseInt(Long.toString(pageno - 1))* hquery.getRowsPerpage());
query.setMaxResults(hquery.getRowsPerpage());
}
itr = query.list();//<1>
} catch (Exception e) {
e.printStackTrace();
}
return itr;
}
});
}
public List queryObjectsToPages(final HQuery hquery) {
HibernateTemplate hibernateTemplate = new HibernateTemplate(getSessionFactory());
return (List) hibernateTemplate.execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
List itr = null;
try {
StringBuffer query_str = new StringBuffer(hquery
.getQueryString());
// 是否要排序
if (hquery.getOrderby() != null) {
query_str.append(hquery.getOrderby());
}
// 是否要分组
if (hquery.getGroupby() != null) {
query_str.append(hquery.getGroupby());
}
Query query = session.createQuery(query_str.toString());
if (hquery.getPageStartNo() != 0) {
long pageno = hquery.getPageStartNo();
int first = Integer.parseInt(Long.toString(pageno - 1))* hquery.getRowsPerpage();
int end =hquery.getRowsPerpage();
query_str.append(" limit ").append(first).append(",").append(end);
}
setQueryParams(hquery, query);
itr = query.list();//////<2>
} catch (Exception e) {
e.printStackTrace();
}
return itr;
}
});
}
select * from USERS as a where 1=1 order by a.id desc limit 0,10