java - 避免检索带有 "Delete date"的项目

Question

我有这两个实体，当我检索人员实体时，该集合仅包含没有删除日期的人员，JPA对此有任何注释吗？现在我正在使用 JPA Api 从数据库检索数据

人

@Entity
@Table(name = "person")
public class Person {

    @Id
    @GeneratedValue
    private Long id;

    private String name;

    private Date deleteDate;

    @ManyToOne
    private People people;

    //Getters and setters
}

人

@Entity
@Table(name = "people")
public class People {

    @Id
    @GeneratedValue
    private Long id;

    private String from;

    @OrderBy("id")
    @OneToMany(mappedBy = "people", fetch = FetchType.EAGER)
    private Set<Person> persons = new HashSet<Person>();
}

Answer 1

使用 Hibernate，一种方法是将 @Where 注释放在人员集合上

@OrderBy("id")
@Where(clause = "delete_date is null")
@OneToMany(mappedBy = "people", fetch = FetchType.EAGER)
private Set<Person> persons = new HashSet<Person>();