一、根据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);
}