mybatis plus 中用Lamdaquerywrapper 嵌套条件and 和or

weixin_42124960

于 2024-09-05 17:30:10 发布

阅读量378

点赞数 3

文章标签： linux 运维服务器

本文链接：https://blog.csdn.net/weixin_42124960/article/details/141936709

版权

//查询where manager_name like '%王%' and (industry like '%粮油%' or industry like '%种植%')
   LambdaQueryWrapper<ProfessionalManager> lambdaQueryWrapper = new LambdaQueryWrapper<ProfessionalManager>()
                .like(Func.isNotEmpty(managerDTO.getManagerName()), 
                .orderByDesc(ProfessionalManager::getCreateTime);

   
        if (Func.isNotEmpty(managerDTO.getIndustryType())) {
            List<String> strList = Func.toStrList(managerDTO.getIndustryType());
            lambdaQueryWrapper.and(wrapper ->strList.forEach(s -> wrapper.or().like(ProfessionalManager::getIndustry, s)));
        }