Mybatis-plus逻辑删除

delete_flag int DEFAULT NULL COMMENT ‘0:未删除 1：已删除’,
User添加新字段delete_flag

    
    @TableLogic(value = "0",delval = "1")
    @TableField(value = "delete_flag",fill = FieldFill.INSERT)
    private int delete_flag;

IUserService

public interface IUserService extends IService {
    int deleteUser(int id);
}

UserServiceImpl

@Service
public class UserServiceImpl extends ServiceImpl implements IUserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public int deleteUser(int id) {
        return userMapper.deleteById(id);
    }
}

Controller

@RestController
@RequestMapping("/api/user")
public class UserController {

	@Autowired
    private UserMapper userMapper;

    @Autowired
    private IUserService userService;
    
    @RequestMapping("/add")
    public Result add(@RequestBody User user){
        int i = userMapper.insert(user);
        return Result.success(i);
    }

    @RequestMapping("/del/{id}")
    public Result deleteUserById(@PathVariable Integer id){
        int i = userService.deleteUser(id);
        return Result.success(i);
    }
}

启用接口，新增一条用户数据

记录

删除记录

记录

数据库中delete_flag字段的值从0更新为1