{"id":1498,"date":"2014-03-06T05:30:10","date_gmt":"2014-03-06T05:30:10","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1498"},"modified":"2014-03-06T05:30:10","modified_gmt":"2014-03-06T05:30:10","slug":"queryforobject","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1498","title":{"rendered":"queryForObject"},"content":{"rendered":"<p>\ud14c\uc774\ube14\uc5d0 \ub2e8\uc9c0 \uc874\uc7ac\ud558\ub294\uac12\uc778\uc9c0 \ud310\ub2e8\ud560\ub54c \uce74\uc6b4\ud2b8 \ucffc\ub9ac\ub85c \ucc98\ub9ac\ud558\ub294\uac83\uc774 \uc624\ube0c\uc81d\ud2b8\ub85c \ubc18\ud658\ud558\ub294\uac83\ubcf4\ub2e4 \uc548\uc804\ud55c \ub85c\uc9c1\uc774 \ub420\uac83\uac19\ub2e4.<br \/>\n==========================================================<\/p>\n<p>&#8211; \ub9cc\uc57d\uc5d0 \uc2e4\uc218\ub85c DB\uc5d0 \uc608\uc0c1\uacfc\ub294 \ub2e4\ub974\uac8c 2\uac1c\uc774\uc0c1\uc774 \ub418\uc5c8\uc744\ub54c \uc608\uc678\ub97c \ubc1c\uc0dd\uc2dc\ud0b4<br \/>\n(\ud2b9\uc815VO)getSqlMapClientTemplate().queryForObject(&#8220;XML\uc774\ub984.selectID&#8221;, map);<br \/>\n(Integer)getSqlMapClientTemplate().queryForObject(&#8220;XML\uc774\ub984.countID&#8221;, map);<\/p>\n<p>==========================================================<br \/>\n<select id=\"blablaId\" parameterClass=\"java.util.Map\" resultClass=\"java.lang.Integer\"><br \/>\n    <![CDATA[\n\tSELECT\tCOUNT(1)\n\t from TABLENAME\n     where no = #empNo:DECIMAL#\n    ]]><br \/>\n<\/select><br \/>\n==========================================================<br \/>\nqueryForObject :<\/p>\n<p>DB\ub85c\ubd80\ud130 1\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc640 \uc790\ubc14 \uac1d\uccb4\uc5d0 \uc800\uc7a5\ud55c\ub2e4. <\/p>\n<p>\uc624\uc9c1 \ud55c \uac1c\uc758 \ub808\ucf54\ub4dc\ub9cc \ubc18\ud658\ub418\ub294 \uc5ec\ubd80\ub97c \uac80\uc0ac\ud558\ub294 \uba54\uc18c\ub4dc \uc774\ubbc0\ub85c \ud558\ub098\uc774\uc0c1\uc758 \ub808\ucf54\ub4dc\uac00 \ubc18\ud658\ub418\ub294 \uacbd\uc6b0 [\uc608\uc678\ucc98\ub9ac] \ub428. \uadf8\ub9ac\uace0 \uac12\uc774\uc5c6\uc744\uacbd\uc6b0\ub294 null\uc744 \ubc18\ud658<\/p>\n<p>queryForList : DB\ub85c\ubd80\ud130 1\uac1c\uc774\uc0c1\uc758 \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc640 \uc790\ubc14 \uac1d\uccb4\uc758 List\ub97c \ub9cc\ub4dc\ub294\ub370 \uc0ac\uc6a9\ud55c\ub2e4<\/p>\n<p>==========================================================<\/p>\n<p>iBatis in Action\uc5d0\uc11c \ub098\uc628 \uae00\uc778\ub370, queryForObject \uc0ac\uc6a9\uc2dc\uc5d0 \uc8fc\uc758\uc810\uc744 \uae30\ub85d\ud574 \ub1a8\ub2e4.<\/p>\n<p>\uc5ed\ud560<br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\ubd80\ud130 1\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc640 \uc790\ubc14 \uac1d\uccb4\uc5d0 \uc800\uc7a5\ud55c\ub2e4.<\/p>\n<p>\uc2dc\uadf8\ub2c8\ucc98<br \/>\n1. Object queryForObject(String id, Object parameter) throws SQLException;<br \/>\n2. Object queryForObject(String id, Object parameter, Object result) throws SQLException;<\/p>\n<p>\uc8fc\uc758\uc810<br \/>\n1. \ub9ac\ud134\uac12\uc744 \ubc1b\ub294 \uac1d\uccb4\uc5d0 \ub514\ud3f4\ud2b8 \uc0dd\uc131\uc790\uac00 \uc5c6\ub2e4\uba74, \ub7f0\ud0c0\uc784 \uc608\uc678\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4.<br \/>\n2. \ub450\ubc88\uc9f8 \uc2dc\uadf8\ub2c8\ucc98\uc5d0\uc11c\ub294 3\ubc88\uc9f8 \ud30c\ub77c\ubbf8\ud130\uac00 \ub9ac\ud134\uac12\uc744 \ub300\uc2e0\ud55c\ub2e4. \ub9ac\ud134\uac12\uc744 \ubc1b\ub294 \uac1d\uccb4\uc5d0 \ub514\ud3f4\ud2b8 \uc0dd\uc131\uc790\uac00 \uc5c6\uac70\ub098, \ud639\uc740 protected \uc778 \uacbd\uc6b0\uc5d0 3\ubc88\uc9f8 \ud30c\ub77c\ubbf8\ud130\ub85c \uc804\ub2ec\ud574\uc11c \ub9ac\ud134\uac12\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub2e4.<br \/>\n3. 1\uac1c\uc774\uc0c1\uc758 \ub808\ucf54\ub4dc\ub97c \ubc18\ud658\ud558\uba74 \uc608\uc678\ub97c \ub358\uc9c4\ub2e4. \uc5ed\ud560\uc5d0\uc11c \ubc1d\ud78c\ubc14\ub300\ub85c 1\uac1c\uc758 \ub808\ucf54\ub4dc\ub9cc\uc744 \uac00\uc838\uc640\uc57c \ud55c\ub2e4.<\/p>\n<p>http:\/\/kmj1107.tistory.com\/entry\/queryForList-queryForObject-%EC%B0%A8%EC%9D%B4%EC%A0%90<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud14c\uc774\ube14\uc5d0 \ub2e8\uc9c0 \uc874\uc7ac\ud558\ub294\uac12\uc778\uc9c0 \ud310\ub2e8\ud560\ub54c \uce74\uc6b4\ud2b8 \ucffc\ub9ac\ub85c \ucc98\ub9ac\ud558\ub294\uac83\uc774 \uc624\ube0c\uc81d\ud2b8\ub85c \ubc18\ud658\ud558\ub294\uac83\ubcf4\ub2e4 \uc548\uc804\ud55c \ub85c\uc9c1\uc774 \ub420\uac83\uac19\ub2e4. ========================================================== &#8211; \ub9cc\uc57d\uc5d0 \uc2e4\uc218\ub85c DB\uc5d0 \uc608\uc0c1\uacfc\ub294 \ub2e4\ub974\uac8c 2\uac1c\uc774\uc0c1\uc774 \ub418\uc5c8\uc744\ub54c \uc608\uc678\ub97c \ubc1c\uc0dd\uc2dc\ud0b4 (\ud2b9\uc815VO)getSqlMapClientTemplate().queryForObject(&#8220;XML\uc774\ub984.selectID&#8221;, map); (Integer)getSqlMapClientTemplate().queryForObject(&#8220;XML\uc774\ub984.countID&#8221;, map); ========================================================== ========================================================== queryForObject&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\/1498"}],"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=1498"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}