MySQL MyBatis Like 查询

Like查询方式一、

  <sql id="condition"> 
		<if test="userPin != null and userPin != ''"> 
			AND UCAS_AUTH_USER.USER_PIN like 
			'%${userPin}%' 
		</if> 
		<if test="userName != null and userName != ''"> 
			AND UCAS_AUTH_USER.USER_NAME like 
			'%${userName}%' 
		</if> 
		<if test="state != null and state != ''"> 
			AND UCAS_AUTH_USER.STATE = #{state,jdbcType=VARCHAR} 
		</if> 
		<if test="organiztionSid != null "> 
			AND UCAS_AUTH_USER.ORGANIZTION_SID = 
			#{organiztionSid,jdbcType=BIGINT} 
		</if> 
	</sql>

Like查询方式二、

 <!-- 公共查询条件  --> 
  <sql id="condition"> 
  		<if test="id != null"> 
  			and sys_data_dict.id_ = #{id, jdbcType=VARCHAR} 
  		</if> 
  		<if test="categoryId != null"> 
  			and sys_data_dict.category_id = #{categoryId, jdbcType=VARCHAR} 
  		</if> 
  		<if test="categoryCode != null and categoryCode != ''"> 
  			and sys_data_dict.category_code like concat('%', #{categoryCode,jdbcType=VARCHAR}, '%') 
  		</if> 
  		<if test="categoryName != null and categoryName != ''"> 
  			and sys_data_dict.category_name like concat('%', #{categoryName,jdbcType=VARCHAR}, '%') 
  		</if> 
  		<if test="key != null and key != ''"> 
  			and sys_data_dict.key_ like concat('%', #{key,jdbcType=VARCHAR}, '%') 
  		</if> 
  		<if test="type != null and type != ''"> 
  			and sys_data_dict.type_ = #{type, jdbcType=VARCHAR} 
  		</if> 
  		<if test="state != null and state != ''"> 
  			and sys_data_dict.state_ = #{state, jdbcType=VARCHAR } 
  		</if> 
  </sql>