mysql，sqlserver和oracle的模糊查询语句

项中经常涉及搜索功能，其实际就是应用了sql语句中的模糊查询，如下代码为常用的三种数据库的模糊查询语句

SELECT
	*
FROM
	z_user
WHERE
	<if test = "name != null and name != ''" >
		AND name LIKE 
		<if test = "dbName == 'oracle'" > 
			'%' || #{name}||'%'
		</if>
		<if test = "dbName == 'mssql'" > 
			'%' + #{name}+'%'
		</if>
		<if test = "dbName == 'mysql'" > 
			concat('%',#{name},'%')
		</if>
	</if >