动态sql

• where

        <where> </where>

• if

        <if test = "判断条件"> </if> 

• choose when otherwise        

select * from user where
    <choose>
        <when test = "id gt 3">
            id = (select max(id) from user)
        </when>
        <otherwise>
            id = (select min(id) from user)
        </otherwise>
    </choose>

• trim

prefix:增加指定前缀
suffix:增加指定后缀
prefixOverrides:删除指定前缀
suffixOverrides:删除指定后缀
<trim prefix="" suffix="" prefixOverrides="" suffixOverrides="">
    
</trim>

• set

        <set> </set>

• sql-include

        <sql id="xxx"> </sql>

        <include refid="xxx 

• selectkey

<selectKey order="" resultType="" keyProperty="">

</selectKey>

• useGenerateKeys

        获取自增主键

• foreach

<foreach collection="" open="" close="" item="" separator="">

</foreach>