原生的SQL:
select * from t_user where sex='male' and ((name=ylw and age=18) or (name=dumas and age=20));
MyBatisPlus 写法:
QueryWrapper<User> userQueryWrapper = new QueryWrapper<>(); userQueryWrapper.eq("sex","male"); userQueryWrapper.and(wrapper ->{ wrapper.and(nameAgeQueryWrapper ->{ nameAgeQueryWrapper.or(itemWrapper ->{ itemWrapper.eq("name","ylw"); itemWrapper.eq("age",18); }); nameAgeQueryWrapper.or(itemWrapper ->{ itemWrapper.eq("name","dumas"); itemWrapper.eq("age",20); }); }); }); List<User> user = mapper.selectList(queryWrapper);