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>
posted @ 2018-12-22 19:11  灯塔下的守望者  阅读(3090)  评论(0)  编辑  收藏  举报