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