项目可以使用我上一篇文章的mybatis-plus逆向工程快速建好。
新建了测试类之后要在里面添加注解@SpringBootTest和@Slf4j
@Slf4j是用作日志输出的,一般会在项目每个类的开头加入该注解
@SpringBootTest可以在运行基于Spring Boot的测试的测试类上指定的注释。
//逻辑删除
@Test
public void del(){
//update user set deleted = 1 where id = 1 and deleted = 0;
//找到id是1的数据吧deleted修改成1
int i = userMapper.deleteById(1);
log.info("i = {}", i);
}
//逻辑删除
@Test
public void del(){
//集合逻辑删除,set自动去重,把id为1,2,3的集中删除
//update user set deleted=1 where id in ( ? , ? , ? ) and deleted=0
int i = userMapper.deleteBatchIds(Set.of(1,2,3));
log.info("i = {}", i);
}
//逻辑删除
@Test
public void del(){
//集合逻辑删除,三种方法
//update user set deleted=1 where id in ( ? , ? , ? ) and deleted=0
//方法一:set集合
int i = userMapper.deleteBatchIds(Set.of(1,2,3));
//方法二:List集合
int i = userMapper.deleteBatchIds(List.of(1,2,3));
//方法三:Array.List集合
int i = userMapper.deleteBatchIds(Arrays.asList(1,2,3));
log.info("i = {}", i);
}
//逻辑删除
@Test
public void del(){
//删除id3~5之间并包括3和5
QueryWrapper w = new QueryWrapper<>();
w.between("id",3,5);
int i = userMapper.delete(w);
log.info("i = {}", i);
}



