insert selectKey ibatis


<insert id="SmsDAO.registSmsNuri" parameterClass="smsConnVO" >
<selectKey resultClass="int"  keyProperty="nuriSeq">
      <![CDATA[ SELECT nuri_user.msg_data_seq.nextval FROM DUAL ]]>
    </selectKey>
<![CDATA[
insert into nuri_user.msg_data
(msg_seq,
req_date,
cur_state,
call_to,
call_from,
sms_txt,
msg_type,
user_id,
site_cd
)
values
(#nuriSeq#,
sysdate,
 #curState#,
#callTo#,
#callFrom#,
#text#,
#msgType#,
#userID#,
'01'
)
]]>
</insert>

Popular posts from this blog

youtube download

com.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다.

rexpert 공식필드(javascript) 점검일 주기 계산