我目前正在努力处理一个我知道是可能的查询,但由于我在SQL查询方面的拙劣技能,我真的无法找到正确的句子.
我想找到某个区域的所有领土.每个分区包含多个区域,但一个区域可以属于一个分区.实体如下:
public class Territory {
@Id
@GeneratedValue(strategy= GenerationType.AUTO)
private Long id;
private String name;
private Long owned_player;
@OneToMany
private List<Territory> neighbors;
private int no_of_armies;
public Territory(String name) {
this.no_of_armies = 0;
this.neighbors = new ArrayList<>();
this.name = name;
//this.owned_player = new Player(0);
this.owned_player = null;
}
@Entity
public class Zone {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Long id;
private String name;
private String map;
//private int control_value;
@OneToMany
private List<Territory> territories;
public Zone(String name, String map) {
this.territories = new ArrayList<>();
this.name = name;
this.map = map;
//this.control_value = control_value;
}
我必须插入查询的回购如下所示:
public interface TerritoryRepository extends JpaRepository<Territory,Long> {
@Query("????")
public List<Territory> findAllTerritoriesByZone(String zone);
}
我正在试图找到将返回所有属于亚洲的领土(中国、日本、台湾……)的查询或欧洲(西班牙、法国、德国……)例如
感谢您的帮助和关注!