有关于sql.xml中的东西

来源：互联网发布：jar反编译成java项目编辑：程序博客网时间：2024/05/01 18:08

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>