mybatisplus 使用or语句查询数据

最新推荐文章于 2025-04-06 11:10:13 发布

Jehue

最新推荐文章于 2025-04-06 11:10:13 发布

阅读量5.3k

点赞数

分类专栏： java mysql 文章标签： java mysql mybatisplus

本文链接：https://blog.youkuaiyun.com/m18870420619/article/details/107426548

版权

java 同时被 2 个专栏收录

13 篇文章

订阅专栏

mysql

2 篇文章

订阅专栏

contractIds = service
                        .list(Wrappers.<object>lambdaQuery()
                                .in(object::getStatus, statusList)
                                .and(obj -> obj.le(object::getContractStartDate, startMonth)
                                        .ge(object::getContractEndDate, startMonth)
                                        .or(obj1 -> obj1.ge(object::getContractStartDate, startMonth)
                                                .le(object::getContractStartDate, endMonth))
                                )
                        ).stream().map(object::getContractId).collect(Collectors.toList());

sql：select * from t where status in () and (startDate <= startMonth and endDate >= endMonth or startDate >=startMonth and startDate <= endMonth)；