解决sqlserver、MySQL、Oracle三种数据库模糊查询语句
SELECT
*
FROM
z_user
WHERE
<if test = "name != null and name != ''" >
AND name LIKE
<if test = "dbName == 'oracle'" >
'%' || #{name}||'%'
</if>
<if test = "dbName == 'sqlServer'" >
'%' + #{name}+'%'
</if>
<if test = "dbName == 'mySql'" >
concat('%',#{name},'%')
</if>
</if >