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);}

这样整个查询就完成了，简单方便。

?