{"id":6861,"date":"2022-08-03T17:45:50","date_gmt":"2022-08-03T09:45:50","guid":{"rendered":"http:\/\/123.57.164.21\/?p=6861"},"modified":"2022-08-04T13:01:39","modified_gmt":"2022-08-04T05:01:39","slug":"mybatis%e4%b8%ad%e7%9a%84collection%e6%a0%87%e7%ad%be%e4%b8%ad%e7%9a%84javatype%e5%92%8coftype%e5%b1%9e%e6%80%a7%e7%9a%84%e5%8c%ba%e5%88%ab","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=6861","title":{"rendered":"Mybatis\u4e2d\u7684collection\u6807\u7b7e\u4e2d\u7684javaType\u548cofType\u5c5e\u6027\u7684\u533a\u522b"},"content":{"rendered":"\n<p>\u5728\u4f7f\u7528mybatis\u65f6\uff0c\u6709\u65f6\u5019\u9700\u8981\u5728\u6570\u636e\u5e93\u4e2d\u8fdb\u884c\u5173\u8054\u67e5\u8be2(left\/right join)\u6765\u6839\u636e\u67d0\u4e2a\u5b57\u6bb5\u83b7\u53d6\u5230\u53e6\u4e00\u4e2a\u8868\u7684\u7684\u4e00\u4e2aList\u96c6\u5408\u3002\u5728\u914d\u7f6eresultMap\u65f6\uff0c\u9700\u8981\u7528\u5230collection\u6807\u7b7e\u5bf9\u8fd9\u4e2aLIst\u5c5e\u6027\u8fdb\u884c\u6620\u5c04\uff1a<br>\u6bd4\u5982\u5728\u90e8\u95e8\u8868\u4e2d\u6709\u4e00\u4e2a\u5217\u8868List\u5b58\u653e\u8fd9\u4e2a\u8868\u4e2d\u7684\u6240\u6709\u5458\u5de5\uff0cjavaBean\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">public class Department {\n\n\tprivate Integer id;\n\tprivate String departmentName;\n\tprivate List&lt;Employee> emps;\n}\n<\/pre>\n\n\n\n<p>\u5458\u5de5\u8868\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">public class Employee {\n\n\tprivate Integer id;\n\tprivate String lastName;\n\tprivate String email;\n\tprivate String gender;\n}<\/pre>\n\n\n\n<p>\u7528mybatis\u5bf9\u8fd9\u4e24\u4e2a\u8868\u8fdb\u884c\u5173\u8054\u67e5\u8be2\u67e5\u8be2\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;select id=\"getDeptByIdPlus\" resultMap=\"MyDept\">\n\t\tSELECT d.id did, d.dept_name dept_name,\n\t\t\te.id eid, e.last_name last_name, e.email email,e.gender gender\n\t\tFROM department d\n\t\tLEFT JOIN employee e\n\t\tON d.id = e.d_id\n\t\tWHERE d.id = 1\n&lt;\/select> \n<\/pre>\n\n\n\n<p>\u7531\u4e8e\u662f\u901a\u8fc7\u5173\u8054\u67e5\u8be2\u5f97\u5230\u7684\u8fd9\u4e2aList\uff0c\u6240\u4ee5\u6b64\u65f6\u9700\u8981\u7528\u5230resultMap\u6807\u7b7e\u5bf9\u8fd4\u56de\u503c\u7684\u7c7b\u578b\u8fdb\u884c\u81ea\u5b9a\u4e49\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;resultMap type=\"bean.Department\" id=\"MyDept\">\n\t\t&lt;id column=\"did\" property=\"id\"\/>\n\t\t&lt;result column=\"dept_name\" property=\"departmentName\"\/>\n\t\t&lt;!-- \n\t\t\tcollection\u5b9a\u4e49\u5173\u8054\u7684\u96c6\u5408\u7c7b\u578b\u7684\u5c5e\u6027\u7684\u5c01\u88c5\u89c4\u5219:\n\t\t\tproperty=\"emps\":\u6307\u5b9a\u8fd9\u662f\u54ea\u4e2a\u96c6\u5408\u5c5e\u6027\uff0c\u8fd9\u91cc\u4e3a\u90a3\u4e2a\u96c6\u5408\u5c5e\u6027emps\n\t\t\tofType:\u6307\u5b9a\u96c6\u5408\u5185\u5c01\u88c5\u7684JavaBean\u7c7b\u578b(\u96c6\u5408\u5185\u88c5\u7684\u4ec0\u4e48)\uff0c\u8fd9\u91cc\u5373\u4e3aEmployee\u7c7b\n\t\t -->\n\t\t&lt;collection property=\"emps\" ofType=\"bean.Employee\">\n\t\t\t&lt;!-- \u5b9a\u4e49\u96c6\u5408\u4e2d\u5143\u7d20\u7684\u5c01\u88c5\u89c4\u5219 -->\n\t\t\t&lt;id column=\"eid\" property=\"id\"\/>\n\t\t\t&lt;result column=\"last_name\" property=\"lastName\"\/>\n\t\t\t&lt;result column=\"email\" property=\"email\"\/>\n\t\t\t&lt;result column=\"gender\" property=\"gender\"\/>\n\t\t&lt;\/collection>\n&lt;\/resultMap>\n<\/pre>\n\n\n\n<p>\u5728\u8fd9\u4e2aresultMap \u6807\u7b7e\u4e2d\uff0c\u7528collection\u8fd9\u4e2a\u5b50\u6807\u7b7e\u5bf9\u8fd9\u4e2aList\u8fdb\u884c\u6620\u5c04\u3002<\/p>\n\n\n\n<p>\u901a\u8fc7Alt+\/\u53ef\u4ee5\u53d1\u73b0\uff0ccollection\u6807\u7b7e\u4e2d\u5305\u542b\u4e24\u4e2a\u5173\u4e8ejavaBean\u7684Type\u5c5e\u6027\u5206\u522b\u662fofType\u548cjavaType\u3002<\/p>\n\n\n\n<p>\u5176\u4e2dofType\u6307\u5b9a\u7684\u8fd9\u4e2aList\u6240\u5b58\u653e\u7684javaBean\u7684\u7c7b\u578b\uff0c\u6bd4\u5982\u8fd9\u91cc\u5c31\u662fEmployee\u7c7b\u578b\u3002<\/p>\n\n\n\n<p>\u800cjavaType\u6307\u5b9a\u7684\u5f53\u524d\u8fd9\u4e2a\u914d\u7f6e\u7684\u6807\u7b7e\u6240\u5bf9\u5e94\u7684\u5c5e\u6027\uff0c\u6bd4\u5982\u6211\u4eec\u8fd9\u91cc\u7684collection\u914d\u7f6e\u7684\u662f\u4e00\u4e2aList\uff0c\u5c31\u53ef\u4ee5\u914d\u7f6e\u6210javaType=\u201cjava.util.ArrayList\u201d\uff08\u6b64\u5904\u6ca1\u5199\uff09\u3002<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u4f7f\u7528mybatis\u65f6\uff0c\u6709\u65f6\u5019\u9700\u8981\u5728\u6570\u636e\u5e93\u4e2d\u8fdb\u884c\u5173\u8054\u67e5\u8be2(left\/right join)\u6765\u6839\u636e\u67d0\u4e2a\u5b57\u6bb5\u83b7\u53d6\u5230 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6861"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6861"}],"version-history":[{"count":2,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6861\/revisions"}],"predecessor-version":[{"id":6870,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6861\/revisions\/6870"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}