Mybatis-Plus整合Mysql之过滤条件

1.查询所有，精确匹配

public List<Monitor> getall() {

    List<Monitor> monitor_list = iMonitorService.list(
        new QueryWrapper<Monitor>().lambda()
        .in(Monitor::getStatus, "well","bad").in(Monitor::getUid,"1"));
    
    设置过滤规则为匹配 状态为well或bad且uid为1的对象   
                
    List<Monitor> monitor_list1 = iMonitorService.list(
        new QueryWrapper<Monitor>().lambda()
        .eq(Monitor::getName, "11"));
     
    设置过滤规则为精确匹配 名字为11的对象     
                
    List<Monitor> all = new ArrayList<>();   取并集
    all.addAll(monitor_list);
    all.addAll(monitor_list1);
    return all;
}

2.批量删除

@Autowired
private IMonitorService iMonitorService;

public String delete_all(List<String> del_list) {
    
    iMonitorService.removeByIds(del_list);
    return "success";

   
    传入需要删除的主键列表
    Postman传入 ['1', '2', '3']
    使用 removeById方法可传入主键也可传入对象

    
}