删除操作

public class MyBatisPlusDeleteTest{

@Autowired

private UserMapper userMapper;

@Test

public void deleteById(){

Integer rows = userMapper.deleteById(10001);

System.out.println("删除条数：" + rows);

}

@Test

public void deleteByMap(){

Map<String, Object> columnMap = new HashMap<>();

columnMap.put("name", "张无忌");

columnMap.put("age", 31);

        //DELETE FROM user WHERE name = '张无忌' AND age = 31

Integer rows = userMapper.deleteByMap(columnMap);

System.out.println("删除条数：" + rows);

}

    //带条件构造器的删除方法

@Test

public void deleteByWrapper(){

LambdaQueryWrapper<User> wrapper = Wrappers.<User>lambdaQuery();

wrapper.eq(User::getAge, 27).or().gt(User::getAge, 41);

        //删除多条

        //DELETE FROM user WHERE age = 27 or age > 41

Integer rows = userMapper.delete(deleteByWrapper);

System.out.println("删除条数：" + rows);

}

}

删除记录！！

mybatis-plus删除方法

1、根据id删除方法——deleteById(前提：实体类主键属性上有@TableId注解)

2、普通删除方法

3、以条件构造器为参数删除方法

CRUD - 删除

deleteByWrapper

deleteBatchIds

deleteByMap

deleteById