iBatis: Return id on Insert
Saturday, October 11th, 2008<insert id=”addProduct” parameterClass=”sample.Product”>
insert into PRODUCT (name,desc) values (#name#, #description#)
<selectKey resultClass=”Long”>
select LAST_INSERT_ID() as id
</selectKey>
</insert>
insert into PRODUCT (name,desc) values (#name#, #description#)
<selectKey resultClass=”Long”>
select LAST_INSERT_ID() as id
</selectKey>
</insert>
