if:判断不多说
<if test="id != null"> id=#{id} </if>where:自动去头(and)
<where> <if test="id != null"> id=#{id} </if> and deleteFlag=0; </where>set:去尾(,)
choose:Java中的switch
<choose>
<when test=""></when>
<otherwise></otherwise>
</choose>
trim:可以自定义对语句的头尾设定
以下分别是1、定义开头2、去掉开头3、定义结尾4、去掉结尾
<trim prefix="" prefixOverrides="" suffix="" suffixOverrides=""></trim>
foreach:便利集合或是数组(collection可以传array和list)
<foreach collection="array" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
sql和include:自定义sql语句,达到复用,哪里要用就include
<sql id="key">
<trim suffixOverrides=",">
<if test="userName!=null">userName,</if>
</trim>
</sql>
<include refid="key"></include>