有关于sql.xml中的东西

最新推荐文章于 2022-11-10 22:12:04 发布

最新推荐文章于 2022-11-10 22:12:04 发布 · 112 阅读

Ibatis 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种在构建复杂查询时使用动态SQL的方法，重点讲解了如何通过<dynamicprepend=where>标签正确地添加WHERE子句，并利用<isNotEmpty>和<isEmpty>标签根据参数是否为空来决定是否加入相应的查询条件。

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>