IBATIS/myBatis
2022.05.02 / 15:58
MyBatis - selectKey »ç¿ëÇϱâ
ÄÚÄÚ·Î
Ãßõ ¼ö 117
MyBatis - selectKey »ç¿ëÇϱâ
MyBatis 2019. 3. 6. 22:32
selectKey ´Â insert ±¸¹®ÀÌ ½ÇÇàµÇ±â Àü ÈÄ ·Î ³ª´©¾î¼ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
¾Æ·¡ÀÇ ¿¹½Ã´Â insert°¡ µÇ±â Àü ½ÃÄö½ºÀÇ °ªÀ» ¹Þ¾Æ¿À´Â °ÍÀÌ´Ù.
<insert id="insertAuthor" parameterType="author">
<selectKey keyProperty="id" resultType="_int" order="BEFORE">
select seq_authorno.currval from dual
</selectKey>
insert int Author values (seq_authorno.nextval, #{name})
</insert>
insert°¡ µÈ ÈÄ ½ÃÄö½ºÀÇ °ªÀ» ¹Þ¾Æ¿À´Â ¿¹½ÃÀÌ´Ù.
<insert id="insertAuthor" parameterType="author">
insert int Author values (seq_authorno.nextval, #{name})
<selectKey keyProperty="id" resultType="_int" order="AFTER">
select seq_authorno.currval from dual
</selectKey>
</insert>
order ¼Ó¼ºÀ¸·Î ±¸ºÐµÇ´Â µ¥ BEFORE ¿Í AFTER °¡ ÀÖ´Ù.
keyProperty ¼Ó¼ºÀº selectKey ±¸¹®ÀÇ °á°ú°¡ ÀúÀåµÇ´Â ´ë»ó ÇÁ·ÎÆÛƼ¸¦ Àû¾îÁØ´Ù.
À§ÀÇ ¿¹½Ã¿¡¼´Â Author °´Ã¼ÀÇ id ¼Ó¼º¿¡ ÀúÀåµÈ´Ù.
Ãâó: https://sinna94.tistory.com/entry/MyBatis-selectKey-»ç¿ëÇϱâ?category=696828 [Chungs]