MyBatis_1 常用标签判断

//特点
mybatis  方法不能重载

//注解

1.使用标签

@Update(" <script> " +

2.使用\转译

"<if test='dissentTime!=null and dissentTime!=\"\"'>"+

3.update去除多余","

"<trim prefix='SET' suffixOverrides=','> " +

//xml常用
原符号       <        <=        >        >=        &         '           "
替换符号    &lt;     &lt;=     &gt;     &gt;=     &amp;     &apos;     &quot;
<![CDATA[ >= ]]>
<![CDATA[ <= ]]>
<![CDATA[ > ]]>
<![CDATA[ < ]]>
1长度
<if test="orgCode.length() == 1"></if>
2相等
<if test='taskDefKey.equals("AAA")'></if>
3字符相等 即最外边用双引号，里边用单引号，此写法会报java.lang.NumberFormatException
<if test="stringParam != null and stringParam != 'a'"></if>
4判断存在
<if test="stringParam.indexOf('aa') != -1"></if>
5判断Integer是否大于0 gt大于,lt小于
<if test="idParam !=null and idParam gt 0"></if>
6like
<if test="title != null">
     AND  title LIKE CONCAT('%',#{boatName},'%')
</if>
7时间区间
<if test="warnBeginTime!=null ">
    and DATE_FORMAT(w.WARN_BEGIN_TIME, '%Y-%m-%d %H:%i:%s') <![CDATA[ >= ]]>   DATE_FORMAT(#{warnBeginTime},
    '%Y-%m-%d %H:%i:%s')
</if>
8.list>0
<if test="list.size() > 0">
9多条件判断
<choose>
    <when test="sameEmailList != null and sameEmailList.size > 0 ">
    </when>
    <when test="">
    </when>
    <otherwise>
    </otherwise>
</choose>

//只有自增才会返回主键,其他id不需要返回主键
<selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id">
    SELECT LAST_INSERT_ID()
</selectKey>