카테고리 없음
ibatis select 로 키값 가져와서 인서트
doridon
2014. 12. 11. 15:24
<insert id="OasisSyncDAO.insertAcsAllow" parameterClass="oasisVO">
<selectKey resultClass="int" keyProperty="allowId">
SELECT NVL(MAX(ALLOW_ID),0)+1 AS ALLOW_ID FROM OASIS_ACCESS_ALLOW
</selectKey>
<![CDATA[
) VALUES (
#allowId#,
#serviceKey#,
'KEY',
'REST',
'',
#limitCnt#,
#startDt#,
#endDt#,
)
]]>
</insert>