mybatis 笔记

1、in 语句的动态遍历

STATUS in
  <iterate  open="(" close=")" conjunction="," property = "statusList">
   #statusList[]#
  </iterate>

2、不等于判断

     <isNotEqual property="status" compareValue="0" prepend="and">
      STATUS = #status#
     </isNotEqual>

3、非空判断

</isNotEmpty>
     <isNotEmpty prepend="and" property="apiScope">
      API_SCOPE = #apiScope#  
     </isNotEmpty>