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 怎么写???
SQLQuery q = (SQLQuery) session.createSQLQuery(sql).addEntity("t1",CmsDocument.class).addJoin("t2", "t1.t2s");
q.setMaxResults(size);
List<?> list =q.list();addJoin 怎么写???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货