JPA 如何使用逻辑删除

Question

我现在每张表都有一个 is_delete 字段，想通过这个字段来实现软删除，请问下JPA下有没有什么好的注解可以实现软删除呢，支持查询 删除 修改 三种动作，在以上的基础上支持级联操作就更好了。

Answer 1

使用 @SQLDelete 和 @Where

@Entity
@Table(name="demo")
@SQLDelete(sql = "update demo set deleted = 1 where id = ?")
@Where(clause = "deleted = 0")
public class Demo{

    @javax.persistence.Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @Column(name="deleted")
    private Integer deleted = 0;

    private String userName;

    @Override
    public Long getId() {
        return id;
    }

    @Override
    public void setId(Long id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public Integer getDeleted() {
        return deleted;
    }

    public void setDeleted(Integer deleted) {
        this.deleted = deleted;
    }
}