업무/DB
[iBatis] update문 prepend작성법
랄프위검
2015. 11. 26. 13:03
<update id="osAddressDAO.updateAddrGrpMapping" parameterClass="osAddressMap">
UPDATE OS_ADDR_GROUP_MAPPING SET
<dynamic prepend=" " close=" ">
<isNotNull property="new_addr_seq" prepend=",">
ADDR_SEQ = #new_addr_seq#
</isNotNull>
<isNotNull property="new_group_seq" prepend=",">
GROUP_SEQ = #new_group_seq#
</isNotNull>
WHERE
1=1
<isNotEmpty property="addr_seqs" prepend="AND">
ADDR_SEQ IN ($addr_seqs$)
</isNotEmpty>
<isNotEqual property="addr_seq" compareValue="0" prepend="AND">
ADDR_SEQ = #addr_seq#
</isNotEqual>
<isNotEmpty property="group_seq" prepend="AND">
GROUP_SEQ = #group_seq#
</isNotEmpty>
</dynamic>
</update>
위 dynamic문을 안쓰면
UPDATE OS_ADDR_GROUP_MAPPING SET ,ADDR_SEQ ~~~ 로 컴마가앞에들어가서 오류가 발생한다.
끝.