<!--     xml:   
            select * from smbms_provider
            where proName  like #{proName}
            and  proCode like #{proCode}
         java:  
            getProviderList ("%"+"北京"+"%", "%"+"BJ"+"%");
-->
        select * from smbms_provider
        where  proName LIKE CONCAT (CONCAT('%', #{proName}), '%')
        and  proCode like CONCAT (CONCAT('%', #{proCode}), '%')
        <!--   
         java:
          getProviderList ( "北京", "BJ" );
         -->
    </select>

模糊查询   

一种使用java代码拼接

getProviderList ("%"+"北京"+"%", "%"+"BJ"+"%");

一种使用

where  proName LIKE CONCAT (CONCAT('%', #{proName}), '%')