> XBoot中默认物理删除,请根据自己需求做逻辑删除 ### JPA逻辑删除 - 使用`@SQLDelete`设定删除语句SQL,修改删除标识为1(已删除) ``` java ... @SQLDelete(sql = "update t_user set del_flag = 1 where id = ?") public class User extends XbootBaseEntity { ... } ``` - 使用`@Where(clause = "del_flag = 0")`设定查询语句额外条件,只查询标识为0(未删除)的数据 ``` java ... @SQLDelete(sql = "update t_user set del_flag = 1 where id = ?") @Where(clause = "del_flag = 0") public class User extends XbootBaseEntity { ... } ``` ### Mybatis-Plus逻辑删除 * application.yml 加入配置(如果你的默认值和mp默认的一样,该配置可无): ~~~ mybatis-plus: global-config: db-config: logic-delete-value: 1 # 逻辑已删除值(默认为 1) logic-not-delete-value: 0 # 逻辑未删除值(默认为 0) ~~~ * 实体类字段上加上`@TableLogic`注解 ~~~ @TableLogic private Integer delFlag; ~~~