{"id":126,"date":"2016-03-16T23:33:18","date_gmt":"2016-03-16T15:33:18","guid":{"rendered":"http:\/\/www.chenweikang.top\/?p=126"},"modified":"2016-03-16T23:51:18","modified_gmt":"2016-03-16T15:51:18","slug":"mybatis%e5%ad%a6%e4%b9%a0%e4%b9%8b%e8%b7%af-%e4%b8%80%e5%af%b9%e4%b8%80%e3%80%81%e4%b8%80%e5%af%b9%e5%a4%9a%e5%85%b3%e8%81%94%e6%98%a0%e5%b0%84","status":"publish","type":"post","link":"https:\/\/www.chenweikang.top\/?p=126","title":{"rendered":"Mybatis\u5b66\u4e60\u4e4b\u8def---\u4e00\u5bf9\u4e00\u3001\u4e00\u5bf9\u591a\u5173\u8054\u6620\u5c04"},"content":{"rendered":"

\u5728mybatis mapper\u914d\u7f6e\u6587\u4ef6\u4e2d\u4f7f\u7528 \u00a0 association \u914d\u7f6e\u4e00\u5bf9\u4e00\u5173\u8054\uff0ccollection \u914d\u7f6e\u4e00\u5bf9\u591a\u5173\u8054<\/p>\n

\u521b\u5efa\u6d4b\u8bd5\u7684\u5b9e\u4f53\uff1a<\/p>\n

Employee ( id,username,salary,deptID(\u90e8\u95e8id \u5916\u952e) ) ---\u5bf9\u5e94 EmployeeMapper\u63a5\u53e3<\/p>\n

Department (id,dept_name,dept_desc \u00a0) ----\u5bf9\u5e94 DepartmentMapper \u63a5\u53e3<\/p><\/blockquote>\n

1.\u4e00\u5bf9\u4e00\u5173\u8054<\/h2>\n

\u5728\u7c7b\u4e2d\u5efa\u7acb\u5173\u8054\u7684\u5bf9\u8c61<\/p>\n

 <\/p>\n

\u5728mapper\u4e2d\u4f7f\u7528 association \u914d\u7f6e\u5173\u8054\u5bf9\u8c61<\/p>\n

property: \u5b9e\u4f53\u7c7b\u4e2d\u7684\u53c2\u6570\u540d<\/p>\n

column\uff1a\u5b9e\u4f53\u7c7b\u4e2d\u7684\u5916\u952e\u5217<\/p>\n

select\uff1a\u8c03\u7528\u67e5\u8be2\u65b9\u6cd5<\/p>\n

<!-- \u00a0 \u914d\u7f6e\u7ed3\u679c\u96c6 -->
\n<resultMap type=\"Employee\" id=\"empRes\"><\/p>\n

<id property=\"id\" column=\"id\" \/><\/p>\n

<result property=\"username\" column=\"username\" \/><\/p>\n

<result property=\"salary\" column=\"salary\" \/><\/p>\n

<!-- \u5173\u8054department
\nproperty: \u5b9e\u4f53\u7c7b\u4e2d\u7684\u53c2\u6570\u540d
\ncolumn\uff1a\u5b9e\u4f53\u7c7b\u4e2d\u7684\u5916\u952e\u5217
\nselect\uff1a\u8c03\u7528\u67e5\u8be2\u65b9\u6cd5
\n--><\/p>\n

<association property=\"dept\"<\/p>\n

column=\"deptID\"<\/p>\n

select=\"com.cwk.dao.DepartmentMapper.findById\"><\/p>\n

<\/association>
\n<\/resultMap><\/p>\n

<!-- \u67e5\u8be2\u96c7\u5458\u548c\u90e8\u95e8\u4fe1\u606f\uff08\u5173\u8054\u67e5\u8be2\uff09<\/p>\n

-->
\n<select id=\"findEmpWithDeptById\" parameterType=\"Integer\" resultMap=\"empRes\"><\/p>\n

select * from employee e ,department d where e.deptID=d.id and e.id=#{id}
\n<\/select><\/p><\/blockquote>\n

\"2\"<\/p>\n

\u4e8c\u3001\u4e00\u5bf9\u591a\u5173\u8054<\/h2>\n

\u5173\u952e\uff1a\u76f8\u4e92\u8c03\u7528<\/p>\n

\u5728\u5b9e\u4f53\u4e2d\u521b\u5efa \u5173\u8054\u7684\u96c6\u5408 (List<Employee>)
\n\u5728EmployeeMapper \u4e2d\u521b\u5efa\u67e5\u8be2 emp\u5b9e\u4f53\u7684\u65b9\u6cd5
\n\u5728EmployeeMapper.xml\u4e2d\u6620\u5c04\u67e5\u8be2\u65b9\u6cd5
\n\u5728 DepartmentMapper.xml \u4e2d\u8c03\u7528 EmployeeMapper \u4e2d\u63d0\u4f9b\u7684\u65b9\u6cd5<\/p>\n

<!-- \u914d\u7f6e\u6b64\u5b9e\u4f53\u7684\u7ed3\u679c\u96c6 (\u5173\u8054\u591a\u4e2a\u96c7\u5458)-->
\n<resultMap type=\"Department\" id=\"departAndEmpRes\"><\/p>\n

<id property=\"id\" column=\"id\" \/><\/p>\n

<result property=\"deptName\" column=\"dept_name\" \/><\/p>\n

<result property=\"deptDesc\" column=\"dept_desc\" \/>
\n<!-- \u6620\u5c04\u5c5e\u6027\u96c6\u5408<\/p>\n

property=\"emps\" department\u4e2d\u7684\u96c7\u5458\u5c5e\u6027<\/p>\n

column=\"id\" \u90e8\u95e8\u4e3b\u952e\u7684id<\/p>\n

select=\"com.cwk.dao.EmployeeMapper.findByDeptId\" \u8c03\u7528EmployeeMapper\u4e2d\u7684\u63a5\u53e3\u67e5\u8be2\u96c7\u5458
\n--><\/p>\n

<collection property=\"emps\"<\/p>\n

column=\"id\"<\/p>\n

select=\"com.cwk.dao.EmployeeMapper.findEmpByDeptId\">
\n<\/collection>
\n<\/resultMap><\/p>\n

<!-- \u67e5\u8be2\u90e8\u95e8\u548c\u5173\u8054\u7684\u6240\u6709\u96c7\u5458
\n\u53c2\u6570\uff1a\u90e8\u95e8ID
\n\u8fd4\u56de\u7ed3\u679c\u96c6
\n--><\/p>\n

<!-- \u914d\u7f6e\u901a\u8fc7id\u67e5\u8be2\u90e8\u95e8 -->
\n<select id=\"findDeptAndEmpsById\" parameterType=\"Integer\" resultMap=\"departAndEmpRes\"><\/p>\n

select * from department where id=#{id}
\n<\/select><\/p>\n

 <\/p><\/blockquote>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u5de6\u624b\u4ee3\u7801\u53f3\u624b\u8bd7<\/a> » Mybatis\u5b66\u4e60\u4e4b\u8def---\u4e00\u5bf9\u4e00\u3001\u4e00\u5bf9\u591a\u5173\u8054\u6620\u5c04<\/a><\/p>

\r\n
\r\n
~\u8c22\u8c22\u6253\u8d4f~<\/div>\r\n
<\/div>
<\/div>
<\/div><\/div>\r\n