프로그램 언어/ibatis,mybatis
ibatis에서 insert했을 경우 리턴값 처리
[식군]
2010. 2. 19. 17:58
<insert id="insert" parameterClass="customer">
<selectKey resultClass="int" keyProperty="id">
select someSequence.NEXTVAL as "id" from dual
</selectKey>
insert into Customer (id, name)
values (#id#, #name#)
</insert>
<insert id="insert2" parameterClass="Entity" parameterMap="insert-paramMap">
<selectKey resultClass="int" keyProperty="pkey"> SELECT seq.nextval FROM DUAL </selectKey>
INSERT INTO EntityTable (PKEY, DATA) VALUES (?, ?)
</insert>
출처 : http://deadlock.tistory.com/172
<selectKey resultClass="int" keyProperty="id">
select someSequence.NEXTVAL as "id" from dual
</selectKey>
insert into Customer (id, name)
values (#id#, #name#)
</insert>
<insert id="insert2" parameterClass="Entity" parameterMap="insert-paramMap">
<selectKey resultClass="int" keyProperty="pkey"> SELECT seq.nextval FROM DUAL </selectKey>
INSERT INTO EntityTable (PKEY, DATA) VALUES (?, ?)
</insert>
출처 : http://deadlock.tistory.com/172