public List getQueryPagnation(final String hql, final Page page) {
List tmpList = this.getHibernateTemplate().executeFind(
new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(hql);
query.setFirstResult(page.getFirstResult());
query.setMaxResults(page.getMaxPageSize());
return query.list();
}
});
return tmpList;
}
1、String hql = "select new Map(b.comId as comId,,c.fullname as fullName)from BankInfo b , Cominfo c where 1=1 and c.id = '4100003400000052' and b.comId = '4100003400000052' ";
这种方法多用于json框架下的返回。它返回的list中是HashMap对象,每个Map对象是以as后边的名字为key,以数据库对应的值为value的键值对。
2、String hql = "from BankInfo b , Cominfo c where 1=1 and c.id = '4100003400000052' and b.comId = '4100003400000052' ";
这种方法返的list中是Object对象 每个Object对象其实质是Object[]数组 每个数组原素对应查询对象如Object[0]为 BankInfo ,Object[1]为Cominfo