如何使用实体关系不直接的休眠标准连接多个表?

2024-03-09

我有三个实体。那些是:

@Entity
public class Organization {
    @Id
    private long id;
    @Column
    private String name;
}
@Entity
public class Book {
    @Id
    private Long id;
    @Column
    private String name;
    @ManyToOne
    private Organization organization;
}
@Entity
public class Account  {
   @Id
   private Long id;
   @Column
   private String name;
   @ManyToOne
   private Book book;
}

在这三个实体中我想执行以下sql:

SELECT acc.name, acc.id
FROM account acc
JOIN book b on acc.book_id = b.id
JOIN organization org on b.organization_id = org.id
WHERE org.name = 'XYZ'

在这种情况下Account实体与该实体没有任何关系Organization直接实体。Account实体通过以下关系具有关系Book。如何使用休眠条件动态查询来实现这一点?


其他方式

public List<Account> getAccountListByOrgName(String name){
    return sessionFactory.getCurrentSession().createCriteria(Account.class)
                .createAlias("book", "book")
                .createAlias("book.organization", "organization")
                .add(Restrictions.eq("organization.name", name))
                .list();
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

如何使用实体关系不直接的休眠标准连接多个表? 的相关文章

随机推荐