<select id="selectIf" parameterType="传入参数">
select * from student
<where><if test="name != null">
name = #{ name }</if><if test="id != 0">
and id = #{ id }</if></where></select>
choose语句的编写
<select id="selectChoose" parameterType="传入参数">
select * from student
<where><choose><when test="name != null">
name = #{ name }</when><when test="id != 0">
and id = #{ id }</when></choose></where></select>
set语句的编写 set标签主要用于更新操作时使用
<update id="updateSet" parameterType="传入参数">
supdate student
<set><if test="name != null">
name = #{ name }</if><if test="id != 0">
id = #{ id }</if></set></update>
<select id="selectForeach" resultType="返回参数泛型">
select * from student where id in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
#{item}</foreach></select>