假设您使用以下映射:
@Entity
@Table(name = "product")
class Product
{
@Id
@Column(name = "product_id")
private Long id;
@ManyToMany
@JoinTable(name = "product_category",
joinColumns = @JoinColumn(name = "category_id"),
inverseJoinColumns = @JoinColumn(name = "product_id")
)
private List<Category> categories;
// getters/ setters
}
@Entity
@Table(name = "category")
class Category
{
@Id
@Column(name = "category_id")
private Long id;
@Column(name = "name")
private String name;
// getters/ setters
}
您可以使用以下HQL:
select p from Product
join fetch p.categories c
where c.name = :categoryName
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句