本文介绍了加入表hibernate + group by的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT
table2.id,$ b $我需要用Java + Hibernate来完成这个查询。 b COUNT(table2.id)AS计数
FROM
table1
JOIN表2
ON table1.fk_tb2 = table2.id --many2one
GROUP BY
table2.id
我会使用DetachedCriteria类.....我该怎么做?
解决方案
尝试使用像这样的投影:
Criteria table1Crit = session.createCriteria(table1);
Criteria table2Crit = table1Crit.createCriteria(table2,Criteria.INNER_JOIN);
table2Crit.setProjection(Property.forName(id)。count());
I need to do this query with Java + Hibernate.
SELECT
table2.id,
COUNT(table2.id) AS count
FROM
table1
JOIN table2
ON table1.fk_tb2 = table2.id --many2one
GROUP BY
table2.id
I would use DetachedCriteria class.....how can i do this ?
解决方案
Try using projections like this:
Criteria table1Crit = session.createCriteria("table1");
Criteria table2Crit = table1Crit.createCriteria("table2", Criteria.INNER_JOIN);
table2Crit.setProjection( Property.forName("id").count() );
这篇关于加入表hibernate + group by的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!