从集合中对bean字段进行JPA查询 [英] JPA query on bean field from collection
本文介绍了从集合中对bean字段进行JPA查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有下一班关系:
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屋!
查看全文