티스토리 뷰

Skill/spring

[mybatis] pk 증가 및 insert

진열사랑 2020. 11. 5. 17:17
<insert id="saveInfo" parameterType="HashMap">
<selectKey resultType="java.lang.String" keyProperty="FTR_IDS" order="BEFORE">
    SELECT NVL(MAX (FTR_IDS), 0) + 1 FROM WTL_LEAK_PS
</selectKey>
MERGE INTO WTL_LEAK_PS
USING DUAL ON( FTR_IDS = TO_NUMBER(#{FTR_IDS}) )
	WHEN MATCHED THEN
		UPDATE SET FTR_IDN = LPAD(#{FTR_IDS}, 6, '0'),  	
			LOC_CODE=#{LOC_CODE}
			,MDFY_YN=#{MDFY_YN}
			,LEK_IDN=#{LEK_IDN}
			,CANO=#{CANO}
	WHEN NOT MATCHED THEN
		INSERT
		(
		  	LOC_CODE
			,FTR_IDN
			,MDFY_YN
			,LEK_IDN
			,CANO
			, FTR_IDS
		)
		VALUES
		(
		  	 #{LOC_CODE}
			,LPAD(#{FTR_IDS}, 6, '0')
			,#{MDFY_YN}
			,#{LEK_IDN}
			,#{CANO}
			,#{FTR_IDS}
		)  	
 </insert>
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/10   »
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
글 보관함