MybatisPlus 实现 where id = and (a = or b = )

墨蓝 2022-12-25 13:52 249阅读 0赞

实现

  1. LambdaQueryWrapper<CustomerLabelMapping> wrapper = Wrappers.lambdaQuery();
  2.         String approval = labelQuery.getApproval();
  3.         String companyName = labelQuery.getCompanyName();
  4.         String drugId = labelQuery.getDrugId();
  5.         wrapper.eq(CustomerLabelMapping::getCustomerId, labelQuery.getCustomerId());
  6.         if (StrUtil.isNotBlank(drugId)) { 
  7.             wrapper.and(s -> s.like(CustomerLabelMapping::getDrugId, drugId)
  8.                     .or().like(CustomerLabelMapping::getDrugCode, drugId)
  9.                     .or().like(CustomerLabelMapping::getDrugName, drugId));
  10.         }
  11.         wrapper.like(StrUtil.isNotBlank(approval), CustomerLabelMapping::getApproval, approval);
  12.         wrapper.like(StrUtil.isNotBlank(companyName), CustomerLabelMapping::getCompanyName, companyName);
  13.         wrapper.orderByDesc(CustomerLabelMapping::getUpdateTime);

核心

  1. wrapper.and(s -> s.like(CustomerLabelMapping::getDrugId, drugId)
  2.                     .or().like(CustomerLabelMapping::getDrugCode, drugId)
  3.                     .or().like(CustomerLabelMapping::getDrugName, drugId));

发表评论

表情：
评论列表 （有 0 条评论，249人围观）

还没有评论，来说两句吧...

相关阅读