例如我们想要拼接
select * from sys_user where name='zs' and ( sex='0' or id in ('10','15') );
即是 and里面可以组合条件
QueryWrapper<sysUser> queryWrapper = new QueryWrapper<sysUser>();
List<String> arrayList = new ArrayList<>();
arrayList.add("10");
arrayList.add("15");
queryWrapper.eq("name","zs");
queryWrapper.and(wrapper -> wrapper.eq("sex", "0").or().in("id", arrayList));
其中sysUser为实体类
最重要的一句话是:
queryWrapper.and(wrapper -> wrapper.eq("name", name).or().in("id", arrayList));