Hibernate查询条件为3个表之间的连接 [英] Hibernate query criteria for join between 3 tables

问题描述

我有一个sql查询：

I have a sql query:

select * from A
INNER JOIN B
ON A.id = B.id
INNER JOIN C
ON B.id = C.id
INNER JOIN D
ON C.id = D.id
where D.name = 'XYZ'
   and D.Sex = 'M'

我一直试图为上述sql提供hibernate查询条件，但遇到问题。任何人都可以帮忙。

I have been trying to come with hibernate query criteria for the above sql, but having problems. Could anybody help out.

推荐答案

Criteria c = session.createCriteria(A.class, "a");
                    .createAlias("a.b", "b")
                    .createAlias("b.c", "c")
                    .createAlias("c.d", "d")
                    .add(Restrictions.eq("d.sex", "M"))
                    .add(Restrictions.eq("d.name", "XYZ"));

这篇关于Hibernate查询条件为3个表之间的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！