mybatis_sql_templete

gistfile1.txt

 
   <select id="empFind" resultType="employee">
   
        SELECT * FROM EMP
        WHERE 1=1
        <choose>
          <when test="sal >= 5000">
             and job ='PRESIDENT'
          </when>
          <when test="sal >=3000">
            and job ='manager'
          </when>
          <when test="sal >=2000">
             and job='ANALYST'
          </when>
          <otherwise>
             and job in('clerk','salesman')
          </otherwise>
        
        </choose>
   
   </select>