栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

mybatis-plus如何加括号

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

mybatis-plus如何加括号

mp中如何添加括号 6.1 业务实现

如何通过mp语句实现这种SQL

SELECt
	count( 0 ) 
FROM
	tc_order 
WHERe
	(
	
	(
	
	(order_type = ? AND order_status IN (?)) 
			OR 
	(order_type = ? AND order_status IN (?)) 
			OR 
	(order_type = ? AND order_status IN (?))
	
	) 
	
		AND (app_id IN (?,?)) 
		AND (created_date BETWEEN ? AND ?)
		
	)

实现代码

QueryWrapper queryWrapper = new QueryWrapper<>();

if (query.getOrderStatus() != null) {
    OrderStatusQueryEnum orderStatusQueryEnum = OrderStatusQueryEnum.codeOf(Integer.parseInt(query.getOrderStatus()));
    queryWrapper.and(wrapper -> {
        for (QueryStatusMapDTO queryStatusMapDTO : orderStatusQueryEnum.getQueryStatusMap()) {
            wrapper.or(wp -> wp.eq("order_type", queryStatusMapDTO.getOrderTypeCode())
                       .in("order_status", queryStatusMapDTO.getOrderTypeStatusCodes()));
        }
    });
}

queryWrapper.and(wp -> wp.in("app_id", "70f01e7xxxxxxxx", "aaaaaaaaa346c0"));

if (query.getUserId() != null) {
    queryWrapper.and(wp -> wp.in("user_id", query.getUserId()));
}

if (query.getPlaceOrderData() != null) {
    LocalDate placeOrderData = query.getPlaceOrderData();
    LocalDateTime startTime = LocalDateTime.of(placeOrderData.getYear(), placeOrderData.getMonth(), placeOrderData.getDayOfMonth()
                                               , 0, 0, 0);
    LocalDateTime endTime = LocalDateTime.of(placeOrderData.getYear(), placeOrderData.getMonth(), placeOrderData.getDayOfMonth()
                                             , 23, 59, 59);
    queryWrapper.and(wp -> wp.between("created_date", startTime, endTime));
}

List tcOrderDOS = this.getBaseMapper().selectList(queryWrapper);
6.2 详细解释 6.2.1想给循环语句外面套括号
//循环语句外加括号 + 内部语句加括号
queryWrapper.and(wrapper -> {
    for (QueryStatusMapDTO queryStatusMapDTO : orderStatusQueryEnum.getQueryStatusMap()) {
        wrapper.or(wp -> wp.eq("order_type", queryStatusMapDTO.getOrderTypeCode())
                   .in("order_status", queryStatusMapDTO.getOrderTypeStatusCodes()));
    }
});

//简单版 循环语句外加括号
queryWrapper.and(wrapper -> {
            for(String bm : list) {
                wrapper.like("xxxxx", bm).or();
            }
            return wrapper;
        });
6.2.2 实现 B or C => (B or C)
queryWrapperw.eq("pid", bid).or().eq("pid2",bid); //错误示范

打印结果:select * form litemall_business where deleted=0 and pid=1 or pid2=1

queryWrapperw.and(wrapper -> wrapper.eq("pid", bid).or().eq("pid2", bid)); //正确结果

打印结果:select * form litemall_business where deleted=0 and (pid=1 or pid2=1)

6.2.3 A or(C and D)
@GetMapping("/A_or_CandD")
    public Object A_or_CandD() {
        //SELECT id,name,age,sex FROM student WHERe (name = ? OR (name = ? AND age = ?)) 
      List list =
          studentService
              .lambdaQuery()
              .eq(Student::getName, "1")
              .or(wp -> wp.eq(Student::getName, "1").eq(Student::getAge, 12))
              .list();
      return list;
6.2.4 (AandB)or(CandD)
@GetMapping("/AandB_or_CandD")
  public Object AandB_or_CandD() {
    // SELECt id,name,age,sex FROM student WHERe ((name = ? AND age = ?) OR (name = ? AND age = ?)) 
    List list =
        studentService
            .lambdaQuery()
            .and(wp -> wp.eq(Student::getName, "1").eq(Student::getAge, 12))
            .or(wp -> wp.eq(Student::getName, "1").eq(Student::getAge, 12))
            .list();
    return list;
  }
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/940536.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号