Mybaits动态sql

private List<String> zxValue = new ArrayList<>();
private List<String> bxgdList = Arrays.asList("1", "2");
private List<String> qzsbList = Arrays.asList("3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14");
private List<String> wzList = Arrays.asList("15", "16");
private List<String> zxList = Arrays.asList("17", "18", "19", "20");

SELECT * FROM PS_LAWCASE C
        join
        PS_LAWCASE_PERSON P
        ON C.ID=P.LAWCASE_ID
        join PS_SPECIAL S
        on C.ID= S.LAWCASE_ID
        <where>
        <if test="psQueryVo.zxValue!=null and psQueryVo.zxValue.size>0">
        and S.type in
            <foreach collection="psQueryVo.zxValue" item="type" index="index"
                     open="(" close=")" separator=",">
                #{type,}
            </foreach>
        </if>
            <if test="psQueryVo.title!=null and psQueryVo.title !=''">
                <bind name="title" value="'%'+psQueryVo.title+'%'"/>
                AND c.title like #{psQueryVo.title}
            </if>

<if test="psQueryVo.name!=null and psQueryVo.name !=''">
                <bind name="name" value="'%'+psQueryVo.name+'%'"/>
                AND p.name like #{psQueryVo.name}
            </if>