java - JPA 忽略按列值映射

Question

我正在制作一个基于JPA/Eclipselink和实体的应用程序，删除操作必须符合逻辑(属性/列true或false)才能在数据库中保留日志。我想知道是否可以忽略关系 OneToMany 或 ManyToMany 中“已删除”为“true”的数据库行。我有类似于以下内容的实体:

@Entity
public class Employee {
  @Id
  @Column(name="EMP_ID")
  private long id;
  ...
  @OneToMany(mappedBy="owner")
  private List<Phone> phones;
  ...
}

@Entity
public class Phone {
  @Id
  private long id;

  @NotNull
  @Column(name = "deleted")
  private boolean deleted = false;
  ...
  @ManyToOne(fetch=FetchType.LAZY)
  @JoinColumn(name="OWNER_ID")
  private Employee owner;
  ...
}

提前致谢!

Answer 1

是的，您可以使用@AdditionalCriteria为此目的:

@AdditionalCriteria("this.deleted = false")