关于Mybatis-plus中or和and的使用问题

最新推荐文章于 2024-07-29 14:22:26 发布

花港观渔

最新推荐文章于 2024-07-29 14:22:26 发布

阅读量643

点赞数

分类专栏：日常bug 文章标签： java mybatis

本文链接：https://blog.csdn.net/chen_19971103/article/details/126153281

版权

日常bug 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

今天在集成权限的时候

发现多条件查询的or和and的拼接出了问题

查看了执行SQL后发现了两种拼接方式

第一种:

查询条件:

queryWrapper.lambda().in(QueQueueEntity::getWarehouseSid, warehouseSids).or().in(QueQueueEntity::getLocationSid, locationSids);
queryWrapper.lambda().in(QueQueueEntity::getStatus, list);
queryWrapper.select("QUE_QUEUE.*, row_number()over(partition by QUEUE_GROUP_SID order by SEQ_PRIORITY) PARK_ORDER");

条件1: 权限集成

条件2: 查询指定状态

条件3: 分组后组内排序函数

执行sql:

SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT QUE_QUEUE.*, row_number()over(partition by QUEUE_GROUP_SID order by SEQ_PRIORITY) PARK_ORDER FROM ITMP.QUE_QUEUE WHERE REMOVE_STATUS=0 AND 
(status IN (1,2,3) AND WAREHOUSE_SID IN (232,243) OR LOCATION_SID IN (6387)) 
) TMP WHERE ROWNUM <=20) WHERE ROW_ID > 10

此种写法将条件按顺序拼接

第二种:

查询条件:

queryWrapper.lambda().and(wrapper -> wrapper.in(QueQueueEntity::getWarehouseSid,warehouseSids).or().in(QueQueueEntity::getLocationSid, locationSids));
queryWrapper.lambda().in(QueQueueEntity::getStatus, list);
queryWrapper.select("QUE_QUEUE.*, row_number()over(partition by QUEUE_GROUP_SID order by SEQ_PRIORITY) PARK_ORDER");

条件1: 权限集成

条件2: 查询指定状态

条件3: 分组后组内排序函数

执行sql:

SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT QUE_QUEUE.*, row_number()over(partition by QUEUE_GROUP_SID order by SEQ_PRIORITY) PARK_ORDER FROM ITMP.QUE_QUEUE WHERE REMOVE_STATUS=0 AND 
(status IN (1,2,3) AND (WAREHOUSE_SID IN (232,243) OR LOCATION_SID IN (6387))) 
) TMP WHERE ROWNUM <=20) WHERE ROW_ID > 10

此种写法先拼接or后拼接and