1.遇到需要or条件,例如a.xx or a.xx is null
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.eq(“age”, 18)
.eq(“name”, “张三”)
.and(wrapper -> wrapper.eq(“sex”, “男”).or().eq(“sex”, “女”));List result = entityMapper.selectList(queryWrapper);
2.实际应用
if (queryWrapper.getType().contains(“-1”)) {
queryWrapper.and(wrapper -> wrapper.in(“vci.classify_id”, list).or().isNull(“vci.classify_id”));
}else{
queryWrapper.in(“vci.classify_id”, list);
}
3.sql语句
select * from table vci where vci.name=’zh’ and (vci.classify_id in(1,2,3) or vci.classify_id is null)