<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 ~~~ 로 컴마가앞에들어가서 오류가 발생한다.



끝.

+ Recent posts