MySQL MyBatis Like 查询

不点 阅读:677 2021-03-31 16:57:33 评论:0

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>

 

标签:MyBatis
声明

1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。

关注我们

一个IT知识分享的公众号