Mybatis动态SQL中常用的标签有:if标签、choose(when、otherwise)标签、trim(where、set)标签、foreach标签。以下展开介绍:
if标签
if是常用的判断语句,常与test属性连用,或者与concat属性连用。
<select id="getStudent" parameterType="string" resultMap="student">
select * from student
where 1=1
<if test="name != null">
and NAME = #{
name,jdbcType=VARCHAR}
</if>
</select>
或者与concat连用,进行模糊匹配
<select id="getStudent" parameterType="string" resultMap="student">
select * from student
where 1=1
<if test