MyBatis中choose when正确写法

<choose>
<when test="scoreRange!=null and scoreRange eq 1">
AND sc.score <![CDATA[ < ]]> 60
</when>
<when test="scoreRange!=null and scoreRange eq 2">
AND (sc.score <![CDATA[ >= ]]> 60 AND sc.score <![CDATA[ <= ]]> 70 )
</when>
<when test="scoreRange!=null and scoreRange eq 3">
AND (sc.score <![CDATA[ >= ]]> 70 AND sc.score <![CDATA[ <= ]]> 80 )
</when>
<when test="scoreRange!=null and scoreRange eq 4">
AND (sc.score <![CDATA[ >= ]]> 80 AND sc.score <![CDATA[ <= ]]> 90 )
</when>
<when test="scoreRange!=null and scoreRange eq 5">
AND sc.score <![CDATA[ > ]]> 90
</when>
<otherwise>
</otherwise>
</choose>
上一篇:ThinkPHP框架 基础 链接数据库


下一篇:2016年11月4日 星期五 --出埃及记 Exodus 19:20