<!-- 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}), '%')