mybatisPlus复杂查询，lambdaQueryWrapper条件设计器的and和or语句wrapper写法，可以解决嵌套子查询的复杂情况

耿直程序员，还是先直接上代码了，基础知识自行脑补！

LambdaQueryWrapper<Organ> lambdaQueryWrapper1 =  new LambdaQueryWrapper<Organ>();
        lambdaQueryWrapper1.eq(Organ::getOrganParentId,organ.getOrganParentId());
        lambdaQueryWrapper1.orderByDesc(Organ::getCreatedTime);

        if(organQuery != null){
            if(Strings.isNotBlank(organQuery.getKeywords())){
                String str = organQuery.getKeywords();
                lambdaQueryWrapper1.and(
                        wrapper -> wrapper
                                .like(Organ::getOrganNamePinyin, str)
                                .or()
                                .like(Organ::getOrganName, str)
                );
            }
        }

解释：

这个等同效果的sql语句

select * from oragn o
where 1 = 1
    <if test="o.id!= null">
        and tid = #{o.id}
    </if>
    <if test="o.pid!= null">
        and ptid = #{o.pid}
    </if>
     <if test="o.seex!= null">
        and type = #{o.seex}
    </if>
    <if test="o.age!=  null and o.age!=''">
        and (
            name like concat('%',#{o.age},'%')
            or
            orgName like concat('%',#{o.year},'%')
        )
    </if>

或者：

select * from oragn o
<where>
    <if test="o.id!= null">
        and tid = #{o.id}
    </if>
    <if test="o.pid!= null">
        and ptid = #{o.pid}
    </if>
     <if test="o.seex!= null">
        and type = #{o.seex}
    </if>
    <if test="o.age!=  null and o.age!=''">
        and (
            name like concat('%',#{o.age},'%')
            or
            orgName like concat('%',#{o.year},'%')
        )
    </if>
</where>