天天看点

Mybatis-plus 查询语句加括号(.or(),.and())

QueryWrapper<User>  queryWrapper= new QueryWrapper<>();
queryWrapper.eq("uid", param.getUid())
queryWrapper.and(QueryWrapper -> QueryWrapper.eq("userName", userName).or().eq("mark", mark)); 
entityMapper.selectList(queryWrapper);

           

等价于

SELECT * FROM user WHERE (uid = ? AND (userName= ? OR mark = ?))

           

继续阅读