spring+hibernate 多表的联合查询

 

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