mybatis and 和or的使用

最新推荐文章于 2024-03-29 14:46:24 发布

蓝~蓝~蓝皮鼠

最新推荐文章于 2024-03-29 14:46:24 发布

阅读量130

点赞数

文章标签： java javascript 开发语言

本文链接：https://blog.csdn.net/adidss/article/details/130006873

版权

LambdaQueryWrapper<Recipe> lambdaQueryWrapper = new LambdaQueryWrapper<Recipe>()
      .eq(StringUtils.isNotEmpty(req.getEquipmentType()), Recipe::getEquipmentType, req.getEquipmentType())
      .eq(req.getRecipeType() != null, Recipe::getRecipeType, req.getRecipeType())
      .eq(StringUtils.isNotEmpty(req.getEquipmentId()), Recipe::getEquipmentId, req.getEquipmentId())
      .eq(req.getStatus() != null, Recipe::getStatus, req.getStatus())
      .eq(req.getType() != null, Recipe::getType, req.getType())
      .eq(req.getVersion() != null, Recipe::getVersion, req.getVersion())
      .eq(req.getGroupName() != null, Recipe::getGroupName, req.getGroupName())
      .eq(StringUtils.isNotEmpty(req.getConditionExt1()), Recipe::getConditionExt1, req.getConditionExt1())
      .eq(StringUtils.isNotEmpty(req.getConditionExt2()), Recipe::getConditionExt2, req.getConditionExt2())
      .eq("1".equals(req.getInfoExt5()), Recipe::getInfoExt5, "1")
      .isNull(Recipe::getParentId)

      .like(StringUtils.isNotEmpty(req.getRecipeName()), Recipe::getRecipeName, req.getRecipeName())
      .orderByDesc(Recipe::getStatus)
      .orderByDesc(Recipe::getCreateTime)
      .select(Recipe.class, i -> !i.getProperty().equals("body"));
if (!"1".equals(req.getInfoExt5())) {
   lambdaQueryWrapper.and(e->e.isNull(Recipe::getInfoExt5).or().eq(Recipe::getInfoExt5, "0"));
}
IPage<Recipe> page = recipeMapper.selectPage(new Page<>(req.getPageNo(), req.getPageSize()),
      lambdaQueryWrapper
);