{"id":1982,"date":"2017-06-15T20:53:23","date_gmt":"2017-06-15T12:53:23","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=1982"},"modified":"2020-02-05T11:02:38","modified_gmt":"2020-02-05T03:02:38","slug":"mybatis%e5%a4%9a%e8%a1%a8%e5%85%b3%e8%81%94%e6%9f%a5%e8%af%a2%e4%b9%8b%e5%a4%9a%e5%af%b9%e4%b8%80%e5%92%8c%e4%b8%80%e5%af%b9%e5%a4%9a","status":"publish","type":"post","link":"https:\/\/ai.zhousir.top\/?p=1982","title":{"rendered":"Mybatis\u591a\u8868\u5173\u8054\u67e5\u8be2\u4e4b\u591a\u5bf9\u4e00\u548c\u4e00\u5bf9\u591a"},"content":{"rendered":"

Mybatis\u591a\u8868\u5173\u8054\u53ef\u5206\u6210\u56db\u79cd\u60c5\u51b5:\u4e00\u5bf9\u4e00, \u4e00\u5bf9\u591a, \u591a\u5bf9\u4e00, \u591a\u5bf9\u591a.\u5b9e\u73b0\u6620\u5c04\u7684\u5173\u952e\u662fresultMap\u7f51\u4e0a\u6709\u5f88\u591a\u4ecb\u7ecd\u53ef\u81ea\u884c\u641c\u7d22\u5b66\u4e60\uff0c\u5982:MyBatis\u5b66\u4e60 \u4e4b \u4e8c\u3001SQL\u8bed\u53e5\u6620\u5c04\u6587\u4ef6(1)resultMap<\/a><\/p>\n

\u9996\u5148\u770b\u4e0b\u591a\u5bf9\u4e00\u5b9e\u73b0<\/h2>\n

\u51c6\u5907\u4e24\u5f20\u8868person\u548corder\u4e3a1:n\u5173\u7cfb<\/h3>\n

\"person_order\"<\/a><\/p>\n

\u7c7b\u7ed3\u6784\uff1a<\/h3>\n

\"class7\"<\/p>\n

\u6620\u5c04\u6587\u4ef6:OrderMapper.xml<\/h3>\n

\u7b2c\u4e00\u79cd\u6620\u5c04\u65b9\u5f0f:<\/h4>\n

[java]<mapper namespace="com.ittx.mybatis.demo1.dao.OrderDao">
\n\t<resultMap type="com.ittx.mybatis.demo1.model.Order" id="orderBean">
\n\t\t<id column="orderId" property="id"\/>
\n\t\t<result column="orderNumber" property="number"\/>
\n\t\t<result column="orderPrice" property="price"\/>
\n\t\t<!– \u591a\u5bf9\u4e00\u7684\u5173\u7cfb –>
\n\t\t<!–column:\u6307\u5916\u952e\u503c\uff0c property: \u6307\u7684\u662f\u5c5e\u6027\u7684\u503c, javaType\uff1a\u6307\u7684\u662f\u5c5e\u6027\u7684\u7c7b\u578b–>
\n\t\t<association column="pid" property="person" javaType="com.ittx.mybatis.demo1.model.Person">
\n\t\t\t<id column="personId" property="id"\/>
\n\t\t\t<result column="personName" property="name"\/>
\n\t\t\t<result column="personAddress" property="address"\/>
\n\t\t\t<result column="personTel" property="tel"\/>
\n\t\t<\/association>
\n\t<\/resultMap><\/p>\n

\t<!– \u6839\u636eid\u67e5\u8be2Order, \u5173\u8054\u5c06Person\u67e5\u8be2\u51fa\u6765 –>
\n\t<select id="selectOrderById" parameterType="string" resultMap="orderBean">
\n\t\tselect p.*, o.* from person p, orders o where p.personId = o.pid and o.orderId = #{id}
\n\t<\/select>
\n<\/mapper>[\/java]<\/p>\n

\u7b2c\u4e8c\u79cd\u6620\u5c04\u65b9\u5f0f\uff1a<\/h4>\n

[java]<mapper namespace="com.ittx.mybatis.demo1.dao.OrderDao">
\n\t<resultMap type="com.ittx.mybatis.demo1.model.Person" id="personBaseBean">
\n\t\t<id column="personId" property="id"\/>
\n\t\t<result column="personName" property="name"\/>
\n\t\t<result column="personAddress" property="address"\/>
\n\t\t<result column="personTel" property="tel"\/>
\n\t<\/resultMap><\/p>\n

\t<resultMap type="com.ittx.mybatis.demo1.model.Order" id="orderBean">
\n\t\t<id column="orderId" property="id"\/>
\n\t\t<result column="orderNumber" property="number"\/>
\n\t\t<result column="orderPrice" property="price"\/>
\n\t\t<!– \u591a\u5bf9\u4e00\u7684\u5173\u7cfb –>
\n\t\t<!–column:\u6307\u5916\u952e\u503c\uff0c property: \u6307\u7684\u662f\u5c5e\u6027\u7684\u503c, resultMap\uff1a\u6307\u7684\u662f\u5c5e\u6027\u7684\u6620\u5c04, –>
\n\t\t<association column="pid" property="person" resultMap="com.ittx.mybatis.demo1.dao.OrderDao.personBaseBean"\/>
\n\t<\/resultMap><\/p>\n

\t<!– \u6839\u636eid\u67e5\u8be2Order, \u5173\u8054\u5c06Person\u67e5\u8be2\u51fa\u6765 –>
\n\t<select id="selectOrderById" parameterType="string" resultMap="orderBean">
\n\t\tselect p.*, o.* from person p, orders o where p.personId = o.pid and o.orderId = #{id}
\n\t<\/select>
\n<\/mapper>[\/java]<\/p>\n

\u7b2c\u4e09\u79cd\u6620\u5c04\u65b9\u5f0f:<\/h4>\n

[java]<mapper namespace="com.ittx.mybatis.demo1.dao.OrderDao">
\n<resultMap type="com.ittx.mybatis.demo1.model.Order" id="orderBean">
\n\t\t<id column="orderId" property="id"\/>
\n\t\t<result column="orderNumber" property="number"\/>
\n\t\t<result column="orderPrice" property="price"\/>
\n\t\t<!– \u591a\u5bf9\u4e00\u7684\u5173\u7cfb –>
\n\t\t<!–column:\u6307\u5916\u952e\u503c\uff0c property: \u6307\u7684\u662f\u5c5e\u6027\u7684\u503c, select:\u4f7f\u7528\u53e6\u4e00\u4e2a\u67e5\u8be2\u5c01\u88c5\u7684\u7ed3\u679c –>
\n\t\t<association column="orderId" property="person" select="selectPersonByOrderId"\/>
\n\t<\/resultMap><\/p>\n

\t<select id="selectOrderById" parameterType="string" resultMap="orderBean">
\n\t\tselect * from orders where orderId = #{id}
\n\t<\/select><\/p>\n

\t<select id="selectPersonByOrderId" parameterType="string" resultMap="com.ittx.mybatis.demo1.dao.OrderDao.personBaseBean">
\n\t\tselect * from person where personId in (select pid from orders where orderId = #{id})
\n\t<\/select>
\n<\/mapper>[\/java]<\/p>\n

\u63a5\u7740\u770b\u4e00\u5bf9\u591a\u5173\u8054\u5b9e\u73b0<\/h2>\n

\u8868\u7ed3\u6784\u4e0d\u53d8
\n\u7c7b\u7ed3\u6784\u5982\u4e0b:<\/h3>\n

\"\u4e00\u5bf9\u591a\"<\/a><\/p>\n

\u6620\u5c04\u6587\u4ef6:PersonMapper.xml<\/h3>\n

\u7b2c\u4e00\u79cd\u65b9\u5f0f<\/h4>\n

[java]<resultMap type="com.ittx.mybatis.demo1.model.Person" id="personBean">
\n\t\t<id column="personId" property="id"\/>
\n\t\t<result column="personName" property="name"\/>
\n\t\t<result column="personAddress" property="address"\/>
\n\t\t<result column="personTel" property="tel"\/><\/p>\n

\t\t<!– \u4e00\u5bf9\u591a\u7684\u5173\u7cfb –>
\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 –>
\n\t\t<collection property="orders" ofType="com.ittx.mybatis.demo1.model.Order">
\n\t\t\t<id column="orderId" property="id"\/>
\n\t\t\t<result column="orderNumber" property="number"\/>
\n\t\t\t<result column="orderPrice" property="price"\/>
\n\t\t<\/collection>
\n\t<\/resultMap><\/p>\n

\t<!– \u6839\u636eid\u67e5\u8be2Person, \u5173\u8054\u5c06Orders\u67e5\u8be2\u51fa\u6765 –>
\n\t<select id="selectPersonById" parameterType="string" resultMap="personBean">
\n\t\tselect p.*, o.* from person p, orders o where p.personId = o.pid and p.personId = #{id}
\n\t<\/select>[\/java]<\/p>\n

\u7b2c\u4e8c\u79cd\u65b9\u5f0f<\/h4>\n

[java]<resultMap type="com.ittx.mybatis.demo1.model.Order" id="orderBaseBean">
\n\t\t<id column="orderId" property="id"\/>
\n\t\t<result column="orderNumber" property="number"\/>
\n\t\t<result column="orderPrice" property="price"\/>
\n\t<\/resultMap>
\n\t<resultMap type="com.ittx.mybatis.demo1.model.Person" id="personBean">
\n\t\t<id column="personId" property="id"\/>
\n\t\t<result column="personName" property="name"\/>
\n\t\t<result column="personAddress" property="address"\/>
\n\t\t<result column="personTel" property="tel"\/><\/p>\n

\t\t<!– \u4e00\u5bf9\u591a\u7684\u5173\u7cfb –>
\n\t\t<collection property="orders" resultMap="com.ittx.mybatis.demo1.dao.OrderDao.orderBaseBean"\/>
\n\t<\/resultMap><\/p>\n

\t<!– \u6839\u636eid\u67e5\u8be2Person, \u5173\u8054\u5c06Orders\u67e5\u8be2\u51fa\u6765 –>
\n\t<select id="selectPersonById" parameterType="string" resultMap="personBean">
\n\t\tselect p.*, o.* from person p, orders o where p.personId = o.pid and p.personId = #{id}
\n\t<\/select>[\/java]<\/p>\n","protected":false},"excerpt":{"rendered":"

Mybatis\u591a\u8868\u5173\u8054\u53ef\u5206\u6210\u56db\u79cd\u60c5\u51b5:\u4e00\u5bf9\u4e00, \u4e00\u5bf9\u591a, \u591a\u5bf9\u4e00, \u591a\u5bf9\u591a.\u5b9e\u73b0\u6620\u5c04\u7684\u5173\u952e\u662fresultMap […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[92],"tags":[],"_links":{"self":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1982"}],"collection":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1982"}],"version-history":[{"count":8,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1982\/revisions"}],"predecessor-version":[{"id":2412,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1982\/revisions\/2412"}],"wp:attachment":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}