mybaits十六:使用choose标签实现分支选择

<!-- 
    	分支选择
    	<choose>
    		<when></when>
    		<otherwise></otherwise>
    	</choose>
    	
    	类似于switch-case-default的使用
     -->
    <select id="getEmpsByConditionChoose" resultType="com.atChina.bean.Employee">
    	select * from(
    	select a.empno as no, a.ename, a.job, a.mgr, 
    	a.hiredate, a.sal, a.deptno from emptest a
    	) 
    	<where>
    		<choose>
    			<when test="empno != null">
    				no = #{empno}
    			</when>
    			<when test="ename != null">
    				ename = #{ename}
    			</when>
    			<when test="job != null">
    				job = #{job}
    			</when>
    			<otherwise>
    				no >= 1
    			</otherwise>
    		</choose>
    	</where>
    </select>