mybatis在动态查询的前提下,适用于各种数据库的模糊查询
<if test="companyName != null and companyName != ''">
AND a.company_name LIKE
<if test="dbName == 'oracle'">'%'||#{companyName}</if>
<if test="dbName == 'mssql'">'%'+#{companyName}</if>
<if test="dbName == 'mysql'">concat('%',#{companyName},'%')</if>
</if>