MyBatisPlus---delete删除操作的三种方法

一、根据id删除

@Test
public void deleteById() {
    int rows = userMapper.deleteById(1351456313578713090L);
    System.out.println("删除条数:" + rows);
}

@Test
public void deleteByBatchIds() {
    int rows = userMapper.deleteBatchIds(Arrays.asList(1094592041087729666L, 1351456313578713090L));
    System.out.println("删除条数:" + rows);
}

二、其他普通删除

@Test
public void deleteByMap() {
    Map<String, Object> map = new HashMap<>();
    map.put("name", "张三");
    map.put("age", 25);
    int rows = userMapper.deleteByMap(map);
    System.out.println("删除条数:" + rows);
}

三、以条件构造器为参数删除

@Test
public void deleteByWrapper(){
    QueryWrapper wrapper = new QueryWrapper();
    wrapper.eq("name","张三");
    wrapper.eq("age",25);
    int rows = userMapper.delete(wrapper);
    System.out.println("删除条数:" + rows);
}

@Test
public void deleteByLambda(){
    LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper();
    wrapper.eq(User::getName,"张三").eq(User::getAge,25);
    int rows = userMapper.delete(wrapper);
    System.out.println("删除条数:" + rows);
}

 

posted @ 2022-03-02 13:55  江南大才子  阅读(10549)  评论(1编辑  收藏  举报