Mybatis中if-else对应写法
1. mybatis分支判断
mybaits 中没有else要用chose when otherwise 代替。
语法格式:
<choose>
<when test="">
//...
</when>
<otherwise>
//...
</otherwise>
</choose>
2. mybatis分支写法
<sql id="pageQueryOrder">
<choose>
<when test="sortField != null and sortField != ''">
order by #{sortField}
<if test="positiveOrReverse != null and positiveOrReverse != ''">
#{positiveOrReverse}
</if>
limit #{offset}, #{pageSize}
</when>
<otherwise>
order by create_time desc limit #{offset}, #{pageSize}
</otherwise>
</choose>
</sql>