我有一個存儲庫public interface GroupRepository extends JpaRepository<Group, Integer> {}該組確實有一個項目清單private List<Item> items;每個Item都有一個position屬性private int position;如何通過知道其中一個列表中存在的項目的位置來檢索組 ？項目.javapublic class Item extends PersistedBean{ private int position; private Group group; @Column(name = "Position") public int getPosition() { return position; } @ManyToOne(fetch = FetchType.EAGER) @JoinColumn(name = "GroupId", referencedColumnName = "Id") public Group getGroup() { return group; }}組.javapublic class Group extends PersistedBean { private int position; private List<Item> items; @Column(name = "Position") public int getPosition() { return position; } @OneToMany(cascade = CascadeType.ALL, mappedBy = "group", orphanRemoval = false) public List<Item> getItems() { return items; }}
1 回答
慕哥9229398
TA貢獻1877條經驗 獲得超6個贊
您可以將查詢添加到您的JpaRepository<Group, Integer>存儲庫，類似于應該工作：
@Query("SELECT g FROM Group g " +
"JOIN g.items i ON i.position IN :p")
List<Group> getGroupsWhenPositionMatchAnyRelatedItem(@Param("p") Integer p);
添加回答
舉報
0/150
提交
取消