mybatis和ibatis的配置文件使用>和<的情况
<使用<替代
>使用>替代
<update id="MS-NOTIFY-MSG-BATCH-UPDATE_IPADDR">
update T_NOTIFY_MSG set IP_ADDR=#ipAddr#, GMT_MODIFIED=systimestamp where MSG_ID in (
select MSG_ID from (
SELECT MSG_ID
FROM T_NOTIFY_MSG
WHERE IP_ADDR is null and GMT_PRE_TIME >=(sysdate-1) and GMT_PRE_TIME <= sysdate
<isNotNull property="notifyType" prepend=" and ">NOTIFY_TYPE=#notifyType# </isNotNull>
<isNotNull property="status" prepend=" and ">STATUS = #status# </isNotNull>
<isNotNull property="msgType" prepend=" and ">MSG_TYPE=#msgType# </isNotNull>
ORDER BY GMT_CREATE ASC
) where rownum <= #maxSize#
) and IP_ADDR is null and GMT_PRE_TIME <= sysdate
</update>