{"id":709,"date":"2017-10-19T00:01:49","date_gmt":"2017-10-18T16:01:49","guid":{"rendered":"https:\/\/199604.com\/?p=709"},"modified":"2017-10-19T19:31:22","modified_gmt":"2017-10-19T11:31:22","slug":"mybatis%e4%b8%adcollection%e5%92%8cassociation%e7%9a%84%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/199604.com\/709","title":{"rendered":"Mybatis\u4e2dcollection\u548cassociation\u7684\u4f7f\u7528\u533a\u522b"},"content":{"rendered":"

\u6700\u8fd1\u4e00\u76f4\u628acollection\u548cassociation\u5f04\u6df7\uff0c\u6240\u4ee5\u4e3a\u4e86\u589e\u5f3a\u81ea\u5df1\u7684\u8bb0\u5fc6\uff0c\u5c31\u64b8\u4e00\u4e2a\u5173\u7cfb\u51fa\u6765\u7b97\u662f\u603b\u7ed3\u7f62\u4e86<\/p>\n

\n

1. \u5173\u8054-association
\n2. \u96c6\u5408-collection<\/p>\n

\u6bd4\u5982\u540c\u65f6\u6709User.java\u548cCard.java\u4e24\u4e2a\u7c7b<\/p>\n

User.java\u5982\u4e0b:<\/p>\n

public class User{<\/p>\n

private Card card_one;<\/p>\n

private List<Card> card_many;<\/p>\n

}<\/p>\n

\u5728\u6620\u5c04card_one\u5c5e\u6027\u65f6\u7528association\u6807\u7b7e, \u6620\u5c04card_many\u65f6\u7528collection\u6807\u7b7e.<\/p>\n

\u6240\u4ee5association\u662f\u7528\u4e8e\u4e00\u5bf9\u4e00\u548c\u591a\u5bf9\u4e00\uff0c\u800ccollection\u662f\u7528\u4e8e\u4e00\u5bf9\u591a\u7684\u5173\u7cfb<\/p>\n

\u4e0b\u9762\u5c31\u7528\u4e00\u4e9b\u4f8b\u5b50\u89e3\u91ca\u4e0b\u5427<\/p>\n

association-\u4e00\u5bf9\u4e00<\/p>\n

\u4eba\u548c\u8eab\u4efd\u8bc1\u7684\u5173\u7cfb<\/p>\n

\u4e0b\u9762\u662fpojo<\/p>\n

public class Card implements Serializable{\r\n\tprivate Integer id;\r\n\tprivate String code;\r\n\/\/\u7701\u7565set\u548cget\u65b9\u6cd5.\r\n}<\/pre>\n
public class Person implements Serializable{\r\n\tprivate Integer id;\r\n\tprivate String name;\r\n\tprivate String sex;\r\n\tprivate Integer age;\r\n\t\/\/\u4eba\u548c\u8eab\u4efd\u8bc1\u662f\u4e00\u5bf9\u4e00\u7684\u5173\u7cfb\r\n\tprivate Card card;\r\n\/\/\u7701\u7565set\/get\u65b9\u6cd5.\r\n}<\/pre>\n
\u4e0b\u9762\u662fmapper\u548c\u5b9e\u73b0\u7684\u63a5\u53e3<\/p>\n
package com.glj.mapper;\r\n\r\nimport com.glj.poji.Card;\r\n\r\npublic interface CardMapper {\r\n\tCard selectCardById(Integer id);\r\n}\r\n<\/pre>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper\r\n    PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n    \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"com.glj.mapper.CardMapper\">\r\n\t<select id=\"selectCardById\" parameterType=\"int\" resultType=\"com.glj.poji.Card\">\r\n\t\tselect * from tb_card where id = #{id} \r\n\t<\/select>\r\n<\/mapper><\/pre>\n
package com.glj.mapper;\r\n\r\nimport com.glj.poji.Person;\r\n\r\npublic interface PersonMapper {\r\n\tPerson selectPersonById(Integer id);\r\n}\r\n<\/pre>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper\r\n    PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n    \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"com.glj.mapper.PersonMapper\">\r\n\t<resultMap type=\"com.glj.poji.Person\" id=\"personMapper\">\r\n\t\t<id property=\"id\" column=\"id\"\/>\r\n\t\t<result property=\"name\" column=\"name\"\/>\r\n\t\t<result property=\"sex\" column=\"sex\"\/>\r\n\t\t<result property=\"age\" column=\"age\"\/>\r\n\t\t<association property=\"card\" column=\"card_id\" \r\n\t\t\tselect=\"com.glj.mapper.CardMapper.selectCardById\"\r\n\t\t\tjavaType=\"com.glj.poji.Card\">\r\n\t\t<\/association>\r\n\t<\/resultMap>\r\n\t<select id=\"selectPersonById\" parameterType=\"int\" resultMap=\"personMapper\">\r\n\t\tselect * from tb_person where id = #{id}\r\n\t<\/select>\r\n<\/mapper><\/pre>\n
PersonMapper.xml \u8fd8\u4f7f\u7528association\u7684\u5206\u6b65\u67e5\u8be2\u3002<\/p>\n
\u540c\u7406\u591a\u5bf9\u4e00\uff0c\u4e5f\u662f\u4e00\u6837<\/p>\n
\u53ea\u8981\u90a3\u4e2apojo\u51fa\u73b0private Card card_one;<\/p>\n
\u5373\u4f7f\u7528association<\/p>\n
\n
collection \u4e00\u5bf9\u591a\u548cassociation\u7684\u591a\u5bf9\u4e00\u5173\u7cfb<\/p>\n
\u5b66\u751f\u548c\u73ed\u7ea7\u7684\u4e00\u5bf9\u591a\u7684\u4f8b\u5b50<\/p>\n
pojo\u7c7b<\/p>\n
package com.glj.pojo;\r\n\r\nimport java.io.Serializable;\r\nimport java.util.List;\r\n\r\npublic class Clazz implements Serializable{\r\n\tprivate Integer id;\r\n\tprivate String code;\r\n\tprivate String name;\r\n        \/\/\u73ed\u7ea7\u4e0e\u5b66\u751f\u662f\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\r\n\tprivate List<Student> students;\r\n\/\/\u7701\u7565set\/get\u65b9\u6cd5\r\n}\r\n<\/pre>\n
package com.glj.pojo;\r\n\r\nimport java.io.Serializable;\r\n\r\npublic class Student implements Serializable {\r\n\tprivate Integer id;\r\n\tprivate String name;\r\n\tprivate String sex;\r\n\tprivate Integer age;\r\n        \/\/\u5b66\u751f\u4e0e\u73ed\u7ea7\u662f\u591a\u5bf9\u4e00\u7684\u5173\u7cfb\r\n\tprivate Clazz clazz;\r\n\/\/\u7701\u7565set\/get\u65b9\u6cd5\r\n}\r\n<\/pre>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper\r\n    PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n    \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"com.glj.mapper.ClazzMapper\">\r\n\t<select id=\"selectClazzById\" parameterType=\"int\" resultMap=\"clazzResultMap\">\r\n\t\tselect * from tb_clazz where id = #{id}\r\n\t<\/select>\r\n\t<resultMap type=\"com.glj.pojo.Clazz\" id=\"clazzResultMap\">\r\n\t\t<id property=\"id\" column=\"id\"\/>\r\n\t\t<result property=\"code\" column=\"code\"\/>\r\n\t\t<result property=\"name\" column=\"name\"\/>\r\n\t\t<!-- property: \u6307\u7684\u662f\u96c6\u5408\u5c5e\u6027\u7684\u503c, ofType\uff1a\u6307\u7684\u662f\u96c6\u5408\u4e2d\u5143\u7d20\u7684\u7c7b\u578b -->\r\n\t\t<collection property=\"students\" ofType=\"com.glj.pojo.Student\"\r\n\t\tcolumn=\"id\" javaType=\"ArrayList\"\r\n\t\tfetchType=\"lazy\" select=\"com.glj.mapper.StudentMapper.selectStudentByClazzId\">\r\n\t\t\t<id property=\"id\" column=\"id\"\/>\r\n\t\t\t<result property=\"name\" column=\"name\"\/>\r\n\t\t\t<result property=\"sex\" column=\"sex\"\/>\r\n\t\t\t<result property=\"age\" column=\"age\"\/>\r\n\t\t<\/collection>\r\n\t<\/resultMap>\r\n<\/mapper><\/pre>\n
package com.glj.mapper;\r\n\r\nimport com.glj.pojo.Clazz;\r\n\r\npublic interface ClazzMapper {\r\n\tClazz selectClazzById(Integer id);\r\n}\r\n<\/pre>\n
ClazzMapper\u4f7f\u7528\u5230\u4e86\u96c6\u5408-collection \u5373\u4e3a\u4e00\u5bf9\u591a\uff0c\u4e00\u4e2a\u73ed\u7ea7\u9762\u5bf9\u591a\u4e2a\u5b66\u751f<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper\r\n    PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n    \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"com.glj.mapper.StudentMapper\">\r\n\t<select id=\"selectStudentById\" parameterType=\"int\" resultMap=\"studentResultMap\">\r\n\t\tselect * from tb_clazz c,tb_student s where c.id = s.id and s.id = #{id}\r\n\t<\/select>\r\n\t<select id=\"selectStudentByClazzId\" parameterType=\"int\" resultMap=\"studentResultMap\">\r\n\t\tselect * from tb_student where clazz_id = #{id}\r\n\t<\/select>\r\n\t<resultMap type=\"com.glj.pojo.Student\" id=\"studentResultMap\">\r\n\t\t<id property=\"id\" column=\"id\"\/>\r\n\t\t<result property=\"name\" column=\"name\"\/>\r\n\t\t<result property=\"sex\" column=\"sex\"\/>\r\n\t\t<result property=\"age\" column=\"age\"\/>\r\n\t\t<association property=\"clazz\" javaType=\"com.glj.pojo.Clazz\">\r\n\t\t\t<id property=\"id\" column=\"id\"\/>\r\n\t\t\t<result property=\"code\" column=\"code\"\/>\r\n\t\t\t<result property=\"name\" column=\"name\"\/>\r\n\t\t<\/association>\r\n\t<\/resultMap>\r\n<\/mapper><\/pre>\n
package com.glj.mapper;\r\n\r\nimport com.glj.pojo.Student;\r\n\r\npublic interface StudentMapper {\r\n\tStudent selectStudentById(Integer id); \r\n}\r\n<\/pre>\n
StudentMapper\u5219\u662f\u4e0e\u73ed\u7ea7\u4e3a\u591a\u5bf9\u4e00\u5173\u7cfb\uff0c\u6240\u4ee5\u4f7f\u7528\u4e86\u5173\u8054-association<\/p>\n
\n
\u55ef\uff0c\u5e0c\u671b\u6211\u4ee5\u540e\u53c8\u4e0d\u8bb0\u5f97\u4e8c\u8005\u7684\u5173\u7cfb\u65f6,\u80fd\u611f\u8c22\u73b0\u5728\u603b\u7ed3\u7684\u81ea\u5df1<\/p>\n
\u9644\u4e0a\u4e00\u5f20mybatis\u7684\u7c7b\u578b\u522b\u540d\u56fe<\/p>\n
\"\"<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
\u6700\u8fd1\u4e00\u76f4\u628acollection\u548cassociation\u5f04\u6df7\uff0c\u6240\u4ee5\u4e3a\u4e86\u589e\u5f3a\u81ea\u5df1\u7684\u8bb0\u5fc6\uff0c\u5c31\u64b8\u4e00\u4e2a\u5173\u7cfb\u51fa\u6765\u7b97\u662f\u603b\u7ed3\u7f62 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[130],"tags":[160,159,153],"class_list":["post-709","post","type-post","status-publish","format-standard","hentry","category-java","tag-association","tag-collection","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/comments?post=709"}],"version-history":[{"count":5,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/709\/revisions"}],"predecessor-version":[{"id":715,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/709\/revisions\/715"}],"wp:attachment":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/media?parent=709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/categories?post=709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/tags?post=709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}