mybatis plus and+or 查询

最新推荐文章于 2025-03-09 23:46:58 发布

FenceRain

最新推荐文章于 2025-03-09 23:46:58 发布

阅读量726

点赞数 2

文章标签： mybatis windows linux

本文链接：https://blog.youkuaiyun.com/FenceRain/article/details/136905732

版权

mybatis plus and+or 查询语句

select * from student where name="A" and car = "B" 
and (
(start >= '2024-01-01' and start < '2024-01-09') 
or (end > '2024-01-01' and end < '2024-01-09') 
or (start < '2024-01-01' and end > '2024-01-09'))

QueryWrapper<Student> eeqw = new QueryWrapper<Student>();
eeqw.eq("name", "A");
eeqw.eq("car", "B");
eeqw.and(qw -> qw.ge("start", "2024-01-01").lt("start", "2024-01-09")
	.or().gt("end", "2024-01-01").lt("end", "2024-01-09")
	.or().lt("start", "2024-01-01").gt("end", "2024-01-09"));
list(eeqw)