Hebernate多表查询，结果集组装方法
1.编写连表sql，注意hql与sql的区别即可
?
?String hql = "select pi.id,pi.nam,pm.mId,pm.mversion from PM pm, PI pi where pm.id=pi.id and pm.mId =:mId";
?
2.打开查询
?
?
QueryParams q = new QueryParams();q.addParam("mId", mId);List result = query(hql, q);Iterator it = result.iterator();?public List query(final String hql, final QueryParams queryParam) {return (List) getHibernateTemplate().execute(new HibernateCallback() {public Object doInHibernate(Session session) {Query resultQuery = session.createQuery(hql);resultQuery.setCacheable(cacheable);resultQuery = QueryParams.setParams(resultQuery, queryParam);List reval = resultQuery.list();return reval;}});}?3.装配查询结果
?
List<DemoBean> beans = new ArrayList<DemoBean>();while (it.hasNext()) {DemoBean bean = new DemoBean();Object[] tuple = (Object[]) it.next();bean.setId((Integer)tuple[0]);bean.setName((String)tuple[1]);bean.setMId((Integer)tuple[2]);bean.setMversion((String)tuple[3]);beans.add(bean);}?这样整个查询就完成了，简单方便。
?