动态SQL

<if>:
<where>:
 
select 字段名  from 表名        
<where>         
    <if  test= " username != null ">
           <!-- 字段名 = #{参数名} -->
           and username = #{username}
    </if>  
</where>


<foreach> : 遍历数组或集合 

<!-- 通过动态sql foreach 批量删除-->
<delete id="deleteAll">
     delete from tlias.emp where id in
  <foreach collection="ids" item="id" separator="," open="(" close=")">
    #{id}
  </foreach>
</delete>

<!-- 通过动态sql foreach 批量删除-->
delete from 表名  where 字段名 in

< foreach collection = 集合名字 item = "id" separator = "," opem="("  close=")"  >
        #{id}
</foreach>

<set>: 此标签 通常只在 更新时需要用到s

update  表名
<set>
<if test = " username !=null and username != '' ">
   username = #{username}
</if>
<if test = "password != null and password != '' ">
   password = #{password}
</if>
</set>