模糊查询时候xml判断数据库类型的写法详解编程语言

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