读书人

Hibernate 多表关联查询有关问题

发布时间: 2012-03-23 12:06:21 作者: rapoo

Hibernate 多表关联查询问题
String sql = “select {t1.*} from cm_document t1,(select max(docid) idnum from cm_document group by doctitle) t2 where t1.docid=t2.idnum and t1.status = 1 order by t1.docpubtime desc”

Session session = this.getHibernateTemplate().getSessionFactory().getCurrentSession();
SQLQuery q = (SQLQuery) session.createSQLQuery(sql).addEntity("t1",CmsDocument.class).addJoin("t2", "t1.t2s");
q.setMaxResults(size);
List<?> list =q.list();

addJoin 怎么写???

[解决办法]
addJoin("别名","第一个实体中的属性如: t1.tab2");

读书人网 >J2EE开发

热点推荐