自定义的xml处理sql中会出现一个区间段的约束问题,那么记住下面的方法便可。
原符号 | < | <= | > | >= | & | ' | " |
替换符号 | < | <= | > | >= | & | ' | " |
或者下面的处理方法:
<isNotNull prepend="AND" property="age">
<isNotNull prepend="AND" property="age">
year(getdate())-year(birthday)
<isEqual property="sign" compareValue="1"><![CDATA[ < ]]>
</isEqual>
<isEqual property="sign" compareValue="2"><![CDATA[ = ]]></isEqual>
<isEqual property="sign" compareValue="3"><![CDATA[ > ]]></isEqual>
#age#
</isNotNull>
<isNotNull prepend="and" property="startRegisterTime">
registTime <![CDATA[>=]]> #startRegisterTime#
</isNotNull>
<isNotNull prepend="and" property="endRegisterTime">
registTime <![CDATA[<=]]> #endRegisterTime#
</isNotNull>