我下面有三个实体。我想使用JPA按DEP id获取规则列表
规则-----------一域----------->EMP-----------许多-------------->部门。
@Entity
@Table(name = "EMP")
public class Emp implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@OneToMany(mappedBy = "emp")
private List<Rule> rules;
@ManyToMany
@JoinTable(name = "rule_ref_sub_category_ref", joinColumns = {
@JoinColumn(name = "EMP_ID") }, inverseJoinColumns = { @JoinColumn(name = "DEP_REF_ID") })
private List<Dep> Deps;
}
*/
@Entity
@Table(name="DEP")
public class Dep implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long id;
@Column(name="LABEL")
private String label;
private int mandatory;
@ManyToMany(mappedBy="Deps")
private List<Emp> emps;
}
@Entity
@Table(name="RULES")
public class Rule implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long id;
@ManyToOne
@JoinColumn(name="EMP_REF_ID")
private Emp emp;
}
请有人给我提供一个JPQL请求示例来解决这个问题。