加入表hibernate + group by [英] Join tables 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！