Many-to-Many 查询 jpql

19 浏览
0 Comments

Many-to-Many 查询 jpql

我遇到了以下问题。

有一个实体分销商与实体城市之间存在多对多的关系：

@Entity
public class Distributor{
   @ManyToMany
   @JoinTable( name = "GS_DISTRIBUTOR_TOWN",
           joinColumns = @JoinColumn(name = "CD_DISTRIBUTOR"),
           inverseJoinColumns = @JoinColumn(name = "CD_TOWN") )
   private List towns;
   ....
}

然后实体城市与区域也有关系：

@Entity
public class Town{
   @ManyToMany(mappedBy="towns")
   private List distributors;
   @ManyToOne
   private District district;
   ....
}

现在我需要使用JPQL来过滤出所有在某个区域的分销商。

该如何实现？

0