今天发现:
ibatis中动态语句中:
对同一个属性(传进来的参数),要先判断非空,然后再是等于某个值
<isNotEmpty prepend=" order by " property="orderBy">
<isEqual property="orderBy" compareValue="displace">
cast(DISPLACE as int) ASC
</isEqual>
<isEqual property="orderBy" compareValue="year">
NOTICE_DATE desc
</isEqual>
</isNotEmpty >
<isNotEmpty>
</isNotEmpty>
要包裹
<isEqual></isEqual>
如果对同一个属性(参数)进行判断,<isNotEmpty> 和<isEqual>并列时,好像有冲突。