有关于sql.xml中的东西

1. <dynamic prepend="where">后必须得加条件 如果为空的话它就会报错 如果没有什么条件可写的话 就加上 rownum>0 或1=1

2.   <isNotEmpty property="ENTRANCEDATESTART"> </isNotEmpty>中的字段名得和这个变量名>#ENTRANCEDATESTART#名字相同
<dynamic prepend="where">
        rownum>0
   <isNotEmpty property="NAME">
    AND S.NAME like '%' || #NAME# || '%'
   </isNotEmpty>
   <isNotEmpty property="SEX">
    AND S.SEX=#SEX#
   </isNotEmpty>
   <isNotEmpty property="PEOPLE">
    AND S.PEOPLE like '%' || #PEOPLE# || '%'
   </isNotEmpty>
   <isNotEmpty property="SCHOOLPROFESSIONAL">
    AND S.SCHOOLPROFESSIONAL like '%' || #SCHOOLPROFESSIONAL# || '%'
   </isNotEmpty>
   <isNotEmpty property="LEARNYEAR">
    AND S.LEARNYEAR   like '%' || #LEARNYEAR# || '%'
   </isNotEmpty>
   <isNotEmpty property="PROVINCE">
    AND S.PROVINCE like '%' || #PROVINCE# || '%'
   </isNotEmpty>
   <isNotEmpty property="REGPERRES">
    AND S.REGPERRES like '%' || #REGPERRES# || '%'
   </isNotEmpty>
   <isNotEmpty property="AREA">
    AND S.AREA like '%' || #AREA# || '%'
   </isNotEmpty>
   <isNotEmpty property="MIDDLESCHOLL">
    AND S.MIDDLESCHOLL like '%' || #MIDDLESCHOLL# || '%'
   </isNotEmpty>
   <isNotEmpty property="ISPAY">
    AND S.ISPAY like '%' || #ISPAY# || '%'
   </isNotEmpty>
   <isNotEmpty property="ENTRANCEDATESTART">
    AND S.ENTRANCEDATE >#ENTRANCEDATESTART#
   </isNotEmpty>
   <isNotEmpty property="ENTRANCEDATEEND">
    AND S.ENTRANCEDATE <![CDATA[<]]> #ENTRANCEDATEEND#
   </isNotEmpty>
   <isNotEmpty property="OPENYEAR">
    AND S.OPENYEAR like '%' || #OPENYEAR# || '%'
   </isNotEmpty>
   <isEmpty property="OPENYEAR">
    AND S.OPENYEAR =(SELECT to_CHAR(SYSDATE,'YYYY') FROM DUAL)
   </isEmpty>
  </dynamic>