{"id":424,"date":"2012-01-19T00:44:08","date_gmt":"2012-01-19T00:44:08","guid":{"rendered":"http:\/\/brain.dailyon.net\/?p=424"},"modified":"2012-01-19T00:44:08","modified_gmt":"2012-01-19T00:44:08","slug":"mybatis-iterate-tag","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=424","title":{"rendered":"myBatis : iterate tag"},"content":{"rendered":"

Query\ubb38 \uc911 \uac00\ub054 \ub3d9\uc801\uc73c\ub85c \uc5b4\ub5a0\ud55c \ucffc\ub9ac\ub97c \uc0dd\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4..
\n\uc608\ub97c \ub4e4\uba74 \uc5b4\ub5a0\ud55c \ub9ac\uc2a4\ud2b8\uc5d0 \uc788\ub294 \uac12\uc744 \ud1b5\ud574 \ucffc\ub9ac\ubb38\uc744 \uc0dd\uc131\ud55c\ub2e4\ub358\uc9c0 \ud558\ub294 \uacbd\uc6b0 iBatis\uc5d0\uc11c\ub294 iterate \ud0dc\uadf8\ub85c for\ubb38\uacfc \uac19\uc740 \uc5ed\ud560\uc744 \ud558\uc5ec \ub3d9\uc801 \ucffc\ub9ac\ub97c \uc0dd\uc131 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc704\uc640 \uac19\uc774 parameterClass\ub97c java\uc758 List\ud615\ud0dc\ub85c \uc804\ub2ec\ud574 \uc8fc\uba74 \ub3d9\uc801\ucffc\ub9ac\ub97c \uc0dd\uc131\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d list\uc5d0 1,2,3,4 \uc758 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4\uac00 \uc788\uc73c\uba74 \uacb0\uacfc\uc801\uc73c\ub85c
\n\ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub418\ub294 \uac83\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\ub807\uac8c iterate\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub3d9\uc801\uc73c\ub85c \ucffc\ub9ac\ubb38\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\tSELECT
\n\t\tcount(0)
\n\tFROM data_tb<\/p>\n

\t#[]#<\/p>\n

<\/code><\/p>\n

\uc704\uc640 \uac19\uc774 parameterClass\ub97c java\uc758 List\ud615\ud0dc\ub85c \uc804\ub2ec\ud574 \uc8fc\uba74 \ub3d9\uc801\ucffc\ub9ac\ub97c \uc0dd\uc131\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d list\uc5d0 1,2,3,4 \uc758 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4\uac00 \uc788\uc73c\uba74 \uacb0\uacfc\uc801\uc73c\ub85c
\n\ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub418\ub294 \uac83\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\tSELECT
\n\t\tcount(0)
\n\tFROM data_tb
\n\tWHERE id IN (1,2,3,4)<\/p>\n

<\/code><\/p>\n

\ub610\ud55c parameterClass\uac00 list\ud615\ud0dc\uac00 \uc544\ub2cc Map\uc774 List\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ud615\ud0dc\ub3c4 iterate\uc758 property \uc18d\uc131\uc744 \ud1b5\ud574 \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\ub9cc\uc57d HashMap\uc5d0 paramList\ub77c\ub294 \uc774\ub984\uc73c\ub85c list\ud615\uc774 \ub4e4\uc5b4\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud558\uba74
\n
\n\uc608)
\n HashMap paramMap = new HashMap();
\nList paramList = new ArrayList();
\nparamMap.put(\"paramList\", paramList);
\n<\/code><\/p>\n

<\/p>\n

\tSELECT
\n\t\t*
\n\tFROM data_tb<\/p>\n

#paramList[]#<\/p>\n

<\/code>
\n\uc704\uc640 \uac19\uc774 HashMap\uc5d0 \ub4e4\uc5b4\uc788\ub294 list\ub294 iterate\uc758 property \uc18d\uc131\uc744 \ud1b5\ud574 List\ub97c \uac00\uc838 \uc635\ub2c8\ub2e4. ##\uc0ac\uc774\ub294 HashMap\uc5d0 put\ud588\ub358 list\uc774\ub984\uc744 \ub123\uc5b4\uc8fc\uc154\uc57c \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n

\ucd9c\ucc98 : http:\/\/javastore.tistory.com\/100<\/p>\n","protected":false},"excerpt":{"rendered":"

Query\ubb38 \uc911 \uac00\ub054 \ub3d9\uc801\uc73c\ub85c \uc5b4\ub5a0\ud55c \ucffc\ub9ac\ub97c \uc0dd\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.. \uc608\ub97c \ub4e4\uba74 \uc5b4\ub5a0\ud55c \ub9ac\uc2a4\ud2b8\uc5d0 \uc788\ub294 \uac12\uc744 \ud1b5\ud574 \ucffc\ub9ac\ubb38\uc744 \uc0dd\uc131\ud55c\ub2e4\ub358\uc9c0 \ud558\ub294 \uacbd\uc6b0 iBatis\uc5d0\uc11c\ub294 iterate \ud0dc\uadf8\ub85c for\ubb38\uacfc \uac19\uc740 \uc5ed\ud560\uc744 \ud558\uc5ec \ub3d9\uc801 \ucffc\ub9ac\ub97c… <\/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\/424"}],"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=424"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/424\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}