天天看點

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 = ?))

           

繼續閱讀