MyBatis框架动态SQL处理简单的多参数查询
if标签:
用法类似Java中的if语句,选择性拼接指定SQL片段.
格式:
if test=“条件”
SQL片段
/if
说明:
1.当条件为true时,将SQL片段拼接到该标签所在位置
示例:
<select id="getUser" resultType="user">
select * from user where 1=1
<if test="id!=null">
and id=#{id}
</if>
<if test="name!=null">
and name=#{name}
</if>
<if test="sex!=null">
and sex=#{sex}
</if>
<if test="age!=null">
and age=#{age}
</if>
<if test="address!=null">
and address=#{address}
</if>
</select>
where标签:
示例:
<select id="getUser" resultType="user">
select * from user
<where>
<if test="id!=null">
and id=#{id}
</if>
<if test="name!=null">
and name=#{name}
</if>
<if test="sex!=null">
and sex=#{sex}
</if>
<if test="age!=null">
and age=#{age}
</if>
<if test="address!=null">
and address=#{address}
</if>
</where>
</select>
choose标签:
示例:
<select id="getUserches" resultType="user" parameterType="user">
select * from user
<where