目录

oracle

 <if test="xm!=null and xm!=''">
            and XM like '%'||#{
   xm , jdbcType=VARCHAR }||'%'
        </if>

mysql

 <if test="mc != null and mc!= ''">
            and  mc  like concat('%',#{
   mc, jdbcType=VARCHAR },'%')
        </if>