mybatis-plus:xml与sql拼接总结

       <if test = "vo.map!= null and vo.map.size() > 0">
            <foreach item="item" index="key" collection="vo.map">
                <if test = "key != null and key != 'assetType'">
                	// jsonParam为json类型字段
                    and JSON_EXTRACT(jsonParam, '$.${key}') = #{item}
                </if>
                <if test = "key != null and key == 'assetType'">
                    and ${key} = #{item}
                </if>
            </foreach>
        </if>