1.需求

查询所有订单信息，关联查询下单用户信息。

注意：

　　因为一个订单信息只会是一个人下的订单，所以从查询订单信息出发关联查询用户信息为一对一查询。如果从用户信息出发查询用户下的订单信息则为一对多查询，因为一个用户可以下多个订单。

2.  方法一：resultType

使用resultType，定义订单信息po类，此po类中包括了订单信息和用户信息：

2.1     sql语句

确定查询的主表：订单表

确定查询的关联表：用户表

关联查询使用内链接？还是外链接？

由于orders表中有一个外键（user_id），通过外键关联查询用户表只能查询出一条记录，可以使用内链接。

SELECT

  orders.*,

  USER.username,

  USER.sex,

  USER.address

FROM

  orders,

  USER

WHERE orders.user_id = user.id

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

2.2     创建pojo

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

将上边sql查询的结果映射到pojo中，pojo中必须包括所有查询列名。

原始的Orders.java不能映射全部字段，需要新创建的pojo。

创建一个pojo继承包括查询字段较多的po类。

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAa4AAADSCAIAAACdALPDAAAW0UlEQVR4nO2dO2/jTHSG+bvY+PsTrt0Y+gVfa+hr3GsLAe4DuFGxQBwo7SowkMCAgQTJulERK8AawRrZZrG5bDMpeJvrmSF1G9LPA8OQOBcekoevzsxIh8WPn7+VUv/2z/+kAAA+KgVSCACAFAIAIIUAAEghAIBCCgEAVIIUvt0vr643bz2LAAAOxfPt/Opi+bA75j5iUvhydzG/e4wVXcyvVPPC+tNbWG+F7fqWUKuU0mjN6MbE/uVDSNk+gJSu9jzAlCuYeJX3Z9hJHuw/KbtzHT7dyMSe05uEKqTcj/vcZcd3gIFS2MuSiBQ+roJxn1XkPa2JbjFACt1dWE3cay/7sWBP9Tbq9In7co/Fa498dyUelNCV8Om15+XrZVLouEIM+HAd4D/pdWTzElspn49Fmwg9hzw/xc+FDlNuFrmf0zDgwqmIFL4/XM9v7t997YSiZt/pZyRRCkMKFSpSPg8b4CJRg9Nv9ZAAud0KN3Pi7oTzIx+pcNL2l9SoSPWilxT2Oj9WD9GTKTh8+sUKvY12JZxw5TsDVpN022RX9HZ+FlKc30KSwt3m5mL17G0WKkqRA7maa71bFPUGb2/engWH8B64ZZL7Vr7VZXVI7GfY/R8yJnT23N6ELdGjTpGDAQgH5dbZ33+8N3xoLyEL3fru2Ui5xCl9KudURA0T9ij4sxLPfDWCfFy1R2rMue02N91J0EbBWn27KNQq5eKGEKTw+XZ+dfvibWUXhXxIBS6PRa+7zrs9JBZunagGpdjs1pdPvXxV5GquAfJ9ItxU+mXyHrtworw2JJon2OM9EC+hfXmPd3//8Z4ibyfei2X997qE15hed2+IlFYp5817iqLe5ZbWolYHT2/3y/Z1VdQq49v90j8n+LhyVVJqJVzcEGEpTFswcfedeBvLt4flVcLdFepQ8MtQNa897lu5gnyry4ef2I8she3rwRcipCYp9nt35zVm2H2eeGn29B/5uKJnJsU9+rqcVRq9uNbhW9US1a2X2cIpfVxdGYPIVkDeH66teCsw82ZIYaxVysV1CUlh7+/QhE5uX7cQ7kNhS6jDqBTKxicakHirWw4qmC28Ttxdis3e3pR2NoSeezmZYIZ7XL2aC1IYrSN3nqJfyjlX0d0JPhbVoxC9rrW+O+9Fdw2WW6U4iU8Kb+7fvcLnH4w6UhhslXJxvQSksP+CiffUeOXAfd1XCkMdensOmeQ10uvN6feSUOSqTLq1UXvc7emdhE6+rAvuOXR3Gj0o9zxE/TXx0uzvP16ZSDmNXpNCnmZ1G71q6fan2Ba972QfCG10eztxVOg1KYpfCm3TE4oGnH3vxqgrp9xa0Uslm+21WbjqA+wZ4FjygXiPS9gi7DRFTRKvo1vqPcNyt6FOonvx1km5Xm6fXuO9+uXdY6hDwex9jPeqmGyGcF1Chy+8traYovF8O++GlZ5ZP5+8xOcKV89q0MVt8UphjwUT67C9XuJW099GL1svv7e6la90qGevkUKFxCJrjyEj01/LO5L9QPdv752c6OVWV6Em7jFGb3vhuKKG7ek/1r5S/CTl2L17ly1JdCdrY7qkpu/L23MPKdR8zBIQo1SIwMyFkWgr+eK6eKRwt7kJfbFbKEr042hN6/5UAUd0bwnB+6M3RlQKvUYK9kdLe5k0QAqjpAhESEatOvpGr74Lx9L3cBIvzf7+c0Cf6SWF7p+3bXrPeucpBoQ6FGRXdhIljjIT6dWDfDVDuFI45EfHwoV0PTJUU5ke7B6b9/Zzq3ltE7a4962sdNEKoSK5VHa1lM6tJsK1kNu6+0p0rL73/2BO6T/e3SU2lA22vE71+dCVr6bbc+itUCfFZxKd5HF1pf76o2uW9vq21b6//ugmB8W2Ay5uC5lpAODI/PXHxeq5Vq4+/y/mV+3/1FZDQQoB4Jj0jwcP87onSCEAAFIIAIAUAgAopBAAQCGFI2U9K4rZ+txWwMg4jdtsF2VRFEVRLrbH3tUhOZQUftuUl/Piz43v4N8Xf86Ly/qv/Oz5ZfP6U7DocMTNOBnrWdEyyDWP79ONPw+30WQE4v20Ki7ns6dj9Vx88v+AK50RuE21j5GJYEUWUlhX+BhSuF2Umj+uZ4Pc+sg+bVu1nu29s/ylsPo8zlUKx+A2SlV2jlIJTyKFNdvPy7OHY2c3w/ToZktv3zmqTx/lcx0p3EcKx+A2FVOSwkrUPr1UnlHoAmfpnX6Bm6L156XdqsGnQbFIrdpF/bdcfEs7KLFV1AzHa19metHlap1U5MfjjJryrGdFudhqAyGjqj4+sspCQyexQ2MMbEYcIWe2zLfeejs0N9bo/RsV2oLtoixmi6qoXGzrI0i6j/1O1fhzc41qJ1kuvjlX/9LSxICXCneK08p0qim6jVY6LSm89F3FqBR6WzX0lcJtq6p9pDDaKkkKuwqW1+qOKxQFrfM4irat9r36nR4KWGGBfmuYRZ6BlLfDYITgBiAakhTKIUeg1BzpbRdlY2x1w5WLbfsiLaYRLmXjG39utrW7VtdLlsJwhz6fD7tNeztM0218uxgXYSmsXUF3mgQp9LRqEEamvqLaY3oOWOKt4gNkYzjTOK5ndCMUBXce92mtuCuxHUx773Sp1w12GJ5u2ksKw3eB9xYRxn3Gi6pOyl1WXTvLRbVgrYvgHCfxD5CFDhufr31Jc5tOc/VWcY8KMQK3afRznDKoVFgKO++pPhWXi29JA2RPq4Z+Upgw+ehh8JSlMaY2PdX68Nc7F4oCO/fojOaDyZGa1cYh7TNcG+p0jj9YCkMdCpZ4bvGm3jApdMYE7nWplcj1Q68USh2Gbwe7K2uucIpuI1g6EqJSWGuEGxWaH25Cq4YhUtg3Kkxo5dmX5anBSe4DRIiuq+ifwEEXFD7eRbdNHK5oA1PrjdxfsHu3j/NEhTbGaHdIVKgTk8LGx5qdTttttG1TnisUJkeEucL4vIm3w8a39LGM13e9hFuFzXBDQnc4k3ZcCQvT5gjDHIqEXVCr13wo+yd93GYpn9GmAztDnfbLNPq+xJUM544IWOmZK6zeDZRC8aJoYldVM0YtlucIbmPcDt5B0kCPEhiB24Q2jYQEKTQEqLvGy8VTvYIWazVQCpUzPEmMEAOthJls/TYwj8tppXmtUCQT/Kqs5IJdo3otIbh0m7SUYTVxvNcYQFmBYLtVNyPWoVFBL/XvaagUKneho/z87gnNuhXktqFxQUMryElSaDjhcvHtZZbkUTJjcJsJSmHfSToAAKQQAEAd6Qv6pwApBIBD8sHTMQAAjBikEAAAKQQAQAoBABRSCACgkEIAAIUUAgAopBAAQCGFAAAKKQQAUEghAIBCCgEAFFIIAKCQQgAAhRQCACikEABAIYUAAAopBABQSCEAgEIKAQAUUggAoJBCAACFFAIAKKQQAEBlJoVv98ur681bzyIAgH3JSQpf7i7md499ii7mV9afVXpYA0MdumZ4TTq2eQAwmIyk8HEVjPv0IldBBIWS95iiXyl9JtZHCgGyJRspfH+4nt/cvycVJWqKW81SupBOCQ29itk3KqxeIIUA+ZCLFO42Nxer515FgvSENrYNrRfCa/etuz1aX7fKNc/bOQCckkyk8Pl2fnX70rdIqbAeuUVeKUwZICdKoRw2CvYAwNnJQwr7LJikh28pUjig2wH96xUE7QaAc5GDFPb+Do2gKSlzc8eYKwxV8xrg3QsAnJEMpLDPgomXfaK2Aw6Qe9VnrhAgK84vhY+rq9CCiVBkBXFy2HWkAbJlQFRViQoBsuXsUjhkwUSYgxNkbpgUpgiWV/JcdUYKAbLlzFK429xcLB92fYoGLEq4c3mhOvLrEHpYau0FKQQYBeeVwgP86Ng73WbNyrkbVUCJBK0UDJB7c2vKU5MAcHrOPkAGADg/SCEAAFIIAIAUAgAopBAAQCGFAAAqMyn0foHm+TaUqQEA4EAUP37+/p//+52FFJpJaHabm+vNm1LPt8uHnVKPq+aXJ+8P19avUMyfKu82N/pX9rqaL3fWt/la2X1c+bcDwAeh+PHz93/853/lIIVOQv/n2/nVxfLudnV3u7zqVFKUwsfVVd8HpCjrx87vD9eoIcAHo/jx8/ffP/7r+aUwlITG3S5J4fOtoGKJUqje7pfBNBAAMEmKHz9//83f/ePZpdCXtf/tfqlFhe3vkSUpfLtf7h0VvtxdiHmz/a2ct+Y43dyvPlTXj/rl7mL5sKvCYXN0X4XM2kA+3KFxou7uKzOWD7u6jtYwZAbAx6P48fP33/7Dv5xbCj1JaIbOFbY64sSYzlyhLjRB2QojSWFYdnebG63IjEBrC2vL9Zq1hXVNM/h9f7juzHi+bau9P1xXIti+0M6zZAbAx6P48fP3v7+de65QSOjvriDHlk2UUk14aApiSlQoWRJu5b4NhpbOKrm+x5c7w2BrDjQcgfqtapt3Z6yVQtEMgI9H8ePn75///b+5JvT3kSSFXc/dgDFtgCw8jllo5b6tgzJ7Sbob/Hri0NTZTN/kpt5hXApFMwA+Hhl8rzAta7+GM5pOHI32mCtMEoXUSM1YkhYf4DdECk25T40KI88RBPhonF8KhbGe1KS7+YV5Lm3iTPVbQbYCw2qqztoYnsuzMDo0J+lMBkuhNdsYl0LRjPAhA0yVs0vhwPDEWOiwFg1CX5aWv2JtreSaVgWUTtvd6llfBLe+5u3TUJ/9wwbI2kj8Yvnw2JohSqFkhn66AjnGASZGvgn94dxUX3Hn6sCHINuE/nBmqpiR+UT4IJx9gAwZUg38e61lAYwbpBAAACkEAEAKAQAUUggAoJBCAACFFAIAqFFKIQn9AeDQTE0KSegPAAOYmBSS0B8AhjAxKTxpQn81IGt/l1C6QjQYAE7FxKRQnTKh/8Cs/VroGs2UBQCnYXpSWHGKhP4Ds/a3h7C643e+AJkwVSmsOG5C/9aYfln7O2PI+wKQCyOUwmwS+hukZ+1XjXa/OJoOAGdijFKYS0J/k+Ss/bpovnjGyGTSBzg9o5RClUdC/yFZ+/Vnj2g9O0Eu6aMBTspYpXDSkEkf4NQghdlBJn2A04MUZgWZ9AHOA1IIAIAUAgAghQAACikEAFBIIQCAQgpPg/0V7rSic/N8G/kBoudnOQAjZYRSOMKE/uOSwt3m5nrzptTz7fJhp9TjKvAlx2E/1gbIkqlJYZ4J/cclhc3PXe5uV3e34cyy/VL4AOTNxKQw04T+Y5NCpZSQ+iyhFGBsTEwKT53Q3xh0W78atsbjTroHT9HL3cXyYacllfCkaXB7E58rID1yIEiV57GJCn2/ht5tbjJVcIBBTEwK1UkT+r8/XFtJcZq3VpIuXWqFosbC2nK9pvSEAGHObtB0XsJcYSwhI8DYmJ4UVpwkoX+oE0cp0oqc9IVmtBt8QoAQxu6VKzu8gsyCCUyOqUphxbET+reCa45bHQu7/oUiycLYEwL8zxWIFQ2E79DABBmhFOaS0N/U2YNFhUEpTAruhOXvQ62Ms2ACU2SMUphJQn93ws4ILRsLm8gxoSj5aaICQsh2mGgu3yVvgD0YpRSqPBL662PPi+XDo7Go2llyvXnbJRaJAan/CQHicwXkRw4MggUTmCZjlUI4C7vNDU8agEmCFEI6LJjAZEEKAQCQQgAApBAAQCGFAAAKKQQAUEghAIBCCgEAFFIIAKCQQgAAhRQCACikEABAIYUAAAopBABQSCEAgEIKAQAUUggAoJBCAACFFAIAKKQQAEAhhQAACikEAFBIIQCAQgoBABRSCACgkEIAAIUUjoz1rCiKcrE9tx0AU2PMUrj+NC8u5+Xn98N097QqLuezp8N0ptR2URYas7VWtp5ZG1JBCgGOw4il8H3x5yGlsBLWA0nhemarn1M8SAoB4DiMWAoPzCGlcD2TYzekECAzziuF3zbl5bz49FLJUHE5L/7cNAJSBX2rdRP9FZfLxTe9qP7TosJ6uyZn+hajVXE5Lz69uL21f24nzu7CVINjj9hZo+aKTjTXs6JcbKuY0hpWd9vsfqtGoXJ3j1ENXs++FLPvobfbxVNRfGn+vhqdrb92RVoTtf5alK9b9X3WlLY2rGdfysWv9Syhw/K1Pk3b17L4uqjMKF+3dR2tYcgM7YQwyQAWOUjhpaBQq9knragWyrA2Pa20Hpr+fa20trIUhlrFaKXJd9OFosK6Ud1kuyh9uufb1CmcEZAaPUQG7XqHYSlcf7XVqmG7eNKKfi1Kq9WXonhqjqurWYtgXfP7rPhSLn41Pb6WnRnfZ2217WtZiWD7Qn2fNfIqmdGdE6QQbPKQwlp36rertVLKDgZfZkZgqJRS289LR5jaWFIpecxriWaoclWtjVWtt1HamMy89SQp1GpuF6V9zwakUNukvzWLPN15iUnhF5/pvxalpmLKFM3111YHlaq0rH4rR6B+q9rm29eyNqaVQtEMgDA5SKE9KK70Lr4q4pNCfePLzJKtSsg8EahSASmserP/0qWw7mVRmmIoSaEct/WTwsNHhaoJyoovhR7BaYNfz/A5rEfivn4tSrPDuBSKZgCEyUoKa6nSo0IjDLTwSmGngE8ro9QKA4dFhQOxh7onlcIes4RND2mR2va17NSwG6L6ehwghb8WpTY/mBoVimYAhMlBCv0zcWEp9M4wamq1/bwsLpelNlJWyhcS+qTQmSusBub95wp1nHjMNwvYVDygFG4X5ZCF6vBcnoUxGjUn6Syrh0qhNdsYl0LRjNrOssfHAnwYMpNCZ912iBS2FSzN0sRuuXiqF6+1ckP1QivISVKoLecGlk70eM1YQQ7co3aPhTnwDUWcbrMkCdCGmbPv28VTK0nm8rE5K+eUpiy2SBGoNhIvytd1a4YohZIZTTFaCC45SOG+w08I4ChrKBr9WAS/6gQfGaRwujjC5yzffEj48SL4QAonjT1A/uChEGNjCMIP7wAAkEIAAKQQAEAhhQAACikEAFBI4cjgiyAAx2HMUkhCfwA4ECOWQhL6A8ChGLEUHhgS+gN8YHL4tQkJ/fNK6K8GZO3vEkpXVKkGv7qWMLqHPMlBCknobzU6c0L/gVn7tXT83kxZSCHkTB5SSEL/bvv5E/oPzNqvmqxZMzN9P8AYyEEKSegf2y7WOHhCf6UGZe2v9xKSUYCsyUoKSeifRUJ/0/TkrP2qSaq6bjOqAoyGHKSQhP56xfMn9DdJztqvi+baM0YmQxbkTGZSSEL/DBL6D8narz97pN7zF3ukjBZCxuQghaRuPRK5JfQnkz7kC1I4XXJL6M+vBiFjkMJJk0tCf8bGkDv88A4AACkEAEAKAQAUUggAoJBCAACFFI6MzL6Psp4ZX6tOLALIkDFLIQn9zw1SCJNhxFJIQv+zgxTCZBixFB4YEvr3BymEyZDDr01I6J9dQn8ja3+Xpt8pMlMwBIvWX4vydaulOzSnC3xPCKiNDz5XQHrkABmzoT85SCEJ/a1G507ov30tzTT9rUJZSbr00E8oasTuqTmurqb0hIDwcwWkou7AkULoQR5SSEL/bnsGCf1to1p5slO3phU56QurDK9bFXlCgJAQm1zZcGhykEIS+se2izWOkNC/el6dM9Td2umpO70TipQQxMWeEOB/rkCsCKA/WUkhCf1zSOj/a1Ea84MHigqDUpg6Zg9JnlAEkEwOUkhCf73i2RP6uxN23dv1rFXJJnJMKEp+mmjEqoDeeYpICgZ9yUwKSeifQUJ/fexZlK/rxZP1sON2WLpNLBJXOfxPCBCfKyA/cqCqgRZCL3KQQlK3HoncEvqfEh4eAP1ACqdLbgn9T0lmv1CE/EEKJ00uCf1PCWNjGML/A25CruOVMb13AAAAAElFTkSuQmCC" alt="" />

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

2.3 mapper.xml

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqoAAAD6CAIAAADm9vLjAAAbVUlEQVR4nO3dTYvbWL7Hcb2erJtaaFPvIG8gNKGg8TqbLAebgYZa1XXBNOlF7RqKplIhiyGGMISQ0KSboXuyycPCm8ymKSowi9xZ3UV0F7Kl8/A/fx3JsiX7fD8culPWg49l2T+dc2Qp+8///h+FQqFQKJSkSjZ4DSgUCoVCoey4ZAUAAEgM8Q8AQHJaxv8f74/vv/z+j+3UBQAA7ETL+P/z03e7jf/j+y/1B8UZGifps3V7RJwUmm2T19XWhlXtvT4AgMGF4//PT9/df/+L8OB24//4/ku9VLMp85tra5ynaB/Y/uLOms3/9v66GleiV155XDzKaftcrf356bv7/7z8s7f1AQAaBeL/j/fH919+9/f/uo/vsPUfylF/npgHQ1P7ije9nqE5u72u0IFI25emHBuJz9VYw85++fHlMYNKALBDQvz/++//DH4X7yr+xdawOE+o5d24Zv9P5d+NhwhOqIcOI3p5XfHxX0gao92Zeeut/6Io1nudcMQJANgCN/5/+fHlsdITu/1+WjFWnUmh5qmYwf76/aeLjzflcaXmPb6u+DrrL8F5Lv2wJrSSnv356bv7L49/vO1/zQAAmxn//738y8tjf7zfcvu9EP+335vh8ZdP/46apInPNiUmCymlOrT+lcVbPXXR0+sacet/8z3h9vs2+wkAoJuWrX85/vsXH9t+JrWNfz3elBniZ+v3dcXHf2OdQ3MqFdYf3witfwDYlZZj/7uys9Z/5KTGeXbc+o9pkQ/R+t9A6GxTAMAWtDzzf1eX/WnVSnYejD8giGzZK2vzJ5nzxBx8dIv/0MvRnyv01JHRvpUWf1EUnPkPADvX8nf/O4z/xqatmbjmPH7AOwsqT6pXKTSnX0kl/jd/XTHxH9myD70c59/+nH0eCvC7fwDYuX295r+SQ3oKdov/yPXonQ0xYl7XNuI/dEQiHscovSAAgL0wuvhv2yHvL9u4ZmWGVutU2u7+avt6XUol2zbNG1v/fj9KqJcFALBfRhf/AABg24h/AACSQ/wDAJAc4h8AgOQQ/wAAJIf4BwAgOcQ/AADJIf4BAEgO8Q8AQHKIfwAAkkP8AwCQHOIfAIDkEP8AACSH+AcAIDnEPwAAySH+AQBIDvEPAEByiH8AAJJD/AMAkBziHwCA5BD/AAAkJ7v58rWxvBu9mFdBoVAoFAqlLMQ/hUKhUCjJFeKfQqFQKJTkCvFPoVAoFEpyZcvx//zieDoty8Pn/aW9J+rVXj+eZtPz01tlnl9PptOT95Hb7ulJcScrzt9+vbku7mTFg2t3ht9PizvZqtw9dR83H2lVysWf9rcT9L7CAUvjmzJkuX48zaZl+WlUFRvr5t3wk7Jn5XorH8OD34aH9PXVrXT+VO6m9f/8YY/x//zieHpxaT8W9Wr7jv/zo+LOUfH7ev87f2tNVXbKDT+QT0+KOyfm66oPMqzHO6+w1/LA2R2vhW3VY9HflHGU9z+J8X/9eJo9/tV58O2r8/URg1F+eDbQ69rx5g1+Ut4Wd3d2bLer5+r+MVRrOPb4H/fXV1nOj+pK9rAn9L1Hdf5UhuP/06tvZteXX77eHEz8R5S28V9+qJ6erLa+OLX3Yq65Pu778vXmy9cHnT7n26tquaObu+Pvp8K22sbGEd+UcZQ28V9vyVfnw6X+6DbvdhrKwz5X94/hLrdGr2XsX19fVt9g5uHF+cnGu33f75f8qfz06pvZo79+0hYMxP+/rrPZ7Jt/rBrKmyf2QcZ/1a4V9j8v9nosdXvaa0l3C1e3gd5j8Xb0bR+qa2/KWMoex/9INu+2DyIHea7OH8Ndbo0+y/i/vroekeil9/cr9Km8/HmWzWbf/iu4oBD/v/3jkbNMGbEvrs6qgXw3gI0x/uMLP+cD8a8t9ebsrHqu6b2rN14FrElN+5k65mpMnWYt4j/0TtzxSvWWVJ1I7v66jskH0rkC/mrLz8z5kRul5ohDuU+Y5x88bVphWcpDcr8aLVZ4YqzK3tGdHVRcapNqtC7Xj6dHrz5+ef+TuIeY+4a9Y3w8/cHYberYdo4gpQNKN/7tVa2KO0rlx//bV+dCbVfz/HoyPT+9/fVEqKH+ujbYktYe9TRuxw6V0CfF7IaV+2PFakjLmkuJ+2HzcwVq/uB6tWz1j/JV+wOCdXStGwzVkzobSqy8XsPgt03TR08ub4u7WfH0S1QNY/J4/F9fWk47DTyvvddtjxK3obJHNZYyzauWvFPc+L/8eZZ5PQahNrdxWFBNenN25me5EP/qUs8fyocR1UFDt9a/0Or6ePpD4Lv72beZ5+h/fot6Inm/eXpSx7bz5lU7ZTmDtfjb4q75ZlftaamDoV6wXMr4gNWHsaEVVnvtiTVp9RTKCsPHyO4rtQe9lCPrbtXoUlZBuEpNc3+w943bZ0dGUoZb6h3iv3GdN1/k1v+vJ9Pp0auP0nOtgn/1p1X58Ovqvs+X37n+cZi2Y6trC31S9Dc9VI3GfV7ZhdruYNXXdFmZu6dfn56s1+C0d6/tLZMVd4/WU80aqpUP1VDfhl0+Ndd2LPmfyvUKo0ag9+HrS9tKzruw+R4V3obaHhVTPr36ZjbLfv7gTzLj//avf5tl6/F+s1QtdakD/83Z2aoJHo5nP/61pV5cnR2fXb2Qw7/f+HcfadX5rxT/wNZ5+52jY2cMzPyWdFZVT5IGkOqZvSGrap8LrtDrmbc+xuEV3jifOuWVKp9VZ2t0qkaXYrSYb76YKXv77MhugpvxfP04dPb+LuPfqrw9g/u89crV19VxGwb7YJQdO6bI/bqhkbVwNZR9/ia8H2rPpda5XFv1j7L15r8icz93NpT5vHrlG2sobkPtJQdK+TGsV2XX0O+tbOgAGP/XV+MJlca74Dx1hz1K2Yb6HhVXPnw7m2V/e/Wb/Xh06//du3dvru7ZXe5VtHt98o3xry11eRFu+vcb/173aV/xr+390tvv7NP1ruDtgtUk4ZvUnDl0gn14hTfSyIVzeBv8lik/XU5HXOPYnrjUJtXoUILhVw8HiJ385jn5ZpruNP6NLP94+oP2vPWBQtPral+U8zmCO3ZMaRnzwWqo+3w1g78fKs/VXGej8g+M1TofbeFx53kbK6/XMLQNlZesvMvmh7f6JPpPEXHMtAdfX2r8+4OYG+1RyjZs2qOaS1zrf1VCY/+1N1f36iOAmNP65PgPLXV5MR1B63+Dzn917xd/EOgcLvgjguay5ifEPavOPBAWm1nKCtVqR57pbR1xezUMffv7x+kbVqNFUeM/6tf5b1+dG0cAu41/89wFa2q49a+8ro77vBLqwR07ooR+OhvqQghWQ9nnpWfc5GQ0q3NO6qX7/VRuwDlbpj6Uaaq8XsPG38TH/1TM2bz1J1H9IgqW8X99qfFvvl897FHhrdG4RzUU+yx+p3Q789/qurdH8SPjX13KOryQpzpri9oQ0hefMXp6++yopzOh1LfHHN96ILUDrD+9I2Jnd3d+AVg9qf5VKK9Q7UiPbLdZXzf25yc4Lut9SW1ejTZvVjB0nfNCwsXqTjeXsgfgqxIIYP9UPneqeOb/7bOj6U8nj51nseP//U+ZXMNeij7irpweVTWSgnuF80mR9pbIapT7YbnOUE74a9biU6p8FdvVP6q8X+9vxZ2sOBcffGusRPoGECuvB3xoG2qLi2+KlLtiTArHE+EVjvrraz3obh66yW9KuBMldo8Kb8PmPSpcupz5vyr27/6ds+6dbHbPyV933V9eeD38Rq9+aKkq42OeLubMf+P8Z/9s57ov9Pz01ulB7VYajjSrM5PX8zjHg8Kf1fzOF6h5krPXqa5fBkReodFnZfWeKSsMLeI8l1TD0FJdqtG5qG1u95x86+y50Fn6Ru/6yXtzj1L3Q3e1zWf+20sJx7XGE0lnvPb2a5cb55TmuB3b3IHl9PI+KVV5ENhzxGpo+7y+H6rPJVa+atNXeSOO6Yr93vInRf/A6jUUt2HjSxbfFPv3FKH3UXyzgu/y6L++nD3K7fywq/E0boXB9yuwNWL2KLl0/92/XbSG/TjEvIqdlRH/4pxygOXj6Q/m+f9l6essFkrPZctXvdxS2ddLC1DUQvz3XEZ8rVnKIZbAkAHxP8YywvtQxBWaNAdZiP/eStUdRPZTdlCqDvyY3x9Shi1VH/I+Xpr3ZstX1qMMVYh/CoVCoVCSK1kBAAASQ/wDAJAc4h8AgOQQ/wAAJIf4BwAgOUPG/3KemxcXnyzWExYT57rj+XxpLFP/ZVGW8p5t9VxODcTlAAA4OIPF/2JiJb43LTCpIf4DS3nPtpjYcyqrBQDg4AwV/4uJ0sruO/7VJ2taLQAAB2eo+C+73XfT+m9Of+IfAJCUAcf+q7F6L3e9Ufw61duM/ZsD/KFRgebVAgBwcAY/8786+85I335b/8Q/AAC2weO/tJznxgEA8Q8AwDaNJP7tjO557N8+tmi7WgAADs5I4t/+YV7vP/wrTwvgh38AABRFMewP/4KX2mm47E9gWsNlf6zJ7mEC8Q8ASMlIWv8AAGB3iH8AAJJD/AMAkBziHwCA5BD/AAAkh/gHACA5xD8AAMkh/gEASM5+x79yob9dPf+QTw8AQDfEfxfLeZ7Pl0WxmKz+x1EAAGCfEP/dnznLJ5PJZJILFxEGAGDMiP8NcKcAAMB+GjL+rdv3mDG6mGT5fGncpMeKeOfWPuY0c5LzeHiF9l2EIo8mypsIr1v/HAMAAPbKYPFv3+K3TFPn3n2rv5fzvJrT/Hdht/7tSfZf4RV260Bg7B8AsNcGin8nxgu7I30xsRrU9SQ3q42/vY54c97gCt3DkJbIfQDAXhow/p0ecyOuQy1y76DBWcYT18Q3ev/pxQcApGC0rX8xrZXWv5rwkT389hAEAACHakxj/9ZQvZzWRi/+us0uj/37i8X00gc6JdofE3RbCgCA3RjyzH+rvz7QqFcWyufL5Tw3Z7TP4Y86nnAW8QN79Xxth/jJfwDAiO337/5HrLwuEPEPABgj4n8ryk4FfhUAABgn4r939PsDAMaO+AcAIDnEPwAAySH+AQBIDvEPAEByiH8AAJJD/AMAkJxRXvPfuxiffYvfTLxOnzOFH94BABAyxvjX7sGr3w7AvocARwAAAIhGGP/GbX18kfGv3gAIAIDEjTD+1QvmRsa/1oGgrc/50x6DsNdnDjY49yvK50tjslmpfL40lguvsDr8Wc7zbDIvq1Ev7NRYXh8AACEjjP/CyDSvF8Ab+7cTv3USavHfcJ9A5W7FmX1b4tU0O7vtTo7lPHdOcCj/LA9AVjc3zKoDC2NioBoAAISNM/6NmZyDgJjWv3a/4PBS/p/BLgSvruZiztiFc05DuKdBrlW1eL3FqolqNQAACBtz/BuzWv0CzZ3/qw74CA2RbPT+O8cgHjP+Y85OkE5W8Nenxb9aDQAAwob63b8XkpE97S3G/qOCMLZFbh2EqGvvEv/uDxXiWv809gEAHQ122R9v6FsLzZhc9xvTTgeAeCPe8Ni8w1qhNszeOf6dswea4795tJ97DwMARENe9c/qvA5f2ccb3panurHrjdwH0t06E385z6sZnO740IkJbv27df6bq8vni6oaavxr1TBfHPkPALBx0d/DtpgQ/wAAD/F/yNRLKAAA0kX8Hyr6/QEAQcQ/AADJIf4BAEgO8Q8AQHKIfwAAkkP8AwCQHOIfAIDkjPSWP87F7MKXBBRuEixepA8AAFTGGP/BG+0W0ZfUde+hAwAAaiOMf/tmQI42t/zhcncAAIhGGP/qlWpb3PA3Nv3tgQZ7IXNEwbnNjjtSwbEGAGBvjDD+CyN1vV4Ab+zfuU1u4M53YeHjCbuOTo3rLgr6GQAAe2ec8W/M5BwExLT+w/MEFhPn9irkrLZ8CRNtpAIAgHEac/wbs1r9As2d/4tJm0w2ev+dAw2PMDRAwx8AsHeG+t2/F+ORnfAtxv7b57J1pNG0ivJ4ZUHXPwBg/wx22R/7/H5lAN1uYrc589/pAIi4A661lDaobx4oSL9U4G67AIAxG/Kqf1b3evjKPt4AvDzVPTDweuZXi9qB7lxfKHT2gVXJckXGerwHyH8AwKhx0d8t*fwDAWBH/W8GlAAAAY0b8945+fwDA2BH/AAAkh/gHACA5xD8AAMkh/gEASA7xDwBAcoj/WMpFgLtdYhgAgKGM9JY/zuX2wpcEFG4SLF6/b3PEPwDgYIwx/rUb6UVe89++TWAviH8AwMEYYfxLt9CptLnlT7+RTPwDAA7GCONfvWBuixv+RieyOWwg3iVQGIQIT1pMsny+NCYLtwISJjjjHd62CS0GAEB7I4z/wghJrxfAG/u3E799Ri7nuXNmwfpPp47m4YUyaV2PVc3NOe2l7L/oWwAA7NA449+YyTkIiGn9b5CXxqLSDYSbJ3ljF3avhnfz4vViSndFq54MAAAijDn+jVmtfoHmzv9VB3x8VfyOA6+G9fqVSVoNvY4Lp5fCqIhbeWUSAADtDfW7fy8kw7lupW2Lsf+YBrP7C4GeWv/B+I9qxCs/W9jCLxoAAAka7LI/dh+5cqK+3ffd5sx/8TQ++0F/AN4+0jBH8OMmxR7HaII9IeokAABiDXnVP6s3PHxlH2+8XJ4qNcmlU/Wd/DX7/vP5Yp6LNcnny2XkJLWR7440WOcSyi9ZmQQAQDdc9BcAgOQQ/wAAJIf4BwAgOcQ/AADJIf4BAEgO8Q8AQHKIfwAAkkP8AwCQHOIfAIDkDBf/+vX7lOvcmZOdy/A5VxHmPnkAAEiGjf+Iq/fbN7kRrtFv3IWvntH5EwAAGEYf/2biK7cJXs7zbDKf52XgL+f5ZNHmrr8AAKRk9PFv3rlHWGR9773yrjvLeT5ZrNK/IP4BAJCNNf6l4X3pZrfrx1Y33VvO8+oggPgHAEA2nlP/6qiuDwz8YYBQ/K+zfjnP8zyfLLyFAQDA2lhb/+spZhPeH/qv563mW3UDqE8AAEDaxh7/1h9+/q+H/qWe/vpAAAAAmEYf/3aXv3kioBH+6rgAAACwjT/+pcz3Tgsk/gEAiMdFfwEASA7xDwBAcoh/AACSQ/wDAJAc4h8AgOQQ/wAAJIf4BwAgOcQ/AADJ2e/457L+AAB0QPwDAJAc4h8AgOQQ/wAAJGfI+F/O8/ruPebNeVZ3761v7uPd5DcTbvtTBG4H1LRCqxocTQAAEjBY/Nu38VvO88y5rW/193KeV3Oa/y7s1r89yf4rvEI6EAAACRoo/p0YL+zb8y4mVm9APUm6FbBxYGDd3tecN7hC9zAEAIAUDBj/VlhbcR1qkXsHDc4ynrgmvtH779QJAICDNNrWv5jWSutfTfjIHn57CAIAgEM1prF/a6heTmujF3/dZpfH/v3FYjr4A50SHBMAAA7LkGf+W/31gUa9slA+Xy7nuTmjfQ5/1PGEs4gQ8+Q/AODg7Pfv/ndiMSH+AQCHhfhvUHYP8NMAAMAhIf4V9PsDAA4T8Q8AQHKIfwAAkkP8AwCQHOIfAIDkEP8AACSH+AcAIDmjvOa/dzE++xa/mXidPmcKP9cDACBkjPGv3YNXvx2AfQ8BjgAAABCNMP6N2/r4IuNfvQEQAACJG2H8q5fZjYx/rQMBAIDUjTD+C2Mc3+sF8Mb+7cQXbyAIAAAs44x/YybnICCm9a/dLxgAAIw6/o1ZrX6B5s7/xYTz/gAACBrqd/9ejIdz3TpUaDH2TwcAAACywS77Y5/fr5yob5/F1+bMfzoAAAAQDXnVP+tkvfCVfawU1y/7Yx4YcPI/AAABXPQXAIDkEP8AACSH+AcAIDnEPwAAySH+AQBIDvEPAEByiH8AAJJD/AMAkBzif7u4+nBRrC7BpF+EMaENxdYAMALDxL99xV/jwclCuP6vObd+1b/21wrcNr7Hi4LAs7E1AIzAMPEvXpF/dZu+5viPuOa/fZvAAb9N+R6PxIYysTUAbNuBxr+zFuJ/9NhQJrYGgG0baOy/+nqrDwTW/+ol/p37/XT9Nl3Oc3nAYHWoUg8qeBUW72ZkT3IeD6/QqkbcC3FesfOntsJONVTrEZ5f2VC9YmsAgGPo+K/HQZfzPJss3C/jteDYv534EV/i0V+t9iGEPZywWuHqb/OIxTl6MZPGnuT3T8gr7HbsogVeeIUda9i6OsIa4l6l90ZmUedxHOjWAIDuBor/ddYvJvl8Xnf6V/G/Uevfn6fDt6lfDXPEwjl3sZ4k3XbYODDwTkg0M15cYcc7FzcFnrjCrjVsXR3hka0GHlsDABwDxn8+Xy4m2WRRVP+tegE27fxfr0ua1q6GgWcIrdCrvLOMJ66Jb/SIRIaM3t0dWOEGNWxXHX1D9Y+tAQCOQeN/PqlGACaLPuO/6fs+soZ6619codKMUysRWUPnFw1hsRvAWmEfNYxduFt7dwud/6Y92xoA0N1Ql/1ZfY/XyZjneY/x7zTeOw+fa0O/4WqYI8LGOrQR4tgaBjolvBA0n8ve1toK+6hh7MLKhurd7reG+KYoC+9yawBAMXT8O6fSTRZFTPzLbT+pARXsd2/Rhe71+0pPJi+Uz5frMxpW3PMaY09A02oeyDOj7pOFWQ19hR1qqBBa6/b5baEN1bddbw3xTRnN1gAALvoLAEB6iH8AAJJD/GMT4unxgVEKAMBoEP8AACRn0/h/N3q9bCYAAA4J8Q8AQHKIfwAAkkP8AwCQnG7x/3n+aJa//lxsEv/PL46n07I8fN5f2nv63V4AAByATvH/4Uk2e1Jek2zjdH7+sMf4f35xPL24tB/rdXMBAHAIwvH/+XW+znjH4smq6V/sS/x/fp3PHs0/b2H7AQCwhwLx/+FJNqsz3mJH6eaJvZvW/+LJLJvNJh+2sQ0BANgzQvwvXz9SknL5+lH2pJ5WRuyLq7NqIN8NYGOM//jCz/lA/GtLvTk7q55reu/qjVcBa5LzuuRjGgAAUuLG/+LJLNP6yT9M7CODUJvbOCyoJr05O/OzXIh/dannD+XDiOqgQR37//w6n83MwxcAABJkxv/n+aNZFhjvXzFO+itVLXWpA//N2dmqCR6OZz/+taVeXJ0dn129kMM/8tS/D5PZLHv0mivSAwCS1ar1X//er7KO7Kt7dpd7Fe1en3xj/GtLXV6Em/4x8U/rHwCAdmP/0vnzbgC/ubpXHwHEnNYnx39oqcuLaffWv3I+IwAAKWlx5v/iidBu9hLY6rq3R/Ej419dyjq8kKc6a6srz5n/AAAURdHmd//uSX+ld95Z9042u+fkr7vuLy+8Hn6jVz+0VJXxMU9Xn/nP7/4BADDEXvVv+fqReLqc1rAfh363FwAAByAy/oWT/kpDh3uzfrcXAAAHgDv+AQCQHOIfAIDkbBr/AABg7xD/AAAkh/gHACA5/w+GOBRj1gBI+gAAAABJRU5ErkJggg==" alt="" />

2.4   mapper.java

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhkAAAA0CAIAAACo1b0dAAAIp0lEQVR4nO1dO47bSBClD+DYd2Eyp1CsjCeY0IauwIEhwD6BAwUCDIOBM6cDG84mUeBojAEm8wGWG5Ai+1NVXf2Rhhq9h4eFl/2r7uqu1x+tt+oBAAAAIA/VSxsAAAAAXDyqp3//gVfFd2/fvHv75sXNAEHwNRFacnWEloAgWJzQkqsjtAQEweKEllwdoSUgCBanrCV/P39cr7//jUwCF01oCQiCxSlqya9PN5tP3yKTbjZr+SOZIZgkZ0v7EmVeTr9imWmqnAotAUGwOCUt+faFPXmYSTebtcwpm5B/qnn4s5znKT76+8Wdms1/Fu9XsBLZeOE7KZlyW9ASEASLk9eSP1/Xm/ef/0QkcUHZz6P5yKUmxGWhWk2p/H5xqhbbNUFoybZIY6AlIAgWJ6slv7+/v/nyU59E7tPJPNyZgKPyRKI8UvjGkCaV7ZdeS+QRUCofziUgCJ6ZnJb8/LBZf/ilSiJjtJPEbZzJgO60mHkuEb4Llhfsl95muQtOW7JGCuMALQFBsDgZLYl/ddcHSiHmPlGhMOFcIhSParpUv3AuAUHwdZPUkpSfAus1wA9wsVoix0ohgz5b2X7ptSRoM5dTMNj5Di0BQbA4KS2Jf3V/OuO5RJkUzHPmc0lQtIKm6vuLcwkIgmcmoSXfvqy5V3chKWr/7nzUq4vyzCHU5ieZeTRKlqYlXHfktrimgx0XKoSWgCBYnL6WRLy6m9Rsus3wbebx1cIpyFkvB185ajtGClqS3y+NlkSdsYQh4prGuQQEwdPR1ZLf39/ffPz6m8oqJGkoXNTIITVNS5T1yMegUv06hZZw8kaKovkRWgKCYHE6WpL46h517+SXlVNjtUS+8+FOFX61pfolGCnnEfrLnUv8E55/ToKWgCBYnPh7gq+O0BIQBIsTWnJ1hJaAIFic+P+9AwAAALmAlgAAAAC5gJYAAAAAuYCWAABQFF1TNZ3zoW4PL2UOcB5cmZZ0TVVdxrTumspZkIAeXVNNsNydNwGKO+UVerlriAE+tPWr6+jF4FxBr4iWPP6oV5vq9gdl7XN7u6lWI+v9s5+ju2OTYnFoa3nQEoY1bbmbwSxpDZ0+yhzaOtNGG4uJi1LgKqslS/ayPwrB1VEApJJMKWRX73fVatPc2x+lkLIUmN73dy3ntoSfRtejJWOG82hJAjTL/dDWRh57FXdNUqA5cWR2reqa7MbKWpzhytMNnVnz0r38ElrCKwlp0FDmbnPBWrKIzdNCLDm5low47LelBEPAi2iJI/uF1vBJp4e45nMqLWnxsO2Lr/GE9ylzF5fv5RfQklBvyHRoST6WYYmjJYML7x4GB1emOx3v3u+q1aa6ezCTuv3WLXUEpSWhI8vQxMht+xjujbBajAOpP+rWdc8x3f5IH2OHPFaFhF+N0D2+Qs7WeGV9Q7wk5ztfIdkvWUoc851/TRsoK8OUcGjrqmmHpLo9jD3wop9e9bw7B6tCfgIMQ8imk05ZvpdDWsLMjXQzFBHNymEt/4mjqBxDSusHorHgrptrMIPDQ7Pyo8pDMwWrCY8/aifDzJ0mMHP9dWetHyToBXGskxhcbooGlp4+6BlGBJYDvypJLXFoCwarJWSpqf1ILTlMslRIS0ZQ/g/fNtKp5D0kZYLxbXTR+G/menfWPn+dQlyukBXKc53rsKQlSQNl3/4c2vpo7DQl57lJVUHItQz5XMKIwNyEJbScUy7Sy6bRvCsTzVAde6wsCi2xeQwRo5Y0d0bqEJfYQPTc3nob3PmdxhGSGC2x4KwbY5p7+4WwxzwnV9wkCqo4N+epVSkuByO3Xktsj+66XqUlRKmpff6Oi0oaveuefENI15Ko4NMLEU4RZYzkOYV61jWmjrd5MWcZWSHfrywtiRwoIaJZfxjycGsi6vUwSUvoLrNOuUgva0olmxGvJcf6hTuuKSyY0cY9jgyxYts+jlXNu9jxYmPXja1Mf9i2j0PYMWvwDi4hyBF8GP/GDcX8KEkjL8ybsCV+sjg34uo2QGqJe5zcto+qOy6i1GRrlJak3pamaUlvnfe8uR5/LhGClXoX6ZTxENqWCv1K1hKuQsESwiPHfEotOc+5hOwy75SL9LLjC9qV6WacQEvIaMP/Wserag5Eh/22Wu26o2zU++fjF6M555QTQjDKUoIdCCfMyFNa4jgtVkuYVXkyLTGE3U6ylVwoNVmfoCXnOpe4NfD7Mjp7SPNNx7O1CTsP0QKlq61++Z1k62OrVw5U5rkk6kDCNin0j/ik2g5egJfJwWQVLnz5FTQjbCR5K5CoJcSlt3Au6e931Wrb7nfjs+7wEkNoRsQZJSzwddtRu4fIH00TaZdzLiGvKYNPKfTlpn8XKb6yHL3b3blJGl3J1xK/Cjk09US8s7cj9uSRtyXmRbRRh2SC1tV2v4Y9kDVjjKsWZ6tMV68dKOJmdg7HkpZ4NipRUEskpyzfy7ZNQvVWqQwzQlaS6c5Kd97eo7QkGL7q2229f56zjRUSMUrzi1Ohu6Y8ExeDdJASRt5uytOjQIxi5jy5KhVaMk5cr72QllgRfP5h1ba9H3/xFSqVqCV97z6/a7XEhvOgRB3cnUK+m80M/FWnv5922pkSpM3H1IpTpdszK4jxEULqlzUkzuSZvppmJA8U3ZKsJYobEwb0whImgLh4JKcs38ucj+VSCWbM6azT2IBnhYgsLendqOIHoua+927J3Bil/E8XvCll/fLCmyfzB3t82V88OlOU9iRR0NpMOGBmryAehM8ZMQm8lwAAAKiRdoUDBLCwwaPfMKElAACUA/XgHL4oBkQsS0uYV0xoCQAAJeHd+PYd/p7gPCxGS7i3kr6/ur8nGAAAADgBoCUAAABALqAlAAAAQC6gJQAAAEAuoCUAAABALqAlAAAAQC6gJQAAAEAuoCUAAABALqAlAAAAQC6gJQAAAEAuoCUAAABALqAlAAAAQC6gJQAAAEAu/gfZTj6bkGSSPgAAAABJRU5ErkJggg==" alt="" />

2.5  测试

Public void testfindOrdersList()throws Exception{

        //获取session

        SqlSession session = sqlSessionFactory.openSession();

        //获限mapper接口实例

        UserMapper userMapper = session.getMapper(UserMapper.class);

        //查询订单信息

        List<OrdersCustom> list = userMapper.findOrdersList();

        System.out.println(list);

        //关闭session

        session.close();

    }

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

总结:

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

定义专门的po类作为输出类型，其中定义了sql查询结果集所有的字段。此方法较为简单，企业中使用普遍。

　　更简单的方法是将返回值置为Map类型（resultType="map"），也就是map的key是查询的列名，更加简单。

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

3. 方法二  resultMap

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

使用resultMap，定义专门的resultMap用于映射一对一查询结果。

3.1  sql语句

SELECT

  orders.*,

  user.username,

  user.address

FROM

  orders,

  user

WHERE orders.user_id = user.id

3.2      使用resultMap映射的思路

使用resultMap将查询结果中的订单信息映射到Orders对象中，在orders类中添加User属性，将关联查询出来的用户信息映射到orders对象中的user属性中。

3.3     需要Orders类中添加user属性

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAASMAAAD4CAIAAAAozBciAAAVMklEQVR4nO2dPY/cthaGVd/fcX+FCnfp02yVXoDT5sJtiiBASm0xlRP/gQGynbCNgU2rwnCzbgQYkyJwYNdb8xb6OjzkoSiN5lCaeR+w8AxFSbPms6S4Gr2ZAQBcniz1CQBwE8A0ADSAafugKrKsqBKeQFPmWZZlWV42Cc9ixyw27Z+/8rufs//95fu5fyv/93N215X84Zu7RXUvVq3H9GmoURXZwCJhEptWFXDsTNKY1m1wG6Y1ZU4sqYpFsqU1rSlziHYmFzGto3k4JB9Mkp+G7Vn/zuxuC9P2TtY7c/+pndFl1B+mU33M7n7O7j/RqurhwFv1+Lr41DjTHqIrh/KfuE8RbDV5GuOH6vhU0Kq7YxVV5cejCJmKVUWWlw2ZXFqb0jknq5Omo8Ed9tdas2exMO18BtPufD1v0jRvq565pjWDtHNMm2wVZdq4AXOJ6hSoEs/O00fJe50R3Ss6/rGxkAprV3kmp94dnjMsJl+PuQKIaUVtjBleHisTZZqnVU9g2uar6vpxt8NYpltNzx7p5xp0sn9rTFWJB582jVSPNbxvk9fOLum24g4XXiG25sKy88ncK6729/2h/Cdq9uhp1TPPtIgLPw+LLxetCaftDxuu6c4DVcLBncs0ywxpsHCasTYOcQMXmT7OmQz6PgSYiWta1wXdMc3+jR5o1bPEtLljWkQrz7GsQcx5ObLC+Ob2UjrsiGIExrSgTJHzvKbM58iG67TzEa7Tun45eQkXe6kTvLrrdR2XZPoSY53cSj4Nd0BzZ49xnytiSdOetdnTO1kMsl0/Evmv09xmMaPPPHdg2vn4TLP699gpD2XdrVIaE2610DTjLG9Ejm9CK/k0LD/tz+W0Ii4FqsKIf7gOiTE2ysumKXO6ob2KyET275A1mSUOTDsfz3UaAAyYdj4wDUSAu7HOBqaBKHCH8ZngXn4ANIBpAGgA0wDQAKYBoAFMA0ADmAYiqJ6z7CkvX0KbFE9Z8VXtjHbHrkxb+ZkI9XH2bZYi7m2/scvhu/hGCkw7mz2ZtvIzEVpvVzKtY8HNFLswLQKYFmZPpq0MTFsVmBZG2bTAkxS6IetYjV+IHr7tJn1Tu3uf2ELfkR5h4PnCtXcnM28jNsZvWvvAATK9pN+qDs455SdquW3tr2f7WoWfpCBRPWfZU1s825PaLOOmtSeJm0pakpjmv7++M62g34LpPJS7PvtqmXVnmfQIg7BpgQcfTCOYRvq1cwehMKYFHmHgPLNAetRB9IMPpvlaOKY1ZZ1lz0RwmBYikWm+ZyKwoaz9isrkl7iHkdCY8ITQ+bqnf+N2M/YN1+ibQiXTSCcNfMcztCPxq6B0y6UPPpjGNY2/g9ljmCSm+Z+JML3g4f0SN3nzU8GsCDzCQDDNef4P/wZdmNVMCz3CQB7TznjwwQSOac0ph2lzSGua9UwEz5NIGMLjEnrB6qNVO/UIg6gxbSarmiZpwS7SAvuO3uUkGNPOZQPXab0bsmlR39Q+5GQaaUz4EQbGOI9FCHxT+/zrtIANwgWTfB3Fvn4d2Wp100xVPGX5qTHGmJcyF1dErmJhdQVSm+as+C0xbdiAKSE/wqDFkkpae4wzLfCX6wnT7DGKahp8hIG08rjkwQfBz/VkrS5aOn0t+jfz8qUpaz6mQTVC4us0MB/HmO0+JK5VbZOnpg5M2xuOVzOfKKdIVWCVfwCm7RA+e9zgoIGJI+eG78YCQBGYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwD+2OPuTa7Mq1NtFgrUb4No1kp5zqQgBHREo/6NcaXtpGXL+KWMO1yTEcZzgKJ8tukOeVZHf4ZwrRdAdO2CUxbg3+6ELMx2Ywn8R4rHnht5ET57n03+qyoeSsnul5KlA8cbhohqTAvGzK9pCG6wTknnZLKkWu8XmrVngepjvGb9Wn2silrMtl7tvZXPfsi14ypnrP81JDsNX4akml0h0Iq4pZzbVInFToCHAsa1dl5KHd9lqlrZdl4jMofvk2ZJrWKQsoEHfs1y3UXxzQ7vMl6Jedch1r159EdPDJ0LWRa9cztGk++JlUvZc5aPWW9S/aWbWOPaWwzd0yDaYzetK5bdy9pzvUwlLWBnVZEqC/nehgJjQlPCJflXM+MvV4t59rZEdnMbkG3DLXijsdNdKdMc0YkY1q1rMUM6mT1nFGRXK88pl1Dpnbi/DSauDu94OFNlCdv9tHyQ50bdT1lWru3UNJvkFUT5R3otNM7poVaLU/flWePpjnlnnXCcWbomVvKIyHZp+seTJsHM60zgY5pvpzrHq9po2D10aplg9iyMW0mq5oWjI33XosFZbqEaeM5nfJRNk/8PNnjfNMwps3Hd53Wu7E8Ub55OGR3h5xMI43xDWg+05zrNCtmfq3rtIANwgWTfB3VlHlYQqFykWn0Aqn7e5e/i1szRs/V13gaC0wzVfGU5aemP5C0IrLlRdzUpjkrfktMGzZgShCXDmXdLXuSeksqae0xzrTAX64nTLPHKKopX2Dkaxv+cS3YakFPJFPB4mtT1kMXtxce+V+ZWW3MOkrwL9fjaeTlCz0N+2NvVzXkXO8Ox5jIZcQrp1Vtuz8GmLY3HK+aMt/2+rYKVZFt+6cA03YInz1u9xe5CpufOBpjbvpuLAAUgWkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrAtG2z+UfzetljFsyl2ZVpbaLFWonybRjNejnXctjSGWHWMO1a2JNp01GGs1g1Ud4OwfVWb/xp1msC01z2ZNrKrGmak17tqYdpN02SBIz7T2OyGU/iPVY88NrIifLd+270WVHzVk50vZQoHzicjBgpxNPMWEhaVWR52ZBIi3EXJOaC7bdtJNW7R5xUvCqe8vKFxJeJ2e3jy+aUZ89lG5KWn5ouJ55kGrZha84OjRlC5Z944GD1nOWnhkSlsTPffmx8gNRJhY4Ax4JGdXYeyl2fZepaWTYeo/KHb1OmSa2mGHq+rydIY1rXqGviC0LztOwakXz54ZByBHb41Gmn/1qQiMCgaU9ZfmqGf5CMXHuHL2X+ZOcbDuJZVb2Bdf/T4MGiMC2e3rSuW3cvac71MJS1gZ1WRKgv53oYCY0JTwiX5VzPjb0eRhS7P4RMI1t6wnsF04SQUbvKlwXsIxBmHTStLhsa926bxgarzhkrpNeuav9Ncnd9Mbz7JXF+Gk3cnV7w8CbKkzf7aPmhzo26njKt3Vso6TcGJzwwZFp41Jln2vIx7eKmtc6QLN+xUNOCEdh7Jq1pnQl0TPPlXPd4TRsFq49WLRvElo1pC+HzQFXTZlyh9XtQG9PGbXznAdNWw3ed1ruxPFG+eThkd4ecTCON8Q1oPtOc6zQrZn7GdRrFGU2kKOqVTWvKfMkSZ8A0erFkXX3NMM268HOvvsh5TJi2j/BPgdSmOSt+S0wbNmBKEJcOZd0te5J6Sypp7THKNJ6H614d0dHGWnsUOg7fY2bPCqXx0m0W0S8DplnzvXY5McI0suroXUK0au0VkeCYtmfVkHN9TTjiSmPpXhH/mrJ9YNoV4XjlrMzsnH3em9YC064LPnvc5a9/H3ueOBpjbvpuLAAUgWkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANAA0gGkAaADTANAApgGgAUwDQAOYBoAGMA0ADWAaABrANLAxqucsszPWroJdmdYmWqyVKN+G0aySc80Tb+c80HrXEdjLcpjCrWBacqajDGexYqI8eyD+rMfHw7TbYE+mrczlTJuV8QLTboMkCRj3n8ZkM57Ee6x44LWRE+W7993os6LmrZzoeilRPnA4EVcs3yjHppZ8yunOO2mrGTK+lPmYTjZOw6rnIffdE2vWpbnbgWZuVX7qT752QnTdAGu+w4lWpIn9wzzl2XPZts1PTbcZcTVw8pvJoU+dVOgIcCxoVGfnodz1WaaulWXjMSp/+DZlmtQqhGcII1nxTZkz5+imwphm7zJ+jPxa+HqbMUN3rPuTGrM57ZzOlzIne2hOOUst9MfqspOXdyi3okdxTHvK8lMz/IOnIsrHunXTum7dvaQ518NQ1gZ2WhGhvpzrYSQ0JjwhXJZzHRd7HTbNhpvlN60pc3d8m1atKeth2HEOPMS6t5v2oZ7mpczd4chvghxgTZna4RLTpPzRGSeflsT5aTRxd3rBw5soT97so+WHOjfqesq0dm+hpF/viYVnj848cdo0T/hujGncBKtO6oIkX3cs9ijhDcsV9xne4bqmTR1rM6Q1rTOBjmm+nOser2mjYPXRqmWD2LIxLY7QigjP5Ywb0xauk1TFU3BME00TjvVS5tYO48a0wA7DZyI0nzJtFwtKG7hO691YnijfPByyu0NOppHG+AY0n2nOdZoVM7/oOs0OY7br2rEqYplyYUJ1c8qlP0bJ/du+1KHYlz3tlR41bez6kTsMteqZZdrUsTaTJpraNGfFb4lpwwZMCeLSoay7ZU9Sb0klrT1GmyZO82htXlZlHqxvIvcqn8wpF1f2xB7JVwXpighZeKzK2llvqD3HCuxQblUVzjywbRU0bfJYG1ENOdfg6rEnGYmAaeDamXXLzsWAaeCK2cbE0Rhz03djAaAITANAA5gGgAYwDQANYBoAGsA0ADSAaQBoANMA0ACmAaABTANAA5gGgAYwDQANYBoAGsA0ADSAaQBoANMA0ACmAaABTANAA5gGgAYwDQANYBoAGsA0ADSAaQBoANMA0ACmbZttPH8XnM+uTGsTLdZKlG/DaFbJuTbGOIEVdrbt0jDrjZu21VjADbIn06ajDGexYqK8J1TXrd7CI6vXBqZFsyfTVmZN08SsXVIP026aJAkY95/GZDOexHuseOC1kRPlu/fd6LOi5q2c6HopUT5wOBkxN8gJ3rVD0qoiy8uGZO2y6HlvcFrbSKp3jzipeFU85eULiS97tndI0sn6fFAeWebkp/UB9r5As82kvGuSOqnQEeBY0KjOzkO567NMXSvLxmNU/vBtyjSp1RRDz/f1H2lM6xp1TXw5oJ6WXaPuXWs4tfYwMaOlO6Q+fC14eqCdeU3TfYUxzc7ptINFx/OEaRekN63r1t1LmnM9DGVtYKcVEerLuR5GQmPCE8JlOddzY6+HEcXuRSHTyJZNmfPuJ5hG3qIv7SrP7ryw9OrxpRuTO8Rzdpt6TXspc3d8u/VJZuL8NJq4O73g4U2UJ2/20fJDnRt1PWVau7dQ0m8MPEU+aFp41Jln2vIxTTSttlW1Q6jlRHlnbgnTVGGmdSbQMc2Xc93jNW0UrD5atWwQWzamLYTPA1VNm3GF1u9h3THNiYQHm7hO691YnijfPByyu0NOppHG+AY0n2nOdZoVMz/jOo3ijCa+K7B+wxVNa5y0+sjTFUzzXqfRKy5Xxe486vAgtqGsTi1Sm+as+C0xbdiAKUFcOpR1t+xJ6i2ppLXHKNPIQqCwKkJHG2vtUehufI9ZJlyM2S/dZhG9OWCaGdZLxFXE2rv2yBcnWcPbUw0519eEI640lqZH/LvItQLTrgjHK2dlZjNs/C6zCwDTrgs+e9zgoHF7E0djzE3fjQWAIjANAA1gGgAawDQANIBpAGgA0wDQAKYBoAFMA0ADmAaABjANAA1gGgAawDQANIBpAGgA0wDQAKYBoAFMA0ADmAaABjANAA1gGgAawDQANFjftP/890cUFBRWYBoKikaBaSgoGgWmoaBolLSm/Xr/2TRvf/VV/fL7v+bvP39J/gNCQVmlJDXtzUdjPr72Vv32wZgPPy39VIHToFXhs535WwMFJVRSmvb6vTSg/fjTB2tAW3A4qYq97262ykdDQWElnWnfPzbmy/33vqofqr/Nl99/GN8xwkDkahM+q/YfMdu4ZcZHQ0FxSjLTXr39Yt6/81Z99+cX8+EP+o6JNs27w0mL2MZnfjQUFLekMu3dozGPb7xVfzwZ8/Sb9Wbk4aSjGzKUSTuM3AkKyrKSyLSZayGSCbNMC2zANj7ro6Gg+EoS02Yv7sebFj4rgzENJVFJYdqctZC2RB5uUpKY0zvro6GgCCWBaa/fG2kt5KcPhq2FtMWcN3t0N4g8bdiFslbRN23eWkhbYkyLscIIg5u7H3dLWIdyTtE27dXbL+bz4ytf1Xd/fjH/Vt/5qi5hmnTazLTAmygo8UXZtCU3Onr3yQ4X6YC0vfd993PBNJTFBffyo6BoFJiGgqJRsuRngHJlZfXf3dcBTENZuaTu0hsFpqGsXFJ36Y0C01BWLqm79EaBaSgrl9RdeqPsyrQ3H40x0h++55d3j0a8L2xe+f6xYTe+BO7tvPaSuEdvlT2Z9urtF2PWM631FqatXdJ26M2yJ9NWLjDtMiV1l94oyqb9ev/ZGPPxddvLjTGkO7ZD1uObfuwy431bwzvGWGNa9z6xhb5jtTJm+O6p877x78Q5nFimTLOPaH8FdvxR2Nq/+Wg+P75qp7jGGPG2bKuw70mwl5c4jXaf9A47f0e7eZKYxrAEeHxP/sv7zip3/bYHDJ2m3b+vFWkbNk1qtdw0+Qvmr95+4Sc/9PKu69PPInxLPdK0y5wGTIskkWndf2T3su2jbCh7/X78N+3QrN8PI+HYLfwTQuaktHG72TAcsZeLTfOOSM791lSGNx+t48ZNR6dM0zgNtb67L5KYxqdV7X/z9IKHzzT65uv3xrZinPP0TJnW7o1znmn2bkmfdk/P2F18ehCbYZrWaczpfjdEWtO6/2M6pknPWhVNGwV792jVskFs2ZgWWZyvt0od9PvHZvyMgS/FXsY0ldPQ78S7YAPXab0bsmneqzs+YjSfyTRydIbhmDbQ98h21uo9w4kuPm5mX+o4n8Ve6RH68SLT6A67D3Lh03AXpWb3wdsgtWnOytgS04YNmBLEpebtu27Zk+khn8lI3F/wIvfGPiA/VsQCRrCQ3y/v39HH117qNLoZ6biN+18FTOrZI8oVlF/Zr7DUXXqjwDSU88qbjwar/BHANJTFxfojzVAS9+itcsN3Y6FcpqTu0htl/eeIAABcYBoAGvwfdZhi0pae2iAAAAAASUVORK5CYII=" alt="" />

3.4   mapper.xml

3.4.1           定义resultMap

<!-- 订单查询关联用户的resultMap

    将整个查询的结果映射到cn.itcast.mybatis.po.Orders中

     -->

    <resultMap type="cn.itcast.mybatis.po.Orders" id="OrdersUserResultMap">

        <!-- 配置映射的订单信息 -->

        <!-- id：指定查询列中的唯 一标识，订单信息的中的唯 一标识，如果有多个列组成唯一标识，配置多个id

            column：订单信息的唯 一标识 列

            property：订单信息的唯 一标识 列所映射到Orders中哪个属性

          -->

        <id column="id" property="id"/>

        <result column="user_id" property="userId"/>

        <result column="number" property="number"/>

        <result column="createtime" property="createtime"/>

        <result column="note" property=note/>

        <!-- 配置映射的关联的用户信息 -->

        <!-- association：用于映射关联查询单个对象的信息

        property：要将关联查询的用户信息映射到Orders中哪个属性

         -->

        <association property="user"  javaType="cn.itcast.mybatis.po.User">

            <!-- id：关联查询用户的唯 一标识

            column：指定唯 一标识用户信息的列

            javaType：映射到user的哪个属性

             -->

            <id column="user_id" property="id"/>

            <result column="username" property="username"/>

            <result column="sex" property="sex"/>

            <result column="address" property="address"/>

        </association>

    </resultMap>

　　3.4.2          statement定义

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAnYAAADuCAIAAAA7nN2pAAAbmUlEQVR4nO3dT2sUy/7H8Xk8rg9ZzCa/R3CegBwkILN241JmuCBkld8ErugiOyEcYsTFwQG5iDciejnozcboYjZxIyHuxHX6Lrqnu/5+u/pPdWom7xfNOWb6X/Vkej5dVZ2uUQYAACIYXXcBAADYTEQsAABRELEAAERBxAIAEAURCwBAFEQsAABRdIvYT2fbd948/NRTWYCUfTrbvvMmn/jMAwjRLWK/n98d9utm+84b+UXnArWz5MXaveKc5Vusy3E11bGoPZYn0gFGdvnQ+Zn/dLZ95+zdNZQHQLqCI/b7+V37GyR+xJb1Bt9ULiYsr26tdpmseSjaqxtbVv/b+3HVbkQuvPC680qi6b4E8vvc7776s3ER+/387p2/D79fdzGATRQWsZ/Otu+8ufvXL/P1AWuxvqyylwl50Te3r691uZy+Jdsdly+omh6acP3h3FdtCWW1lzuBxzW4jYvYLHv35M02rd9ABPUR++2vv72n31AR66zVOZfx1SBrt2z/KPy7NoaN4PRFdS/HFR6xmUttfBoL91WzrC1e0HF9Ott+cP4tu3zo7CVVek+3n1yqG88/1aupisZ3T7QljR+zLLMjVt9UMRXXo9/P7945O8wXeHD+rSiPksRqCR+cf1P2e/evX3nymavEkR+F4zIaQAc1EfvuyZttoREpfhOTM7qMWXLVx4goe/v27sIjRHhdKHmPxxVeZvkQjH3Jlw6+jYQzjtG5u6DjKiKq+BB+++vvMo3Uf2fZr8MHSlj6a5wtIlba5vfzu3l2lv9QV/9+frfa+OVD5TqgCNfiR73w8eSFHGBHwI0hROyvwwe1l8+XDx0RW1UpjGtzcZYkPD+EKMpcSSDkUJdoCdl11tNxBZa59hBCYrLpJYiwR99RNDuuT2faJWB1zffr8IFeJ1Mj0H8nfISI/fvwu9re41ld35e539BW6O6n3uXDJicmAFm3Wqw7YvsXHo32937TiJUjRFggfLF+jys8YmvL7FtSKLCwL+eSxioh5ZGOy5s9eqIUk7JkXmO782Zbbx0dNmLzq1hlkiI2/olGLRboW7e+2KHUVpuE7+VGkRY4q3aZkF1n/dVia7O8tqjCArUFdu4rPGJ9ew/alxixQR/a7+d3lZQdMGJ/HT4w+18712I78N3SCKCDbncUD/XoiUa1PePF8NAVvtOdmWFvzZ6lLhMS8O0i1nc48r58u6498JANNtqdc/mg4/Jnj94XK9CalNW19A7Rkidinbf+1Uas1j3si9jLh5HDjzuKgUi6/V3sgBEbWG2yl7FD1FhR2KlcJN+SdiGFFOl+XCFRFFhD9R2O8W97yaZxHlK8jhGb2ff6rkLLeF1PL6WF+cnlt7/+Nm9Bcm3Q3qxyR7G/oVhprN5+cP7Ov6+4pxh/FwtEsyHPKPZ912d1X+XtIjZwO86M921T3pGwxxgR60t957WC7wIifHflTp0LCP/eVK4GagDrJ/WIddbzfHU+57q1WxYWaLRNoQ5qb7av4xIKKS/jXMu5vC/LjdK2i1jfOxZyXIXZ/23ev989eeNdBsD6SD1iAUmePZv43+0nl965ANYEEYu1dd11zev8N4B1MLr4edV0+py8FgfFxMR0w6d/+1172ZjWdCJimZiYmK4ufl75opSIZWo9EbFMTExMVxdELFOEiYhlYmJiurogYpkiTMNG7KuD7ek0n+6/6i9RLUEHcvxsOpru714Ky3zYmU53zgLflhc72a1Rtn96dXGc3Rpl947NBT7uZrdGxfT7rvm6+kqjKV/9RX+fid43eFOm4yTet9rP4bW+Rc+mo2k+PU2qYD+vLpQoNd7DfiOW86vltJ7n17XUYl/d7zFiXx1sTw8O9dfCfmE9R+z+VnZrK/u4OoX2T7W5wnnVMWJf7GS3dtTjqoJce731Bnud7hkfymPHe9XXpF7TdHmHG7xvW9lH59zT7HfX2XhvpK2yv9XDuyF/DtOYzp46I/b42XT07INr4enWydfix8uXW1PXYj1MZZQa76EWsZxfq4nzK2RrwRF7fvLb7Pjw59XFxkRswNQ0YvMPmfOjUM7tfVK3XF1hrT5hLXYar6j5maB+KD/u+k+bzpP2XRa/Sie9b84L8NWX9Qvnj52LIX0lXfPUJGJPT/ZH0+no0ctT14+9TmrEqu+ho3b78+qC84vzq3xvz09+mz3+x7lj+bCI/e/xaDb77V9Fha97Km5kxJbXj46PgvXR73GqrlutK9Z2J5h5IdzjZJ0Jsa/o1V9Euy/EXt435y/i4252aye7t3pD9neyj8c9fCFKn8NUpqYR++zl7qO8wenr7qOnx2dPI0es8R4Wr3N+WQfC+VW+fvjnbDSb/fFfc/n6iP3Pvx4ba+Yx9vpor+xYNUNO6XPdPrCz1BOx0lrv9/bKfU1vH723CqDNqjkouUNImTsdNYhY3+/jljWVv5i84cJx9bc6Ve55GmGMzean/f6WeTqprdP5J0Nt23lRt8F8yq/c7WI02OCOsin9I258TJ1rtSyGcVljfT/6NugthrFB+UflAO0PQHmK3ju+2t8q+nWKo9jxrlt8SE6z30fZC2Vu1++142fTrZOveXusfVKop4N+LnzdfaScKVU0GhemrutUM2L1TRVT0YlzerI/evbh9GR/5+zi5+XLrWcffuoRq5awak+++rAz3d+9/LDjKKFvkm934vzi/JKnPCvLumg+1UTs4Z+zkVX/9dUdlegtZ73f27Pz0hGx4lqv7rujugzmdrVYx6X0191Hni+Ll3+MLFv//5+wt955kfVip4pG47dYfqDzBbTVT7Pf1d96ed3q+ghWK+ZrKd8R1SWnb4PlyaC3BRW7EDbov541j1TvQRGugtsU49j8OlDPLu8GhWIYVQT9R/keFuc2742y/dOrFzvZveOre1vZx59XL3YCfinH+jdC9862IqKK0FJPAf10uHy5pYSlu9/06qJVxErbzCM2D9ciaJWILV6pNlvuqwjX4ke18N5zWYpYzi/Or5Dp/OS32Wz055fyFSFiL//xz9lo1f+qTmWN09XY+35vr6hK+iPQjlhprddHe9t7R6/dAdtvxJqvNGooFib7+tf4KBi1WKPLR41YY1PVLFdvRLWw6xzIP2HeDVqtTFr3vn+DF8YJJhyp8HVjvBvNi2Hci6HuV9qgvxjGdZKxkdp7Mcyz9Li6aeL3Le26W/6l5KWtDqd7H8TxM61r8/Rkv/jx8uWWfj+gGoHHz3x3BfccsUUl++rr7qP9rUdPj/2r6/sy9+u/JignKWI5v/RicH75py9/zGajf5785+fVRfta7OfPn98f3dabZ8v4tNpvayNWWuvwwF+F7TdiT0/240Ss1Pvi+hUan4Dq4tS6ca6c5agoqwv7rsX8G7xwtXIb15jeT15+ZhptYrVdWc612hajOkWNK1Z5g/5i2G1u6o9N78Wo2qyU/qH8ulv+pZjfNf3UYp3ZUzUdOxuEV3ceKY26P68uokXsqjprrJ7fYOzo2XFFbE0PrhCxnF/GxPnlnprUYovJ1xdbeX90u0rZkFuZ3BHrW+vwYJpALbZDQ7F4HeRsADEi+Z7eT6DVbvWT3LzTQb1edl4DChsUix14t6p2AWuV0Hfa2NfRLYqhnqLaYsGXpfbVd/lLMS91m9+L4bsnzm7zN/ZlrNjDbcNixAb99erpyb6SsrEitpouX27lq1++3DL7XwNqsa0aijm/9InzyzHp9wXnUy93FGvNvHqvamDEimtpEe6ea2wt6KBc5/mHnfKMXV0dd6/Fin8xrXbn3FOqqu5+fuvC2Thjjb/eKXfqvQYUNih23gTerapdQOgXj0YJvWu1K4Z4L0bgrY++whs95fY2izssPIdTLi937FX72jI/AMa3Q9c71f0tqMatCf5Ja1JW19I7RMvJE7FWM1KxNVfE7u9eurqHfRF79rTuj+AvAvpiOb/U4+L8Uqf2dxQXk/53scbdvEb+mff6rpp5Dw+s1mClBdi3VpmjIbsLuaNYucnQvlWyahzb3738uvuoe8TWXAeVf8mudgYoyzt+LJd3fdCNrRkfX98H3b1BpUlHa/ARNuhbxdiXq4QhLUuhxbAua7TTXtygrxjVHZKrN8o913VO3jO26brqUjufvL+UY614/fzJo9hJad7ruzodjNf19FJamHfO1JNIPPXMzZZ/peOPWK2xerp18sG/r5DqeM0DFDm/OL98U9e/i9UnqYKahhYHFW9K+M8TmdZsivokgQ2bWtxIwTOKb/gU4/wiYuP/zhJ9iB3T+k1croVPRCxT0ynG+UXExprKlg3ylamvKeKDgTZuImKZmk4xzi8ilomJienq4ufVv/2uvWxMazqNMgAAEAERCwBAFEQsAABRELEAAERBxAIAEEVCEbucj9WHhk4WqxmLifE80fF8qaxT/aQR1rL2VuzLKIFzPQAAwqQSsYuJlqrWPM+smoj1rGXtbTHRlxQ2CwBAmEQidjERaot9R6y4s7rNAgAQJpGIzZtoh6nF1icsEQsA6C6RiM2UvlMr26xe1So5m/TFqh2uvhbk+s0CABAmnYjNlXccKQnXby2WiAUADCK1iM0t52MlZIlYAMAaSjNi9RzsuS9Wz++mmwUAIEyaEav/UU3vf7STd9PyRzsAgJgSiVjz3iQt32oePeGZV/PoCW22GcVELACgs0QiFgCATUPEAgAQBRELAEAURCwAAFEQsQAAREHEAgAQBRELAEAURCwAAFFsVMRKo7APtP/r3D0AIClEbA+W8/F4vsyyxaT4H0kLACBi+9vzaDyZTCYTYWx5AMBNQsT2hycbAwAUCUWs9kh/NaoWk9F4vlQe3K/FqPG4f3WeOst43b9BfWSBwMTOB8hb1WLJWQBAOhGrD19nD8lepa46lKwxvLpai9Vn6T/5N9iuIkxfLADAlkbEGlGZ6Y2ui4lWMaxmmXmo/Gw12qrLejdoRn1DZCsAoJJOxBqtq0ok+mqWVjAb61jCqqpKSzEtvgCA1tKJWLkW60xEoRYrpmhga7DeXA0AQCNpRKyzL1brOnUnotLiu6p7uvti7dVCWnQ9levmudtuLQDAWkslYjOjbddTORVWGs+Xy/lYXVC/Nzgos41V7FAs9te0y5WMBYCbJ6GI3Wj5symIWAC4QYjYIeSVY+42BoAbhYiNjTZiALihiFgAAKIgYgEAiIKIBQAgCiIWAIAoiFgAAKIgYgEAiCKNiJWfUWw9dEkfvm7kfB6TMYc/mgEADGwNIlYaX05+fLFn/FkAAAaQfsQag7vqAiNWHBQAAIAY0o9Y8eGDgREbPNC6sT3jR729Wt+e2jBtjGEwni+V2WqhxvOlsp5/g+UlxnI+Hk3meTGqlY0Su7cHABhY+hGbKblh1Watvlg9VRunjRSxNePzCCPxjfQh9/RR45WftM5no8M5/zEP+WJQoVEZ3spMTzEAAINbi4hVFjKCNqQWGzo6rGPZsKqwVVZ1NaOd2+hj9teY3aUqV6/esXKmWAwAwODWKGKVRbX6bX1DcdFYG6Am9pSWYiPnLWrEhvQWuzqP7e1JESsWAwAwuDQi1g6iwFbZBn2xQWETWrPUgl7cepuINW+ADqvFUmkFgLQkErF2V6QUTCHZaVcKjYqsc5A5f1+pQdug1O3ZOmKN3tz6iK3vfWVcPQAYUioRmxkNnf6nS1jdje65ZrRZPameBNXu8F3Ox+UCRtOtr6PYLH+7hmJ1c+P5oiyGGLFSMdSDI2MBYBAJRSziW0yIWAAYChF7g4h/YgwA6BkRe0PQRgwAQyNiAQCIgogFACAKIhYAgCiIWAAAoiBiAQCIgogFACCKNCK2bhgA46FF/kc/OQbAcz6MCQCA2NYgYqXx1AMfT2g+Vx8AgOjSj1hjwFVdk2EAeKwRAGBI6Ues+NS/BoPZhSas3iitr6S2PhuP3jdbtclzALjp0o/YTEk2qzZr9cUaQ8B5RpzxCxyn1ixxVdWmvgwAyK1FxCoLGUEbUottNFS5t75rFcjYbH4IE6lVGwBwo6xRxCqLekeFrahzFpMmuae0FBthbnE0I1OBBQDk0ohYOyoDG2wb9MU2zz4tzes2kV8TLGgmBgAUEolY475hoUNTryo2uaPYqMgGjO6mrSV1sqph7LoDmpHkAOAGSiViM6Mp1v90CatD1D3XDF+rFbdYVQ9N4xkXvt5grZD5hpTtWC+QsQBwEyUUsRttMSFiAeCGIWKHwJ/KAsANRMTGRhsxANxQRCwAAFEQsQAAREHEAgAQBRELAEAURCwAAFEQsS0JD1Rs97hGAMCGSSNi64YBMB6r5H/0k2MAPOdzmrojYgEAsjWIWGkAm8BnFOvD8/SCiAUAyNKPWNdj9UtNhgHoN/aIWACALP2IFR8+2GAwu+DUU5uYnaPzOBqs/bOKsWqr2Y7hARwzjLZx673xrQYASEb6EZspQWTVZq2+WD1Vm+fQcj42enpXPxplVCNcmLUqR1FydUl9Lf0n6sgAsP7WImKVhYygDanFdsgkZVXX4Hj1s6x2br12bg3Mpw41HzRgLgAgWWsUscqi3lFhK0ZgBd/rZI4JW2zEKmG1fWGWVEKrAm7UtpWCmIUXZgEAkpFGxNpB5M9OLdEa9MWGVPzMO497qsV6IzaoMircDh3hTmkAQF8SiVijPVW4AVhvJ21yR7Hz1iX9RbtDVE9ztUc1bFbotYLEW6MXZwEArlkqEZsZLaf+p0tY/Zfuua6qpesWYCPj1Hbi8XwxHztLMp4vl4GzxMqq2Sqt3T/lPmRhFgAgKQlFLAAAm4SIBQAgCiIWAIAoiFgAAKIgYgEAiIKIBQAgCiIWAIAoiFgAAKIgYgEAiCKZiJWf0yQ8z8g95OpiMrKeyMj4NACAASUVsQFPG9YffO94prAy+k21oPEjAADxrVvEqqkqDIG3nI9Hk/l8XA7NOlk0GdEOAIDO1i1i1af5O1ZZjXmTP4l/OR9PFkXCNho0FgCAztYkYl3dra6B3FavFYPdLOfjMmiJWADAoJKKWPddTVX41o4BW762ytPlfDwejycLa2UAACJLKmLrG4rVqqhrSPPVsuVy1ditRCwAYFBrFrHaD3bGrrpiXa3C+hjqAABEtm4RqzcPqzc/KQErtiEDADCItYtYV65at0IRsQCAa5dMxAIAsFmIWAAAoiBiAQCIgogFACAKIhYAgCiIWAAAoiBiAQCIgogFACCKjYpYHkMMAEgHEQsAQBRELAAAURCxAABEkVDELudj14js5ch01QP/rQHsRo6hADLPEAF1G9SKQWIDANpKJWL14XOW8/HIGLKu/FkdJdYYMdY/mKz+k3+DVIQBAH1JI2LtwdXVoeeqcWCNWa5h7pTw1YauU5f1btCMegAAWksnYo2xXJVI9NUsrWA21rGEVVWVlmLGlwUAtJZOxMq1WGciCrVYMUUDW4P15moAABpJI2KdfbFa16k7EZUW31Xd090Xa68W0hjsqVyTuwCAAKlEbGa07Xoqp8JK4/lyOR+rC+r3BgdltrGKI0rJWABAmIQidk0sJkQsACAAEdtMXs3llmMAQC0iNhxtxACABohYAACiIGIBAIiCiAUAIAoiFgCAKIhYAACiIGIBAIgijYiVn1FsPXRJH75u5HwekzGHP7UBAAxsDSJWGl9OfnyxZ/xZAAAGkH7EGoO76gIjVhwUAACAGNKPWPGRhYERy0DrAIDBpR+xmdKvatVmrb5YPVWdA/cAADCEtYhYZSEjaENqsaGjwwIA0Kc1ilhlUa1+W99QvJhwrxMAYGhpRKwdlTWjpivhGdoXS0UWADCoRCLWuG9YuAFYv3OpyR3FVGQBAENKJWIz4wYl/9MltKSUHz2hhi83FQMAhpVQxAIAsEmIWAAAoiBiAQCIgogFACAKIhYAgCiIWAAAoiBiAQCIgogFACAKInZQPMkxy4rHgMgP27pBbxTvBrC5kohY56jrxdeK/SxFdWn56U7NnwkVG9+VWUao6Hg3gM2VRMQ6nyBcDI9TH7EBzyjWh+e5xm8svisD8UapeDeANXUzItbYChGbPN4oFe8GsKaSiNjqK6QK29W/eolYYwyAtt9Y5aDwZuNycTlQNUBbBXaOcKDPMl73b1ArRtiBGEds/ChtsFUJxXL4lxfeqF7xbgAYRmIRW/VLLefj0WRhfuGtePti9VQN+KIM/vrSY9oeGb4qlXpVYFwhqN/m+iy7nu3eYLvrAylUAofmDS9h4+I4thB2lNYvchTUr76h7waA5KQRsas8XUzG83nVQFxGbKdarL1Mi28suxhq67Zxv1Y1yzWknhK+1k1Yao46N9hyVL66UHFusG0JGxfH8UrUUOHdADCMdCJ2PF8uJqPJIiv/W9ZmuzYUr7blmteshJ49+DZoFd5YxxJWVVVq9oFf5HLTqGeDHUrYrDjyG9U/3g0Aw0gpYueTsrV4sugzYuu+UwNLKNdinRsUqiNiIQJLaNwp7Rf6Bmgb7KOEoSu3q7dFaChWrdm7ASA5aUTs6ruySp/xeNxjxBqV0NbdmVJXnL8Yag+dsg2pxy60hJ7KtRU06r7091raYB8lDF1ZeKN6N/y74fylCCsP+W4AiCepiDVuH5osspCIdddhXBUBbxttg+ZWq43QtTP3SuP5ctXDXDDv5Qq96UYquSczlLJPFmox5A22KKHAUevU7+nxvVF9G/rdcP5Sknk3AMSSSMQCALBpiFgAAKIgYtEj5223nhZtANh0RCwAAFH0HLGfk9fv8QIA4EPEAgAQBRELAEAURCwAAFH0ErE/5o9n47c/si4R++pgezrNp/uv+ktUSx/HCwBAvT4i9svz0ex5/uyZzgn46n6PEfvqYHt6cKi/1sPxAgAQIDhif7wdr3LUsHheVGGzdYnYH2/Hs8fzH328fwAAeIRF7Jfno1mVoxo9rrqn4jC12MXz2Wg2m3zp5T0EAMChPmKXbx8LabR8+3j0vJqXx9jro72yY9UMOaXPdfvAzlJPxEprvd/bK/c1vX303iqANss4Lvd1AwAAndVE7OL5bCS1qX6Z6Onrqzsq0VvOer+3Z+elI2LFtV7dd0d1GcxiX+yPt+PZTL1EAACgL0LE/pg/no08/a8F5UanXFnjdDX2vt/bK6qS/gi0I1Za6/XR3vbe0Wt3wAbe7vRlMpuNHr/lCboAgH51qcVWf6tTWsXi0W29ebaMT6v9tjZipbUOD/xV2JCIpRYLAIimQ1+s675cM+TeH92uUjbkViZ3xPrWOjyYtq/FCvdwAQDQWfs7ihfPHfU/K+W0Zl69VzUwYsW1tAh3zzW2VhWeO4oBADG1/rtY80an3Gfrbl4j/8x7fVfNvIcHVmuw0gLsW6vM0ZDdVXcU83exAID4Wj7dafn2sfMWIamCmoaO7xcAAIHaRazjRqfcdQdovY7vFwAAgRhpBwCAKIhYAACi6DliAQBAjogFACAKIhYAgCiIWAAAoiBiAQCIgogFACAKIhYAgCj+B6sGwPbyyyy2AAAAAElFTkSuQmCC" alt="" />

　　3.4.3 mapper接口

public List<Orders> findOrdersListResultMap() throws Exception;

3.5  总结:

使用association完成关联查询，将关联查询信息映射到pojo对象中。

4.两种方法比较

　　resultType：使用resultType实现较为简单，如果pojo中没有包括查询出来的列名，需要增加列名对应的属性，即可完成映射。(也可以直接将返回类型置为map)

　　如果没有查询结果的特殊要求建议使用resultType。

　　resultMap：需要单独定义resultMap，实现有点麻烦，如果对查询结果有特殊的要求，使用resultMap可以完成将关联查询映射pojo的属性中。

　　resultMap可以实现延迟加载，resultType无法实现延迟加载。

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}