从集合中对bean字段进行JPA查询 [英] JPA query on bean field from collection

问题描述

我有下一班关系:

public class Company {
  . . .
  @OneToMany(mappedBy = "company", fetch = FetchType.EAGER, cascade=CascadeType.PERSIST)
  private Set<CompanySecUser> companySecUsers;
  . . .
}
public class CompanySecUser{
    . . .
    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="USER_ID")
    private User secUser;

    @Column(name = "IS_READ")
    private BigDecimal isRead;
    . . .
}

现在如何在JPA上对Company实体编写查询，以仅获取具有指定secUser.id和isRead = 1的公司?

Now how to write query in JPA on Company entity to get only companies with specified secUser.id and isRead = 1 ?

推荐答案

select company from Company company 
    join company.companySecUsers user 
    where user.id = <ID> and user.isRead = 1

这篇关于从集合中对bean字段进行JPA查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！