Sql语句:
select *
from t_user
where sex='男' and ((name='tom' and age=18) or (name='jeck' and age=20));
Mybatis-Plus 语句:
QueryWrapper<User> qw = new QueryWrapper<>();
qw.eq("sex", "男");
qw.and(i -> {
i.and(nameAgeQw -> {
nameAgeQw.or(itemWrapper -> {
itemWrapper.eq("name", "tom");
itemWrapper.eq("age", 18);
});
nameAgeQw.or(itemWrapper -> {
itemWrapper.eq("name", "jeck");
itemWrapper.eq("age", 20);
});
});
});
List<User> user = mapper.selectList(qw);