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>