{"id":333,"date":"2011-12-29T15:34:13","date_gmt":"2011-12-29T15:34:13","guid":{"rendered":"http:\/\/brain.dailyon.net\/?p=333"},"modified":"2011-12-29T15:34:13","modified_gmt":"2011-12-29T15:34:13","slug":"ibatis-insert-return-value","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=333","title":{"rendered":"iBatis : insert return value"},"content":{"rendered":"<p>1. insert \uc804\uc5d0\ub294 \ucd94\uac00\ud560 \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\uac00 \ubb34\uc5c7\uc774 \ub420 \uc9c0 \ubaa8\ub974\ub294 \uacbd\uc6b0 selectKey \ub97c \uc774\uc6a9\ud574 \ucd94\uac00\ub41c \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\ub97c \ubc18\ud658 \ubc1b\uc544 \ud655\uc778\ud55c\ub2e4.<\/p>\n<p>iBATIS 2.x \uc758 insert \uba54\uc11c\ub4dc\ub294 selectKey \uc640 \ud568\uaed8 \uc4f0\uc77c \uacbd\uc6b0 \uae30\ubcf8\ud0a4 \uac1d\uccb4\uc5d0 \ucd94\uac00\ub41c \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\ub97c \ub123\uc5b4 \ubc18\ud658\ud55c\ub2e4.<br \/>\n<code><\/code><\/p>\n<p><code>ProductDao.java<\/p>\n<p>public class ProductDao<br \/>\n{<br \/>\nSqlMapClient sqlMapClient;<\/p>\n<p>public boolean insertProduct(Product product)<br \/>\n{<br \/>\nInteger id = (Integer) sqlMapClient.insert(\u201cinsertProduct\u201d, product);<br \/>\nreturn id &gt; 0; \/\/ product.productId \uc5d0\ub3c4 \uac19\uc740 \uac12\uc774 \uc800\uc7a5\ub428<br \/>\n}<br \/>\n}<\/p>\n<p>Product.xml<\/p>\n<p>        SELECT S_Products.NEXTVAL FROM DUAL<\/p>\n<p>    INSERT INTO Products VALUES (#productId#, #productName#, #productCode#)<br \/>\n<\/code><\/p>\n<p>2. insert \uc804\uc5d0 \ucd94\uac00\ud560 \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\ub97c \uc54c\uace0 \uc788\uc744\ub54c\ub294?<\/p>\n<p>\ubcf8\ud0a4\ub97c \uc774\ubbf8 \uc54c\uace0 \uc788\ub2e4\uba74, <b><i>\uae30\ubcf8\ud0a4\ub97c \uc774\uc6a9\ud55c \uc131\uacf5\uc5ec\ubd80 \ud310\ub2e8\uc774 \ubd88\uac00\ub2a5\ud558\uae30 \ub54c\ubb38\uc5d0 insert \uad6c\ubb38\uc744 update \uba54\uc11c\ub4dc\ub85c \uc2e4\ud589\ud558\uc5ec \uc601\ud5a5 \ubc1b\uc740 \ud589\uc218\ub97c \ud3c9\uac00\ud55c\ub2e4.<\/i><\/b><\/p>\n<p><code>ProductDao.java<\/code><\/p>\n<p><code>public class ProductDao<br \/>\n{<br \/>\nSqlMapClient sqlMapClient;<\/p>\n<p>public boolean insertProduct(Product product)<br \/>\n{<br \/>\nint rows = sqlMapClient.update(\u201cinsertProduct\u201d, product);<br \/>\nreturn rows &gt; 0;<br \/>\n}<br \/>\n}<\/p>\n<p>Product.xml<\/p>\n<p><\/code><code><br \/>\nINSERT INTO Products VALUES (#productId#, #productName#, #productCode#)<\/p>\n<p><\/code><\/p>\n<p>3. \uc2e0\ub8b0\ud560 \ub9cc\ud558\ub2e4\uace0\ub4e4 \ud558\ub294 \ub610 \ub2e4\ub978 \ubc29\ubc95<\/p>\n<p>\uc608\uc678\ub97c \uc7a1\ub294 \uac83 \ub9cc\uc73c\ub85c\ub3c4 \uc0c1\ub2f9\ud788 \uc2e0\ub8b0\ud560\ub9cc\ud55c \uc131\uacf5\uc5ec\ubd80 \ud310\ub2e8\uc744 \ud560 \uc218 \uc788\ub2e4\uace0\ub4e4 \ud55c\ub2e4. \ub2e8, \uac1c\uc778\uc801\uc73c\ub85c\ub294 \uc660\uc9c0 \ucc1d\ucc1d\ud558\ub2e4. \uac00\uae09\uc801\uc774\uba74 1, 2 \ubc29\ubc95\uc73c\ub85c \ud310\ub2e8\ud558\uace0 \ub3c4\uc800\ud788 \ubc29\ubc95\uc774 \uc5c6\uc744 \uacbd\uc6b0\uc5d0 \uc2dc\ub3c4\ud574\ubcf4\ub3c4\ub85d \ud558\uc790. \ub610, \ud504\ub85c\uc2dc\uc800, \ud568\uc218\ub97c \uc774\uc6a9\ud574 DBMS \uc5d0\uac8c \uc131\uacf5\uc5ec\ubd80\ub97c \ud310\ub2e8\ud558\ub3c4\ub85d \ud558\ub294\uac83\ub3c4 \ud55c \ubc29\ubc95\uc774 \ub420 \uc218 \uc788\ub2e4.<\/p>\n<p>\ucd9c\ucc98 : http:\/\/yjacket.tistory.com\/51<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. insert \uc804\uc5d0\ub294 \ucd94\uac00\ud560 \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\uac00 \ubb34\uc5c7\uc774 \ub420 \uc9c0 \ubaa8\ub974\ub294 \uacbd\uc6b0 selectKey \ub97c \uc774\uc6a9\ud574 \ucd94\uac00\ub41c \ub808\ucf54\ub4dc\uc758 \uae30\ubcf8\ud0a4\ub97c \ubc18\ud658 \ubc1b\uc544 \ud655\uc778\ud55c\ub2e4. iBATIS 2.x \uc758 insert \uba54\uc11c\ub4dc\ub294 selectKey \uc640 \ud568\uaed8 \uc4f0\uc77c \uacbd\uc6b0&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/333"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=333"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}