mybatis延迟加载——(十二)

时间:2022-09-05 11:58:54

1.     什么是延迟加载

resultMap可以实现高级映射(使用association、collection实现一对一及一对多映射),association、collection具备延迟加载功能。

需求:

如果查询订单并且关联查询用户信息。如果先查询订单信息即可满足要求,当我们需要查询用户信息时再查询用户信息。把对用户信息的按需去查询就是延迟加载。

延迟加载:先从单表查询、需要时再从关联表去关联查询,大大提高 数据库性能,因为查询单表要比关联查询多张表速度要快。

2.    打开延迟加载开关

在mybatis核心配置文件中配置:

lazyLoadingEnabled、aggressiveLazyLoading

设置项

描述

允许值

默认值

lazyLoadingEnabled

全局性设置懒加载。如果设为‘false’,则所有相关联的都会被初始化加载。

true | false

false

aggressiveLazyLoading

当设置为‘true’的时候,懒加载的对象可能被任何懒属性全部加载。否则,每个属性都按需加载。

true | false

true

    <!-- 全局配置参数,需要时再设置 -->
<settings>
<!-- 打开延迟加载 的开关 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!-- 将积极加载改为消极加载即按需要加载 -->
<setting name="aggressiveLazyLoading" value="false"/>
<!-- 开启二级缓存 -->
<setting name="cacheEnabled" value="true"/>
</settings>

3.     使用association实现一对一延迟加载

3.1 需求:

  查询订单并且关联查询用户信息

3.2     mapper.xml

需要定义两个mapper的方法对应的statement。

  1、只查询订单信息

SELECT * FROM orders

在查询订单的statement中使用association去延迟加载(执行)下边的satatement(关联查询用户信息)

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAukAAABQCAIAAAAr/HzIAAAR6ElEQVR4nO2dP2sjxxvHNy8gdd6D60OFGr2DewNHOASHajdXBonAgSr9LIhxCnUHJtgyKoIFJhyOTbBDcOLmfC7UOM0h5M6k1v6K/Td/nnlmdndWq7W/Hx640+7O353Z+c4zs+sgBAAAAABoDkHdGQAAAAAAyAG0CwAAAACaBLQLAAAAAJpEIe3y913n7fmHv33nBQAAAADARiHt8vXh3Wa1S+ftOX+QvMB6ir+s2BHylOmyMuXKi8eoyqTlXjo+EpPlzqs5fj0bTHIFmln0/03eFwAAeB7YtMvXh3dv7/4gDlarXZjBiRxX+GEsHST4oS6v2tCDKzHrg5PHchUYvwsPkx7TYuq8WFom/WetZ/4nmUSBBmPKEhNtcb4+vHv71+FXP5EBAMDWwmqXv+86b8/f/fqfenyDfheTCNCvcTloOltgbLbm1v3KYuUyDZxVFM1XWrpKYHSbKQ8uukQP6C6zil3JVIVjEC/88fN5B+u5AIDnjlG7/PvrX8aH4Ka0iz6eMSOTaVLLx6z/ZP5vHSwVRWIdwMqUy11PhBQVaRc+uKOqcxdApp8u8ZiylFe7kPE7yjWT3ipD1HOJKQcAADwXaO3yx8/nHcb5XL1rmtQEyil9PBP/r4wZevx6cu6DCnOcybnHcrnn2Zd2KZ+WUi5TPAXqnD9Oignm//pNyZVtx+SYnHvg68O7t+edn1dVxQ8AALWia5f/Dn847+h7XCRWHwjtsvogPtZ/ePjX6RSH+2DJjPEhNUgwo0j5cdQag5dyOebZl3bxkpZLoi46STwiCiPymlzxmKKyFoTXLmQe9NYiUL43rT7k6WsAANAgCvldaO3iH3fNYRoY3OPhxznmAvfL/JbLXU84DuGhGV9pMRVlitN63Io1IFOxyhG+7HxspmZZuFwc8LsAAJ41hfa7bAp+xA39+V0cT1mvcUk69Od3sYoSa1bFqMjL/KblWLdWAcSb4zVK9jagXfRMOtZJPkxb7AEA4LlQ6D2jTX2bzqo5cmkX08CTa5wjY9NP8YOTl3IxxeHTIrFqFy9pMfqjQK5cruFzSN4mR+0SGqqCj63Y3XEH7xkBAF4Chb7vskHtYp0xk/Ps0OZXYMaMYqO4kgfxAnIsLF8uFz3hRbh4TMtdBOhXOspNJVprDl3klFWDOkpMMRU+5oLg+y4AgJdBs/+ekctc2Xq2zClmOCygIfTrc42X/P/LUIV2ySUUeEHDVJeYlik/Lmo1r6LVFSdTUm/aBQAAXgZbql2YibX1Wc9fYI2BGf8ckyMv1sewMuVyGaSrEC4l02K8EfpxvWZ47aLkh9QKpjyb7kWua8jIHUsaAgAAcGZLtQsAAAAAAAm0CwAAAACaRLB8Wjva563HvSwwGAxWxn43U3veYLBG2HfffvPdt98UCwvtAoPBYLnNpFGgXWAwR4N2ian9TsBgsBdi0C4wWEmDdomp/U7AYLAXYtAuMFhJ23rtcjbp9PuRvT/zJ1U0nAoyPe4H/fFwxVxz3e33u3eO1TLrhjtBOL5dL6fhThDuTtULbobhThDb66F6XDySy6LgM3/NyHuEsPKm35SSzUYxa+ut06bH/aAf2cetytjTeiloFKUO/WoX9MottKp75UZtWmcDS7VLgQfRJv0uZ+89apezSac/OZSPud0qz9pl3Ap3WuFN0nzHt9JZ5tFTsrnPuuFOV22CsXV9ROjVdpXmOCXqqsLkqrRK09Jvit+nJN96t8PuPpLaZXrcD46vqYv7rYv7+OfqtNWnLvNgqUZR6lDSLuiVTHJVWnN7pTjX3YAemnXj1kucvQ1fU9W4G0hBxq3izSbVLgUeRDbt8nDxajA9fFovn412cbC82iVqXmQjSM96NzHmTLQmbatAotVlNeoDYnO8GZo7TAXJVWgVp1XhTZHj5x5hNVse7XJ7MQ76/WD/9Jb66dVE7SLWIeGPeVov0SvRK91MEkbVe0O5spAumUSOz8ifOU3ULsSD6OHi1eDgxwc6LKtd/pkGg8Gr32IXRXm58Sy1SyrwiUZQZRfKJhbabKnYM6jCmYrWByqdTW7SzV51WlVPVbnWuy2WV7scnw73I8fq/XD/4/TuY8XaRanD+Dh6pWzole6Riz2xmOT1Uhayxd4Mw51uuJtU77gb3kyLS95Uu5geRIe/DILB4Pt/iLBG7fLnbwdKmEgffDoapZtXVPUg7GvpTHSRYtAuXKir0ShNq//m6ErLgHTKUlP88rlwth/k0C6mBrGjWXpLIicbIaiTp8muwWGoRBs9Gcct2oE5E5qm6Iec2SKMLJo16tnIEWFXiEpu3EoDJUMVzgbvQkgrX7kF+i2baZUpJp03LeVem7LB3JTCzYZJK7dNj/uti/toaUbvSmInknvQ/XBf6F+Z5lDmCdS0QdUuclSxxavAtxfj4Pj69mLcvVs+rU5bx9dPsnYRc5gtLa2vu/3xcHXdJXJoMn6vLnolemWRXqlMdzUFbKp54/1SIuR/GvIm5nDcCnen63Er3psS3+6uU7lmwtko8y57dSMpkvpQUqO1y+Evg0Dz1Zi8HYKmSU9djUa6ECG0Cxvq7D2tgVLFU8zvQkzj7of7hufp6feBRut/fzolROvWWTfTHErjS/t8dIEU/DZ8LTbWdM5ENb4sYBRKeIxmKt4UYdoNZL9lnAQToXmKoJZUXkZlJhbFsqEPG2K6piJnphxXHh/yT8e0pEVcJhvmU56bTWGLx/5YDYgdR+5Eq9OWoELovSnrZSHtwsUZaZdItcQKRtAu8ZEs2jStWLXEP8XMG58AnHZBr9QiQa906pVaumJBjDXP3C+q3mZyJk0PBDLO3SAc365n3XB3ut5thTdP61nXofUmS0vKWoHre0YPF68Gg+CXL+JBXbusfvxpECR7XERLfSTUus/VaBQ7P8zaQtcuXKhPR6PO6OgTrVz8ahf1SK41I8aMXShpBIpUVxbIxeauRJWdorp6djHV+qO2ZYxQcx3rPZyMcKl0LaakzBNZqY2i2SBdC0yRTXnTI1RyxaSlz4rSiYspGy45LNNsPGxqmR5L20duL8bxz9VpS94CL2qL6bHpXSHP2iV2C63vh/vj1v7HqTm4nJaarllspcZpF/RKKhvoldZeqWzUFePkat58v5TcKpFYN+qqLplkeehmGL5uSZ4YvqKi3GbFSSLP8470l+8Hg+Cniz+TIzn9Lp8/f746eiOv1KS6RFvKsWoXLtThxOx08atdbi/G1WgXblmUahnKvc96mrbfOz1FdCTxYtOLA+YIl2Y/LRehEK3iU7Uv/JOhCmfDtMeILbIYrT4LUW6E1eNKHE+PMNlwyWG5ZuNh7dw4qGerSOTaULJtVljfeVovK9MuiQNGCR69dkQsDVPaxbJLhtEu6JVkHtAryQjFXplpC8WHwde8+X7p64Diz7wbdbPlIWGPy661DnWRVI3fJTbTfpeMq6M3mXxx2YdLaxdTqMNJfwv8LiXWjNiNuqSzbldr0+QiqKRhyQ134lyNlNVMhGy2HSfu0pxAy6Gpw+hzuALZMHpBmSIL3cn4Nns3zrkYxJgWc1Oca57IocdmU9hY7eL0FZbbi7EgX6rSLpmtTltR8NVpS93j4uB3KbRmhF5JRYJeaY1Q1THyMpPLax+6PyaNXM983o26Jt2m715Q0lICpkVz0i7yO0OplXnPSFrxkXeuOGoXNpSkjeizSmzW+7p8WpOPwutu+lBLZmbl/S7s3gJx8XvXOnvQJm1K11Jelk4TNcpqJkJ2du74NorUmWU9ruTQGKpoNviBIcpGVPn6njjjRpBoljBUvbIuaS2ppz+dDfamlGw2yup7iVZtXExRNo2ZTVpdEkPJm05SM2gXzV0ax0Zpl/FwRW3BMWmXu4+2T0AtHfa7oFemhl7p1CvZjbqOTlPTXSafAMqGJNUPRwkyfhcXU4eKrIl+WrVLkfeMYpO/76K846MIC/UNoGTF53CiLQwJi0GmUKlAcUnO5T0j4SUC/VWIzOM9Hq7uh/vltYtlMpR+tEpcERSuJ36m11NNXIlN7XWGJk5HKLgfJeckE6EpiJIWlUMXL6hrNqgd8jNrkadqELLTkrMQ3n9OFJmtee6mlG42My9f72A3gqhvACWdSDkuywJhsal7J3Y9tsOq0aYvRZu1i7Ru1W9dXJvTcnEgWf4mAHolemXeXqlpNUmvsDVvqqXsvaQk8/RZalazq8RJSUlxA43rrRSqwqJdin/fRTbOpbIduJdlA7bFH8yA5bSKvze6GeN3jr9wK7DFDX/PqGZDr2yIMV822vq/Z7Qpar9J0t1qfr+CLZ828WnLikz/QCcapMmgXRpm6JXNMWYaD+0SU/tNWgpeuGffIp+9pc7n5v4lPN4nDEsN2qUphl7ZOGN2BEO7xNR+k2Aw2Aux383UnjcYrBFWSruEAAAAAADNAdoFAAAAAE0C2gUAAAAATQLaBQAAAABNAtqlPPNe0JvXnYlamPeCl1p0AAAAtVG/dlnstcU/FZINhfOe8ldE2nsLIUz2S4IJpaUWp6XkgAxnyHl7bxGG8178j9s4bs6hckbNgXhaqSa5ajYmKKBdAAAAbJ6atcu8Zx5omYHRol1Mw6ma2rwnX8lEy0TY7vV6vZ67YjDnUDqz2GsLmmSx1xbOCQWJhVdyofKzYqBdAAAAbJ56tcu8xwyzvrULm5gtWo+hHLWLKFdk5SIluthrB7292AMULvbavfm8B+0CAADg+VKvdmEXODxrF7t0ya9dIt9I4ndxDOqoXUQnEREkKc5irx305ou9dm8eS5fQVbtIa2ViiDiCbI1KSltZ2RLP0atalgjlJTtIIQAAABZq3++SjmfacKvtC5FdEq77XcRNLZaBMad2KbHfxaxdXIubHIu0S6RaYgXjpF3k9TN5gSrOR/xbrDmlFsWiyKeINS4yQrhuAAAA5KV27RKRzr2FQdev36UC7SIkmWf0VdVVlmKWd331yKRdEqGy2Gu32+3eXAtMwixChZqLKjulxiz81vIoXmuMkN/xBAAAABBsiXaJ0Gf/jdAuOXFbMxKdJ1Tek2vT62IHDJtAClFSIZRzHSphNNycK8Ki0Yb26QAAAGgyW6VdnFcTiux3kYVR3mg9kmO/C70ek5xNVqool0xpv4txzxCjXYyJOi4MOdwiAAAAYKu0i7x+4P0d6cg14PMd6ULkec9I3oIiVU3mbTEtJ1lzwW1Psb6rlXhLzPrKpcgym7kBAAAAmk3970jTWz+Ik9oH2Mhzlm/TSafV4XS7tAslWLScF9YuIVMX1m/kJBWreHjU2+IghpQgEC4AAACsbJXfBQAAAADAArQLAAAAAJoEtAsAAAAAmgS0CwAAAACahB/t8nnr8VJMAAAAANQOtAsAAAAAmgS0CwAAAACaBLQLAAAAAJpEGe3yuHcwaF8+hmW0y9mk0+9H9v7Mn1TR8FVfAAAAAKiXEtrly0kwOIk+llpaWpy996hdziad/uRQPuapugAAAABQMzbt8njZTgSKwvwkdrqETdEuj5ftwcHeo9f6AwAAAMBmYbXLl5NgkAkUCVkHlJcbm/G7zE8GwWDQ++K3DgEAAACwOYzaZXF5wAzzi8uD4CQ7F+mDT0ejdPOKqh6EfS2diS5SDNqFC3U1GqVp9d8cXWkZkE4p5aIFGQAAAAC2Hlq7zE8GAbe88qUnyxqTt0PQNOmpq9FIFyKEdmFDnb2nNVCqeNj9Lo+X7cFA1F4AAAAAaAq6dnncOxgEhj0uMcIu3YjUR0Kt+1yNRrHzw6wtdO3Chfp0NOqMjj7RysVxr+6X3mAQHFwuylchAAAAADZIAb9L9mp0SqI3jt7IKzWpLtGWcqzahQt1ODE7XVy0C/wuAAAAQGPJv9+FeltHVQ9XR28y+eKyD5fWLqZQh5N+cb8LswEZAAAAAFtP7veM5ieEx0KTD9KKj7xzxVG7sKEkbUSfVWLLMo/3jAAAAIAmk/f7Luou3YjP2js+irBQ3wBKVnwOJ9rCkLAYZAqVChSX5LL3jPB9FwAAAKD55Puu7uLygNzfyrlUtgNf9QUAAACAesmlXYhduhF1KxM7vuoLAAAAAPWCvyMNAAAAgCYB7QIAAACAJuFHuwAAAAAAbAZoFwAAAAA0CWgXAAAAADQJaBcAAAAANIn/A6N1ryak7wadAAAAAElFTkSuQmCC" alt="" />

  2、关联查询用户信息

通过上边查询到的订单信息中user_id去关联查询用户信息

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkoAAAA6CAIAAADA/OEmAAAM8klEQVR4nO2dO5KjOhSGWc8sQUlvYpbQxR4cmaRzEsrRpJ1QTklduHoNJARTHbMITcBLj3MkAXIbM/9XrntvGyQd9Pp1joRvIgEAAIDDkTzbAAAAACA+kDcAAAAHBPIGAADggEDeAAAAHBDIGwAAgAPySHlryrfzuf98NA8sJ4iqPCfnIu8ctzTp+ZyGGnpL5a9E/mmlrOSvRJ4q84a/ufyVDJ/fufm9+s0i+uS3lan3i/Fc3uoFu8LdXhv7/KKynkxVnpNz/yl3ZVgwO6neKGb8gPfWfESUt6Z8O5dfKxLGlrc/Qv4S8u84dP+02lWHCG0c6rdU/kqH/z4ZrV4RlsSi723zR8i/AalUjR8+KX2n+lzSV72vSlWekzLOUGjrYpxGlU9RP6miQobDsj7fyt/MpPYKfaMpSXkjO8BLNeVrmcHIW3cX2TWSbO9D3kLyXihv/XC9pcRcP12NzpxzK3/rrf43D1WdTeWORS94wMrvcRo15q7eVyWivE20dfG8qXAifnvxfeYV+sYSeZs4alNGNKO7i+zidFI0KHlrrkmWiXtwHh6OKW+T50QomSU8EZk9Nmv8Gw7Qo8od/wyXt5BxYufPVu/rclx5i95ejrXaK/SNF5a3nVQvZ0Z1zZIsC5ynTXlr7xcy8XddTBtppsAoe2xvRNsx8uZK1X0WU1nn97qzDNAueXBHw5Wr52SBvJGcEisWp8jAHzF8Y4ZcRqE6UXt1dra9cNqaYfSDEx8SVCONRpJTpUUUb/0FXbDVou0wrBky7R+c0l3yudbRpOci75p0akq9S6mtLJROU5VnUXeyKckeQqZq6yIp67wYvhzuUYpTU43dqevv1z9aqJxK5bdQUnNiWxfEgwz3LKiobWOhZ0Wfn5Kon007QOGtrD+y3mpzRRnrYGpZbMqbvwPIfTelsWS3VvAxZxuvLfdLoAOmyVt1zRLS9eN9pu+6UC51n4WtVYS8OVM1H7RMeizxQaynurxgem2VJhYiD5x+yYXnLR16g70mmhq4v0FLboQBFY/NzEffq3B4Vye1/6nbdX1ZQtvb6zMxt9DU7mts+FH7f7bgOZ5rHcMgH5qvq4UypNu6mId3U6qjfZgChvlC6w9cqn6nRNTd9B9K19J7lG6GZBfvrlQOCyc7rSV/k2oqrs6/jorizVg5HFb2eSnlwvCAB74OfTVPT0Mr5M2bp5S7bkpzhOp/xp1tgujuIsuSq0e2J3nr8kuWcPttTcmcfuw+C92FIuTHljdXqu+6eCvqb87emPJmfrMoOOmAc1Z67Ll+PiMkpdSHupGVeok8V3JTSiFtMAKY2rZtK3/rqaYOZ3iKp8T8c7KECJBSoVrHc63DbLvAuUlZC0vpig7NqaZ75pX11JG6Wtg+meHY2VY5U3ktJG1WU+k38BXlM34Di/q8lLHD+2wdemuePv34k/K2k6Y0GsgY5nFnm2CaNMuSy93RTcK8NyllV78TIcHmwwoYBsibK9VXybtuMqq8WY5/LHkjnJW5UP9cbxweUbOaL1lOEjlB2EE/O3x6m67xBy+N1bcRkHScdpmyvanfOJ5rLdRQnyaCrhZ6XChghc6mcsnbHP4ig1pMcc5U3omJluR5guvywjUXzxXlM341i/r8YFXUt1/YOvQ9snKmUVWLH5W3fTSlvfFhh45izTZBLPTeRjuZvTcl3/p9VriQYyO0vHGpvsrzDry3DcFJ58KTfGGAO1VhZNWn5c6VcAphr5g42xwHQAwLjTv/5sNU9Ucw7/8Z2Tqeay3ulSwX3uGnGz6VT95cbzvx8samWilv6oaTdpWvKIcZm2P14X1+ShLxzJ5T3oLeTmvrQlG4n5W3XTSl2kCOARtltvETfPhxxclJLbSo76LRtvj23ozsVfmkr646h0k0uRLXHpfq270358JzHretPJEej/qn6uVU+h677gD1oR6yUGNycUQAWBdKX2cRr6H0N+R0gIII1Tqeay36UG/KeTKitrIC5Y1M5ZI3am9MxT4pIH2pVsub7GpxLtPS6NJ8RfmMX8uyPj8l+QnvLfyRtXCfmkrfAJtgBIbpAMrVXTalMmCNTVODCLONj00nJwf0996MU4uG9phnGsda/SqtCKRS4VwqKbVAqLu4kJOTyski+xzR7MUXeWf4/uvwrErG2Vw7eWh4Qsaf0/2U02PkJqUWKCDOI3FX+bdozXMl1NOd7O8rPVUS+lzrMFrZjkJPByAbtZUd4sGlcsqbtM/I8Yfx1HgXm2q9vA15Eks6rqJ8xq9kYZ/vOXEdeI0BrjrkHtn4Xj/lqET/0kadN5yzjZmt/+SknuqJTTmffhwH7G2wOfJs4yHCe29gAzt+F+dhPPLXUgKJtW96JLq80N6CkFKiol4TNOU6IG8x2fGvBD2MffzuH4a6CRMHQ0W9HmjKtUDe4jA57/+Ptk2v396ebYnEUFeYolIhh9rBnkFTbgTyBgAA4IBA3gAAABwQyBsAAIADAnkDAABwQCBvAAAADgjkbTVVmqTPPg8PHkyVen+0qEqTWB2hzcWyH7xy2TQQybQhx82WAfBzPE3expFsDULrR9HmEdXmghtfjlRWaUNZhgXBv7/W5kLkrZRVOvwrbAbhLTSumBaol41q0qvGP5W1uTBu0qt0RaN4jOdqwrpvEAnbQvXudWZ4+obX1njyNnYdKauUroK48hFReaWUVP8BYMc8R96qlJ+LHUPSI2/cuDNLq1L9Tke2jgxFmqZpGiIqPgu1K20ulElOn0+UBxmEaLzR+JPDKW/rGsVhvMsKam4XeRsgb8vNiD3Ju4r23tqb1ebCSrO4G0Y1LYwH2AjAw3iKvDmXqbHlzb8mXjdml6YKnJrVCd6hRm0ukjQfnYE2F2lFOQSEzZy8rWwU1ni3FQ+VN2JVsBt56++k0kDeAIjLU+TNGUmLLG8BEZ/FY7b3DkbvLTBp4NSs+lBEkvFx+uV/m4u0GtSNjHdRhjPytrJRWOMdTGn00qPJm2HGuknevX1lBDy92dORcK3BiG7org3DDKLxmQ6kRTL0O+hIuMtGAHbLs/bepmFE7kAwU8eSvTd1g80z+Swcsxv23vipOfRxVRnot6omkdsob3Jdo3DGB1XFvLM1RuvcG6LrzHD0qAW26nVGq6fnf6bVKt62bQTZQXQ500se2l15SDP5MnmzcvfaA8Cuee7JyWkyMxak8by3B8ibUuTSeZKe9mbb7RAbJ2+jlrW5EEJMWhHwpK6jJfNNwY3CGe8zoxdkkeepKtcRvDf7nk0hOn924dlPCxBCY0Ji686OSpmxSN6s3J1jCidMwP7Zw4sB+kmAl5G3hYQF1lQXjLJ9vJc4pBBL3pRbAxqFM95nhsjbfn0w/XPy4rYGJ00z4sqbZWFI9pRbl9ixSXc80Gory9XdJG+kjT+wQQjAo9iDvOkjO/LeW8Bhvj3JmyNaNF4dQ6KUYxcyzVoZ0okCG4U13kFf4Xk6RSjnczHR9t4c+0uLWOS9uYOT2pajbRDbDYd0Rrlmx97svYVUE9QNvBJ7kDd92yCyvBGhn80vBqwicGomdsO0qmEW8sx3ZFncXo51Y0ij+OOpXObqvCqEiChvhhmR5U21aPSfgrLnYpOk0ZYNaUq4bsbeY4C8qcn0ZgiJdEDewCvxtBcDuBiNvQI2ZmP6miOVdfk5AZfQqZlSFsvy1fIm2bpY2Shu450mGI03OTZueVtuhqdvBNQSX1cib0O8ZimNdzAIExzt13d8qsFnOyrFjEDjk7QyjDdHGGKT4JXZg/cGAHgJ6XgFGwEYgbwBsA/0wPEeCXprH4C9AHkDYC+MscEditwQ0tyhZQBwQN4AAAAcEMgbAACAAwJ5AwAAcEAgbwAAAA4I5A0AAMABWSFvXX7JxL3bVGxTvp3P/eej2ZQTAAAAYLNc3pprkl0jvfrSfESUt6Z8O5dfkTIDAADw0jDy1t0Fo2HVdbPrNvMj8tbdRXbJY5kMAADgFaDkrbkmGaNhkaXih7y36polWZYiCgoAAP8Npry194tDCdr7Jbma177rYtpIMwVG2WN7K+1MGXlzpeo+i6ms83vdWQZol4zniud3AgAA2DWavFXXLHE5Z01qKx/vM33XhXKp+yxsrSLkzZmq+aBl0mPJmNldZJktzwAAAI7HJG9dfsk8Z0bIQyVNyZx+7D4L3YUi5MeWN1eq77p4K+pv1ryQoyVNmmXJ5Y4fzgMAgGMT7r3x7wN09TsREmw+rIBhgLy5Un2VvOsm4b0BAACYCd57CzlU0tXvs8KFHBuh5Y1L9VWe13tvjvMyAAAADkfoycnqGuL3aKFFfReNxLv3ZmSvyid9lZRGnJwEAID/jcD33qhDJVJK69SioT3mmcYxtPhVWhFIJerIpZJSC4S6i5sv4b03AAD4/wj61ZL2fsFxDAAAAC9EiLzF+JFJAAAA4AfB/zEAAADAAfkHtBjwIUmgZP8AAAAASUVORK5CYII=" alt="" />

上边先去执行findOrdersUserLazyLoading,当需要去查询用户的时候再去执行findUserById,通过resultMap的定义将延迟加载执行配置起来。

3.3     延迟加载resultMap

使用association中的select指定延迟加载去执行的statement的id。

<!-- 延迟加载的resultMap -->
<resultMap type="cn.itcast.mybatis.po.Orders" id="OrdersUserLazyLoadingResultMap">
<!--对订单信息进行映射配置 -->
<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"/>
<!-- 实现对用户信息进行延迟加载
select:指定延迟加载需要执行的statement的id(是根据user_id查询用户信息的statement)
要使用userMapper.xml中findUserById完成根据用户id(user_id)用户信息的查询,如果findUserById不在本mapper中需要前边加namespace
column:订单信息中关联用户信息查询的列,是user_id
关联查询的sql理解为:
SELECT orders.*,
(SELECT username FROM USER WHERE orders.user_id = user.id)username,
(SELECT sex FROM USER WHERE orders.user_id = user.id)sex
FROM orders
-->
<association property="user" javaType="cn.itcast.mybatis.po.User"
select="cn.itcast.mybatis.mapper.UserMapper.findUserById" column="user_id">
<!-- 实现对用户信息进行延迟加载 --> </association> </resultMap>

3.4    mapper.java

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAk4AAAA3CAIAAAB1iVKCAAALcUlEQVR4nO2dvWpbSRTHZx9g67yGCyNwladQaYxgcb2FwVUwGALqjIrF2wvURLgJch8IxC4WNSYuXAXMEtjODxBvca905+OcM2fmzpXkq/+PUzh35s63zn++pJhXAAAAoNeYbRcAAAAA6BZIHQAAgJ4DqQMAANBzIHUAAAB6DqQOAABAz4HUAQAA6DmQOgAAAD0HUgcAAKDnQOoAAAD0HI3U/Tv76+SPL/8mBgEAAAA7gULqvv/9/uLvr4lB7y9O5IdkhGiQHC3vCRnERWtTr1QKJtUmL33toqGhKcu2jukVhkstYwhVf2+yzQEAGyMudV8/ses2O4h0ZKEbsv+Iuqqoc0wVp/B1L+XQ3xWsVzQRufBJFMxLaPOkvORpR9gRXIFJ2QtTI+vClVlIFgDQA2JS99/nPy4+zP5LCOI0I4yjeciFZrhyIVnNW+3rxfniLqpWKq9QeASZF8rAJaJ5S1NHfTWVrwAA+kRE6n58+fD+0z/6oND9cbNyYVpNonRS3EKB87CegEV9Ypt66eXnlaIjqZNfV04CNNrMtVjqEy6IU+WwOkKBU6cUAIA3gSx1/3y8OPn4XRVESogXxC0FSL3x8tMsEQQ/JTwXSl6wXvoyl5K69nl59eLSURY4qTBce6YWiZQ6rnhkLQAAPUCUuvQLKXp3JkjCK+V3NG6RfFHzPJpCkXopy1xK6orkpck0ddoRTccrgCxjZCFlqSPLGY4EAEBvEKQu5zsGeonifI0+Hdm9ChH00crWSy8/mvLITrlUXkJDcWmGz5V9Yb+llzGuXnJq3JCD1AHQS3ipS7+Q8rrBVZ0yKBpHk/VruVWd3tfLVdBIXZG8lG2rySuaqR26AanzygmpA6DHsFL39dMJdyFFCIpKVJLUcb4saZVAphYGyf6uSL2E6sh5kWgEo31egk6nlkqQGTtCntS9MtWUU8treQDAm4OTuoQLKTaaZYStLuG02otmP+HqkOf0vTLYEUj32r5eGvkponMF89LrShhTMxsQstMoYjT9qNRpeh8A8Nahpe7Hlw/v//r8IzFIg2a2Hg1tE0RGJrWWS1POKMkFy3+3oQupS9IeUmNkLdEojT6OF9+bfAi1gNQB0D9Iqcu8kCKbUAg5QjQFTr0El8qtycJkS9VLKKRmuZNEwbySlmhhy5BzCLINi8chK6ushdAgAIC3CP5nAwAAAD0HUgcAAKDnmJ8vv2DF7WHneff7b+9+/23rDQWDwWAbMEhdJ7ZtIYsDqYPBYPtjkLpObNtCFgdSB4PB9scgdZ3YtoUsDqQOthc2PzWjhf1kNjKH46ftFwy2WdtLqZufGtPtcC8lSNdDY4bXpVKzaS91s5FZ4zRmu+adjYznm1pa8QRh7Y3olC4+lfNTY44ul+7D5dWhMcfz7TfCPlr3vpezglL3vBgML8zZYkmEPo7PLsywtsHNI9EEEzYo1ZZXh+H4btnc81NjTmfq+JZSrchSrJ2VurvxEdsgZaVuftq0YZZidSh1odOMjr222XWW+Gbz2ojULY65BNmP8/3UDC9G9+5DybPtitkfk3D2uemS8K4SUldH2IzUFe+/Jt86zsPDw+35gSVT18MstetW6g7+zG6o7vTDTtkV1MVxltpB6nYwrw0stWcjYwZXd3To0+WAKkA14X6rUpcwF9+Lkri2IamrbXkzKaVngm1F6tzZiid0Dw+V9B2c36YJUterumoTMn0zh/EUJaxxgoWEBFK3g3l1L3WLY3lgk59oSF2fSuIaKXVV106+VR1v7G72ev1+aoYXZvLNDprfTPy3VkZJXWzBV2VR22T8HK+V8Cm1lvnhx+BufGRtANS95T6kNweqOHaClEZdD81K666H5uD81trfdKLa255eGLcjKiZ4e34QJrfewKwKr91SCPZJ7LYSmre6C2Ad77kfBi/ZygkSnxlrS2p+agZXd9VSL8yRTDAM8p7zCZJjIyp19FvZxZDlx07QWs2EA7hOMCy8fbIl5uWk6a2cmGJInZI7bNiq0YPHM0cLHS+0tlrzVp5tHPrD+sXpvEnB9lHfRsPQuX0brX3m2p4XAy9CY1PNTJSr7/Lq0OmIp8uB14zVk5rw0D0colynRFyl3vdawybiN1LclyB1nrl6xkod+da63ROlbrlWzUJSR41y1WeDD52NTHj0TS3hrGe1JNX/sleA3mrQVkw3iNgfJRPkFobOWV31eUiYZcurOqJ568Fav+IconjHfuv5/t34KNiAerocWFJnmpa3E+ESDILcWvAJyn6ElTp+zGQWQxjYy6vDpjvYnV7v8qG3xeestPi8ZiPjF36dCF8MoVMKDJv5qQmnJuzuZTCWVFLn2spT1VI3mlihlXtk/eHj+CxYBjRnhJ7OpUgdo/pWuwVH7OxQEYao2ymBK4hMMrhepkeUMACscraXOrenp/NfKqkj3lqZsIFJBdW97u8nxCxf6vgdD7r/wilSbQqps4KbEF+XrH8HSdpx2QTZU8LgWsri2AhnG1TFU6XOnRjaw9eOnCJ1Vi83nc4m6Hk3v1vZBPmxEZc6ckTlFkO9qUhuDxLtKSzjuLxS9mw1vZw7bLwgv0lTpW7VIMIG5to72U7PX8xVLmsyfq6Taub69e7UdF7nsv5jMn6uvJ+dQrDsi5ksMFWvjfz7qHwrSUOUujhmZZ0qdeKIEgZAqglS5y/SJ+Nn1QYm8da6DklSl7tFnid1q0YnFvJi/7GrOmoDs37EHcEFr3nvBESWbnayxl73bWVVRw7ZYKA7UkdtYNaR1Sstz+EGxJZuwtiI+n16ROUWQxrYzjaUNRG236Xnas18335Fkjrvud3dTDGkTskaNqVXdbWpzuooqQt9WpBU4w+XNxMznM5Xqja4eVw9sbLz1ogx010mkJvX6wtuiFJSZw2JHKljR9SGpc6aj7hB7gREeGtdqwyp29Sqzk+Bn3cHRpzVhVpnL7xYZRJWdaKaKa+v3J4frArRSF3O9d9NrOoih0lsjwgLCLHflcfpztgIEhQFmH1LWQx2YLu7iIRHWBwLp9f10aAbIWdVJxSj/KrOOxlKO4/geiFX6oiDFWFV93I/NcPJ+GZa32yoTgEJSUtY4cUnakeXc2rCQU8IpCHav1UduTcdPcajd7TDDWjxhG/V6/OJH6SRvfZSF874ol879W5g+huH7g4jr0xWvNVajD6ry5I6a2ezyxuY6TtR9edttSZwTgWcLxu4p9z8OptJMPZ1QM3NMWdsuM5CaBbnrcxiyFLnnfbxm3vhu8cj/ydF0s7qyGMbtxhCp2QNm6fLgTxuW9zA5K6lJEld1IsOziaDm8cmWp0g4So1V9Yjw0bY9qfHhjBE3U4Jzs8irlJ3VkdvUxNSV894FPqnkzpHYJorkZPxfX1XM/ZWptS9BDdTtFLn4h1yUvs83iQx7H47Au043O/VPfD3JUVlal46OL+9PT+wI7p3KT0lpRP0XnE2MPO/V0f7dKF5xSHb7JYcjp+8nTQ7TdX6KZagf0/Mcc3CLRJ2bDi15jMij9OTiiEMbCdocDWzqkzci6Oche+bhLz4KgvFEDolc9iEl4GDHwBL/l6d56laSd0v37mF/nB0/zPYAvVdpfKrWdxXyP15zy9/dut2tH/eyXWKhXyd0pkU8v3Fjaj4qq4uf3ySqjqrg6VafH21bfAbmLDKFMdaO2iKfbCcX0uBxW3HfmmPvRvoGaSuE9u2kMWB1MF+vrzZH4QMin03PiJ+7pK8BPtGq7wztltSp75qAKnrxLYtZHEgdXtu612mt+r0/S07fvM52NjE/2zQxnZG6upDX+UA3sv/2aB727aQxYHUwWCw/THzCgAAAPQaSB0AAICeA6kDAADQcyB1AAAAeg6kDgAAQM+B1AEAAOg5kDoAAAA9B1IHAACg50DqAAAA9BxIHQAAgJ4DqQMAANBz/gdYx8WnSg704AAAAABJRU5ErkJggg==" alt="" />

3.5     测试

3.5.1           测试思路:

1、执行上边mapper方法(findOrdersUserLazyLoading),内部去调用cn.itcast.mybatis.mapper.OrdersMapperCustom中的findOrdersUserLazyLoading只查询orders信息(单表)。

2、在程序中去遍历上一步骤查询出的List<Orders>,当我们调用Orders中的getUser方法时,开始进行延迟加载。

3、延迟加载,去调用UserMapper.xml中findUserbyId这个方法获取用户信息。

  3.5.2 测试代码

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAzUAAAFBCAIAAADBohZFAAAgAElEQVR4nO2dP4vcSLf/dV/Aje8bMYZVMtnzDhwug8H0K9jUzLJg2Gx7gwHDxs8ks+DA1x17wIExGEeepBM7sPdhDTfY37PJL7h9A6nV9eecUyW1ulXq/nwomGlVqepUqVT17VMldbUBAAAAgJKopjYAAAAAADzQZwAAAABlgT4DAAAAKAv0GQAAAEBZoM8AAAAAykLUZ19vri+f3H3tGQUAAAAAIyDps/vnF1fP34jJ9aiLq0v7oJggGWUnG3ZEjNKS7VOvvoyY1T5l5dcuafCBGqrJrcswKCUIfQ2ITznmdQEAANiI+uzNreohc6PiiVCcF91/knOnnWbTX1HFpwc5xxPwiPVKZmIb34sRyzLavG9Z9vXKaeTgYiULGtBhNHuMbAEAAA5KpM++vXxy9fTmm5RWidKETpwm56AWO0B/GNnmnLV/vTRxcIiqjVVWrIQMbWrYYGfVy2Yt53wbtCixnXtJOgAAgEMQ6rPPd08vbt+LScWoeK7VJlfDOSGSOWsG/yeFTqC6kpP0PvXK10wbiQPpM/v0TOWaIyiTRQ+2ua8+E+3MlKRi1QAAAA5KoM/eP7u6fHYvpgyjRN0TRNnOkmBeDMozvB05E6dx3LB8xHrl2zyWPtu/rKBeWj45BgdtJWaVY7P4f1xQL7NFfSZWDVkGAACT4Ouz/k8G5AsCQ8dspInQmCn7aoX4eDKHUeqVafNY+myUsnIKTeoqtx3inHu1j5tzLMIM+40eJRom1iXuLQAAAEfA1WdDXquRr6u0yS8/n6QmsENOsnHrla+ZcuyxVcJYZRkNpeVplKWV2MtmNys7gZ2Prc/i4+IRAACAI+Dos/5PBmyO6D/LjEqmySl6M57/LCm8kqa6WYnJxi0rs23zy7JFVU4+mVnFUQP0WWAD+gwAACZhp8/e3F5qTwYYUUld1UufGQ4VO4g2aMKry9BIOUq9jOrYZYkk9dkoZRnisq9Vmh7qZbN4mTL1mZatnduwqwMAADAinT7r8WSAS44TxZVEsXMiSOYe0YweplQCG9wEma6dvvXK1x9J8nXVnmXlC504ZY426mtzkL92RZISMFNGu6XYOQMAAByOVp99vnt6cf3ys5TCiMohx+eRjN0nylAGA3RSnL6XJrD/34dD6LNeYshoUlfIDrM5R5H3Ve2xqjZqij4DAIBj0uizgU8G2MEo1U6QzEGTXNophvcrznasehlG2mkGMGJZhlcpPh63TI6MM+SUYbN2LXqlETPPrGlsLQAAwIEQfx8dAAAAACYDfQYAAABQFugzAAAAgLJAnwEAAACUBfoMAAAAoCzQZwAAAABl4emzD7892fLbh6ksAgAAADhvOn32x6sfHVX24bf2wx+vfnwS8+OrP/YrtssfAAAAAHxafRbrpQ+/+Srsj1c/7i/L3NzRZwAAAAASjT4LxVh7zFVQ6DMAAACAo1BtGun124eNu//sx1d/BJpN02fOnrVAcflLo22cuF46nu4DAAAAmD3VpvOUbX1a7d8MfebvWVN2sIngPwMAAABQqDabP179+OOrPzo9thVi6fXN6JCruj78Zj0Fij4DAAAAUOj0WSe2HDdaQp+5S5vSGqezlhl63tBnAAAAAArV9uEAx20muc80fZYlsv549eMT3dMGAAAAAA679c3W2/Xjqw/NP4F8Su8/M4hOzj4TAAAA4Nxwng+wUZ7fDJ/H3GYUHI/PdBPw/CYAAABAh/d+DQAAAACYnO79tI4T649Xv+HQAgAAAJiI7vc33YcxWW8EAAAAmIwqnQQAAAAAjgj6DAAAAKAs0GcAAAAAZYE+AwAAACgL9BkAHJjVolqsggP1cj2VOQAA5YM+O1FWi6oaPgWuFlUwoY5gzqgZwv4IF2W/bqMXE2W5Xtb0iAI5RAfQWS/rqjpmgQBzYh999uWufnRV/XAn3Vrflj9cVY/aUL/4FqdY/apGHZO0Ge9uq0dX1a/3WbkdS9esFpVPOMKNq8/c4gbV74D6LJ7p18v6cCP+QTM/bllH0WeiOtOKT/Lutnp0tXjnH7QGolJI3rBHtURv9mPqM71rAMBmQn3WJphan2WYUaw+O6D3wc3e1z+rxSCJhj4rsKwjODXNKbi/D635NjVXfVaGu7AYS455JwHMkUPps5b1i+sCRNh+nLc+G0n9oM8KLOvwM3WqhL4WoM/2pxhL0GcANo0+awa4X++b4a9yB7tg7HPFyjZq9eI6PGuLpM9SrrWmiDZcL7/YFWhzc4bs4Mj94pFYnG2GF5uhz7YbKfQlDH2J0D+3jUtkaAyyTkHx4lW9XKvxwRJME6msgbWWtNu8d2d6ScUM7dYwMxQbKqnP5LMGm2HPKm6GTqr4arqXOWq07ZlmWV6eQSrFjDDKrdjQbqNWbZMjBXLFQnQ/PnLu8e1AtIyHr/bE29UuB3dIEQeH+0V8v3+5q4MEu3CbI3a0ijbNF/ZWtdfnDCna9coYUuQOYBiRGFJM0GcANq4+eyQpkqQ+E8/a0lefrTupl6vPIv+Wa7BloWFGMP7m6LMWZRT2Z+F4wdDeDjLMf6ZtLuqOektPgU7oTpbGUOdYm2P7yc1EyzCjNeQM7RlO1Wd6Qw00w5hV1svar7F26dzzgxVAz169LD/39bL2r6VihnFRjGO53SaqccYEnDtHZ+gzP2zv6FafLX51YhODw7flD9FXzd2+t3hwyNZniop1mjTqy2ovMnqvf73ELI2hQ+sAcmcz+kaSYhx5AIXi6zN/vLtdbbL0mXDWFmN9U4pqx75w/SJB9xV5s/FXQFp3YCetWs9cwsJWI4pVTiEPOdEk5CazN3TlPh8Qj4rKOBtMC87AKo7hGfoscBM1H9UMM1pDzFBvqLQ+Uye4IWZkf+sXL51wtuEw08rqs6Sbc5Vtq/VuE0SFRoyoz7ZlG+ub3V3s3bCB26wZYa6XX6zBYfWr+8/18kszJrg55A4IO8tNMdJc0EUob/TWsXpv4jL31WdmZ+uXt5sMbQaQwtVn4aLA9fJL1vqmcNaWfvps6D4SJ6v7hZNDNJpnWRietb8+i747B6OTs3ggPYY5qv9MHEz179jSFm5jKvBqpMwRZmtkTGNhQyXFity8Q82wFEW0ghTksV7WpnwP4y19Jqg8z00Wm5HlSemnz47mP9uWnbP/TNJn8RBkDA7rF9fVo9vVVorVL75tjzjFBd64pOWpG1b6IqGfZPVeSZ9pHtoMQ83ONkyfdfmi0QAMRH3m+pm8KP+7o3HWliH6rLf/bLOTZe9u3TyH+c/8N25sv3/vq8+yBiJ/nco6dVx9ZnzltjdIqWYY3+FN0zObKlpjiSxUVWN64dOOVBVFePEksxQpsuq2u/kJhvjPDDPG958FSjAjs7jmfeboofpM2CZhDQ7vbqtH18sXt+3m2mZnm6DDevjS0l886uVKEtD9301Svv8sygYABPT9Z61ASW5Nk7d96Fu4xAx9j5ewxSRFswBROwudQ+rVmOE9oNBv/5nynTD7q2I0ZGlnjqzP3JlgO+fKbhF/yrC/4CsZWq2RO8B7DeXbZGTvnTXQDFufee1krf3F5y4W4Uv2++0/c5aPNTOMi2LUXO82sj/Qzq1XfJT+V2lwGKTPkoND/cN1/eLbLlmboTCy5TyfnuhRxoaBnN5mFBVpvMRgpHQAubOhzwAOiKLPPFW00yvXy3ftk56pswbqs80mfEQg15cW7EGJjoe5mWY4Nlwvv0jPc6m4HoVwL47kagiOx+OVnGGvlY+swXR3Xr1cBxOvm2eWpyqVodYaRoZ2Q3m11gsKzhpghvAUnK/4uoMrp8rxSUH2TYKwSKMsvcqGGcZFGdht4tP8OugeoE1SKYh4A8te+myjDw7eRthghTQc2TJfHhQ1lPeETXSv+cJevP5q7w2KUr4uhhkaHSCM1QUZ+gxgROT9ZwBwTOY5V2WshQ1co4PhzKVd59nnAY4H+gxgama6VToyW16Ok3a+z7XKc2Au+sx2rgIA+gxgMrqVplnMpwLhqpi+Nh151ZiZD8Rs9Nmu/9MXAAT2+X0nAAAAABgf9BkAAABAWaDPAAAAAMoCfQYAAABQFugzAABwWIWvSuZ5DoDjMx995jwpNv3DSatFuQ8d0VAHZfWxql43oYDm/VhVr+vl31PbARNxiPtLfO3Fvu9D+Xpzffnk7mvPKICzZhp9lvjZPgv54fE9MhzEDGQHDXVQ/lxI+my9fNept2MIuBH1maM7mzBCtquPVfVxchF7TOZ/fx3mfcL3zy+unr/Jjrq4uowTigeN425U84+RQxy0PLVCk6cA9GUCfSa+rrLX2ebPw0EDDXVQBH22WryesRw5hJY6M312AvfX6L/H1fDmVvWQxVGaluqOd/opKaoCfRb84+ajJdMIEvSVdwA5HF+f7fnS6Fh28BZqERrqoMT67M/FrJca0Wf7cgL319i/Z9/w7eWTq6c34s+URlGusjG8X0YyO42YQPvHkFx25ugzGIXj6zP5l6B3JH7dNx4h+mQonSnGqVHm7i7vLP+nrOvlesDGMMNCGmp//OVIX0kE632LP/1TY33297KOMtEy9HMzzFCjzG1w3ln1J6d5X9fLv1cLLcM8450MnYq/dldFg3XeeMFUs3Cz+ljVn9abPxdB7daf6qCmq49V9S5HDg3sbMrtoJ81//srLb+sXROaNv189/Ti9n1OlOEz26TEU6yi4v+DNLEvLemKi9NoZuBFg/2ZZP9ZNz6Ed3TgQJcGA3GAyMzQ/2QMRoPGKX91w/spwta+NjL7e7ZuBg0lVcohp311RbJevnOjVoscfdYerKrXsW7wM/x7WTsZGsIo7X9KLrP+vax3AqhVZm3RvsPPKGv9qd5V/8+Fpy+Dj1n2GxZuhWDbgG67rRah1lTL9crK7GxenzduB7OLzvv+yvjBcjmJqc/eP7u6fHYv5iZEifpGVGnuKcE/XT5BhskTjfXNTP9Z0mkHkM+Ez2923/G6+zoca7Jlh5ZhNJq4Zxu7RdIbSSIz4r0ZTuFB6txVAtUMGmoMVh+VLfyh6MnWZw2dP6lTaX8va3/p0xUuqhlmlGZG7Gdaf6q3lgQV8T6Gzweorin3rPXyXeROC+yP9JlpYegV06Lc4wZ9Opvz2bodMrroXO+vwfrMYo8nAzR9ltx/Zq+HdkeS+8+MHGItiP8MRmfy92s4X++ikaWn7IgyFD0r4YBkfeHVfTHisBgk3KUZLjtEM2iosVh/quPVt0hA9NRnDa5baLdaJy9WimYko0QzBOGyS5PSZ5qvzlvBdNdnE04sVZ+pFibN2K2fZjjPenU2x51k3Q7ZXXR+99cB9Fnv12rss/8sJysxgSGtbAEX5GZoOIABTK7PXLGxp1sonaF9jjzuyFFHdwtFyxQ0lJsqpO8+7fWneieA9vSfbbPcrc2lE0tm5ESN6z8ThZG//uifFaw5hgz0n5nb4NrdaVk7z4b6z6x+l99F53d/Dd1/ptLnyYCGXvrM9lfl67PkEbFo90iOgAPoy+T6zPPgOxsitl8be8sOL8PsJ8KN74ViVN62D7de+7qFPDNoqLHxliAd2bF1HfXWZ97GrGBDW6YZGVF5+88Ud1cPfRYsg3YfDUG5kaRYysLUlru/l/XrxeKj6DxrdLrgO8rqbN5mLON2yO6ic7y/UjecEt+OQVHMm9tL7ckALcoVXvHBjS6YtKzij+I/htQT8zH8Z6xswlhM834N3dOxi22fM/I2aagLDobrJHhjpD9iymcZUboZUaw+DmbKDsMMGmp/gmcMfZGxW5FsH3h0JU6wUulstzfe7xo+0uhJN/ksI0o3I4rVBFn++qazxlrVn1bB2qIba9Zatd/NLfVIRJOh2Cn8ze/RcbsTRudpt4PeRU/h/vJUaoguMmWB1u/JgIYcH5jmPLN11SaSVjkrkoYac/+P80Siwf5M7j+zOKL7ZN7QUAcl81FBOAKJJxL6wF0joSs0q72Ed4t8vnt6cf3ys5TaiMrUZwP8Z8G5opfLOJKj5JL6D6AX6LNTgIY6KOizUlAWTIfBXSMjPjRqL9CuFpG/cPgPbmr79EX108t/Jh438jHUof1RqxpAL9BnpwANdVDQZ5PTrZOO2M25azTWyzpe9zR2xUmrygCwL0XrMwAAAIAzBH0GAAAAUBboMwAAAICyQJ8BAAAAlAX6DAAAToXVgqcVoED0h2xU5qrPePbqzKEDQBbOq1qn7y/CeyhgVMwX7O6V6/S9B2ZO9q+IdEykz9z3Ww/q94e8YYJBVHj1Yhl4bxcfwb5ZDUJ0gDPvAD2R6xa8oP/glS9cn8mNNJfbYaOqM6abETjB0ebb8oer6lEb6hfi78SOTM9aT6DPfBEpvgwxzQEvbtsPt3dM8LEUwnZbLfZujgJumHzoAGfeAXqS/J1KUDrAPG6HzUZRZ0w3Y3Cao80E+qynD+3o+iw2z/hFYJ0D3zCL5bJubFov68VqwMLxYTmIF7+AGyYfOsCZd4Ce9PypyfNE1Wel3w6bzUa2nulmDE58tFm/uD6ePutX8aPrM+V7bHv1256580d7SY0fNNY82GaG/uqG+3vFi9V6WS9W7f0SbOxzy/IPtz9VHhVlRA0y3rpf7J9AFqsc/nJzWDM/QRexHVnag9rPU0vIGVpVjhqKDjDnDjAM+Xrt6qlGSuNOaiFJXxQzzFCjzG1w2u2Q6DY68QX1+mJ01OoAM7gdurOi9mG6GaF5T2C0eXfb+cmqR9fLL16kpM8811r16Kr69d6JvV+4UY9uV1lRSiN5tQ7a+dj6TPr24hxrG90ZGbyL6g8y3uDSRQn+bDFDVca2P26yXtbdbePcMO0RJ3c3v0q214gaYrzpIrVuGFu5K7G+a3u9rLcWdR1q17OyvhqoGRpVpgOcTgcI5r1oeO5p3sbsG+bJnSXSkGRdFKWK6dorekG5Hfxuk+vFiHueUpOoG4n2l387dEnFxU2mm7Mebbbya199tksQKDBXhBlRbnmiC3cu+syJ3sWEV8L5HGXpplUzDDuCd3q9XG8262Vd183dofaDsCjFRD1qkPF73TB6h1ZHZ/+oZ0ZgT8YNY2RoVJkOsDmVDjAY1Xij4c1jLd3Xde+runlRlKzs5hXNMG8H2zmRV4ZbF7NeWgHl3w5y3bSDTDfnNdq0mmnxTk2RXt9s3G+tC20rwjyP2iYVJVUpzRT6TPoCqfQs9bTgnIjUtxYn2/AbdPftpf1mE+TinGMX5XR3PWqQ8YNvGK3KRnFCX9qmG67PlAz7VJkOMNcOsA+i8VluoKRhruPKvCiaGcko0Qzzdhimz3T/Wapepj4r93bo7BD1GdPNWY82X+7qR1fVD3eGHJL1mbck6quuJs8uuJkbUVYlNQp4PsCV7VnfHILP5kXqM6Tterc06C5WQbow+0FfaIYZH5phnNQjj+N8oUn7z+gASePn3AHESSJzuJKNNxrerlucZcZFUc3IiRL1mXo77KHP8vWXZV17sPTbQY9lutns37yzHm22gqmf/8xzmEUfdwzypfX4EjvB+zW8b3Te7WJZ7qTbjj/eVwylvrlNsRsUTZe4X1Qz0cg3jFcvI2qg8X7Rm82me+DZzbCdCeU8oooqpvjXy0k01H2iZmhmQAeIoubaAcbAM97oG24lTMO8WpouA9WMjCjBDON2SE5+zfX1S9n5YWSbjHpJ0fO4HfRoppvzGW2k22GzWf0a7iTbarV4u9hWTsXOs3h9M2trmrBsqrRz28/8mGneT+t+g46+3Gj9e3dS3ewRdBKGXuCM+T44Rd974h9zT6uXK8eMwC0Q9xu5yoOMj3MNhvHuqNtQWpVFS9xYuaQ9pmfNdDrAmXSAAZjGe30jdDME+LOJ1hraRTHMMKJ0M6JYXZBp+kxUfFpZameLYjMERFG3QyC+5OKYbk54tFEFYvCIQFqfearuevnurtb1maPAjCiv0mIzSwJtrr/vVCCJrx9H8SrAhNABCuG8WzuqfbYz8MB2ZEXtX2bfpfKZwmgzS6xr0wg09Nlh4IY5c+gAhXDWrR2pMWv30CGZ5nbwl8dOGEab+WF/U1otYi8j+mw0uGHOHDpAIZx7a4frm9O0xVS3g7X/7oRgtJkdK/V3IcS9Z5sN+gwAAACgNNBnAAAAAGWBPgMAAAAoC/QZAAAAQFmgzwAAAADKYnJ99vXm+vLJ3deeUQAAAAAny9T67P75xdXzNz2jLq4u7YNigmSUncw+YmebWeie9oxYHAAAAEzIxPrsza3qIXOjLq4u7dAlM9J3OTf/22k2GfLLSJ80W22RvOIGy0GkGwAAQPlMqs++vXxy9fQm+oUqI6qTVhtdauRoKTs2R1cZIi/Wi/sYk29PphZEogEAABTOlPrs893Ti9v3+VGin0xMEwuUvvqs1/9GtgP8Z/kLqWPpPwAAACiKCfXZ+2dXl8/us6JE31UQpTmuApdbjkspqavi/w0fW0zf9cdMnZcvBJFoAAAAJTOdPuv/ZECOQAn+2fj6LI4Vj0zoP9P0WS8bkrahzwAAAEpmKn025LUa+brKXt/c339mlDWJ/8xIkOMvBAAAgKKYSJ/1fzJgc0T/WU7UMf1nAxLYydBnAAAAJTONPntze6k9GWBE9fKfBQfzFVumLyrHf2Ybr5HvzOulUAdYAgAAAJMwiT7r8WSAS4466bRXkCZWYMGJmq1JvWVkFRStnZJZYjJWXF1lcRMAAGB2TKDPPt89vbh++blnVA6GADrc+qYhGUWFtOf6oxgVyNDMdgAAAIAyOb4+G/hkQP4an3iuHXsI/5mxZmpkm6RvZZPtAwAAAKUx9e9vAgAAAIAP+gwAAACgLNBnAAAAAGWBPgMAAAAoC/QZAAAAQFmgzwAAAPqzWlSLVXCgXq6nMgdOjCL12WpRVfPo5atFFdyf07NaVFtk0+bTvMMo8aJAT5xe7PfV/Xrv6H2DzlYgwkU5xKC3WghZrpc1PQJGYgp9tl7W9p0y4F4aNky6k8CgW6rg0Vk37WjNOxGHNDZou/WyHtp1Dktj2D5d2+e4HcCa48bVZyWPAHErJEfOfYs71re2A5d1FH0mqjOteIAhFKnPBpBzS6yXtZPGH/1Wi0ED9GHvxL0aalTTZjXiHHrK3A3LwcdSCDvzarF3cxy3AxyuNDfn0kcA9NlQjtBbdXW2wYcGY3E2+kxyfOw/9h16IGi+3k//xR591rBe1tViuaybjrJe1otVcRtOzJljn0yP1gEOOL3t6lH+CIA+G8rhe2uqhFkNmFAshekzc++Ut2azjfcPShtWxFUoxQPentjOuTtronNjQ6Ko4LieoVivILb/YCaNEIdp3nHxSnRLKuGiNC7Y9bJerFp5FmwIVrZNNYnE5jeiBhlvybOgTwQfh3UA+XpthWx7sDUzNWMFF1GomdhGfdqwiyx/BEjpM2vcGGCGrZmUjh13D7ffRI3mOp5t75NQlmFGGOVWbGi3Uau2yZFfcoqhgzmcKYXpsxZNW+i3RM/dVpIJzrH2lm0/uUNNMOzoyyXC4omYYfbKbN/vY0a+YzavcUJIxrDkLzKtl7VzVgkXpV0iXy/rTqU5+qw9IlTF1ydRUUrUEONN35OlzwZ1APV6dRPRbkbK70O2/0zbXNQd9RSq1jdmMALY+kxvzoFmGMOy3rFdAk9y8EXBs1cvyxoBdDOMi2Icy+02UY0z3H9yEvQZ9GJe+qzXoL0xdE3G6Bx8SWw+hsU4n6Ms3bRqhvn7XkSdmUjfU5/1bd6xSU9IU1+U7RS0XtZ13UwWatOERSkm6lGDjN9Ln/XsAMb1Euw5sD6T66W27gxGgPTtoMq6IWZkrzmqfUFwaCmZa2X1WdLNuofMY8bt4EeFRgzWZwC9mI8+23ge5/D8Af4z427N/kYbnBOR5yQz6uUmOKj/zDbjePpMGOMLuiidi6B1pAW5REsilj5zlIAcNcj4wfpMq7JRnHG9CtFnet+YwQiQFCvy9RpqhjUsqx3biZe/Hoe3i12WPQJoZlgXxTpm3A4H8p8B9GJW+szLQf+OKCePRzr/iPttL8snEnw2Lcicm+J6bfo7ztJFjty8WhEhyToMXNA54kVZxQ8DdFNP2Gp7+8+GGS/2IfmkHnmcnP9sDiNAdI6pGtMLn3akOixbHXt7QO9w7dK2n2CI/8wwY3z/WaAEMzKLa36Eb7Rw4sxTn8VZ2EP6RlA5/pci3+9ve+PczRtVcEsPVERavRqZM+g+30OfDWjekfAvSrx1ZuKLYi6KxdZq+szrbEbUQOOjTtO9X8PNsFXQch65HUC9Xhn6rDEgb5ZO1NyYaI2+Uf4I4NtkZO+dNdAMW58pHTs1mq+XdbVYhC/ZT6xayiNA6v5SLopRc73byP5AO7ec+NY4hBvkMZU+kz0rgtdF+UKjbb20PDXRTecWl/U91T+pbnY/OwnDmmVoC6teg3zkRhsetnlHwjMy9aU4PumgF8XUZ2EbrRwzgpaPZYoYNcx4sxWd44uV21CDO4BcUrY+U2ex6HiiY6t+QatvlD4C6BfSPmtIt9GHZaNjxycF2QtrF3ZZxgigm2FclIHdJj7Nr4MvnaWmFJsZgQZ9KPL3nQBOi32cmQDzZZ77sKKbUlBcukKzbmlZrwKIoM8ADg76DM6RY+2LGJnIbHlTp78Wq50bnzI/vQoTgT4DODjoMzgruqXIuXbtcH1TX5uOvGqK/GJpE3qDPgMAAAAoC/QZAAAAQFmgzwAAAADKAn0GAAAAUBboMwAAAICyQJ8BAAAAlAX6DAAAAKAs0GcAAAAAZYE+AwAAACgL9BkAAABAWaDPAAAAAMoCfQYAAABQFugzAAAAgLJAnwEAAACUBfoMAAAAoCzQZwAAAABlgT4DAAAAKAv0GQAAAEBZoM8AAAAAygJ9BgAAAFAW6DMAAACAskCfAQAAAJQF+gwAAACgLNBnAAAAAGUxuT77enN9+eTua88oAAAAgJNlan12//zi6vmbVNTF1WUQGR/pi5FDEKWlTCbLNHKf2okp928cAAAAmJCJ9Ww3O4kAABKuSURBVNmbW9VDFkQ1muPi6jIObhojBPnbIibI1k6QTJa0xygu/0T7IAAAAMyFSfXZt5dPrp7efOsRZauipKiys8pPKQomQwsauWUKSu2jWLotTAEAAKBwptRnn++eXty+7xWV9J+J/4vkCBetuLig/KIzPWd99ZmRGAAAAObFhPrs/bOry2f3WVGiMIrJXEx08zTcYEG2QRGxbZoZopGGGZr/TBSIsSU4zwAAAObOdPos78mAjhzt1cuXlu/lyvSWaZrJLrev/YY+MwoFAACAGTGVPuv9Wo3Ye2QvLB5anxkCsa8+s/1noiCLP9rBqCkAAACUxkT6bOiTAcf3n2lrl0ZBvfRZX5OS/rPYBgAAAJgX0+izN7eX2pMBWpTmObOXGsWPxsHMrPIVWFLP9fJ72Wup2nG0GgAAwLyYRJ/1eDKgQ3QLaf6zsfSZm2G85qjlEyuwzHLzl1xzysKRBgAAMFMm0Gef755eXL/83DMqR2doiqSvPksqm0wvV74xg6PcZd+NJCu1DAEAAKBYjq/PhvzgZnIX/EYSVeIGteR6YjJ9nCZIr9Vc03NiVsnjYm45RwAAAKBwpv79TQAAAADwQZ8BAAAAlAX6DAAAAKAs0GcAAAAAZYE+AwAAACiLk9Nnq0W1WE1tBByb1aKql+uprQAAABiH09Jnq0V1gGl6tajmq/kmM361qLbI5a8W1YhXa72szYqul3VVjVkgAADA4ZhQn325qx9dVW24HUFCKOrMEQrDlAr67CDlD9BndmWM2MMIdwAAgAMxlT7zxNko+kycgn2vymoxSKJNLXH2YmrjRy0/kZnqQ1sva+QZAADMiKn02bvb6tFV9av8I5xDkKbueL4eNFFPLXH2Ymrjj6nP1AToMwAAmBdH12erX123WRvqF9+28fcL+fi35Q+Nm63556p6dL384mQrTczCQcfL1m4p3y1/ekndVdEgTlswNTPc7n/qt87qneUqjJKMb2KNlcUwytyaJpblHxTawyoOfQYAAHOjKH0WLnpeOT62Vp8t3NN/uNtOueIELB10jrUqof3k+toCv5s75/tRwvKpmOEwL5K/HLte1o4kKcn43vrMiBq8w8yxJVZiUzsRAQAA+lHS+mYr3bqDTZp2a1rgNmvcbJ0Lbag+c6J3MeFs7nyOsnTTqhkO2vlmL84WbrxcRkaUXVZ/fdbITrQZAADMi/L02eJdd6DRZI0Ia/WZs+LpouozaX2zPaRN9tFpwTkReX4mZ4kua6lNqNJ8jBfLz4wyyhroP0u9ewMAAKAwytNnpv/M23PmnSvN3PG87HqJ1MnecEGZAiFzFc1fqLSTmf6zgo3Pyjdr3VR1+PUpjv1nAAAwL0rSZ+L+s63DLKHPlInZXy7z1/DsN3O5G7GcPCxXTO4up1y1IOw/86pSivFj7j+zy0o6wnh+EwAAToKi9NkmlGjKWqeI9gpS9fW0ljzYnVQv1+tl7SYMnyXM0EzBKflSwVuSVNxikxsv6jNhMdVdSlWiMstSYnn/GQAAnAin9PtOvCT+vLElJj0DAADmwynpsz2fNIQ5Yy99It0BAGBWnJY+a6ZpBNr50b5eV4ffRwcAgBlxavoMAAAAYO6gzwAAAADKAn0GAAAAUBboMwAAAICyQJ9BBvfPL27fuwfe3F4+ufs6lTkAAACnzVnps68315qqMKLOnvvnF1dPb4LfPf328snV5bPo/cIAAACwP+ekz+6fX1w9f5MRdXF1uZH+j7FjhyOaGkuiby+fxMppZN4/u1KUq9Gem80mr3HENPnt3wsjq6Nd8eB0rfpamMSkTHsyzYib+lA3EQDAnDkjfWYsyQVRmbN1F5UzifajGH325vby4vrlZzny6831ZbDu6dJXfLitp7VtkKaXjtFMio8P1ig55JRl/5/ThsbHXgaMEiWaHdTIPhcA4Nw4G31mSJkoKkefHXZGKUWfvX9mL2KaLrQcR5TtQbG9a0kd033M0YKZejHHwhwyy9L0mZ2zfYqmz5I6z5anRrMnzQMAgIBz0Wef755qnp4gKsfrkP+9//Pd0yCTndy5f747vjUgTn/RLS+m9Jl/ri+bpLLa49cvP2/eP4vN26RXMGMBlzORb6QG1Lw4mU6XHP0h5m8kCBLn1Gswgf2ZZeXLR7fpREEWZxKckvxoX6Z8nQcAAJuz0WeGH0iIypRixsTTJPh893Snb+6fu+rHi4oXCgf4z3QtZZXV6rY2Ez/l5vPdU31xc5ebtmosTrqa0t34s74hwkR5kaMFRfOCsrR8kgIohyDbHH2ZtEGUVvEpoj4Ts7VrZMSKZW3MKiDLAAA0zkOfZT8Z0JCjz2x/RsObW1d1uVImkjWBGQP1mahBzbKCZzNjh9zY+qyLyhRVtj4Ty+qlz2w7bYOHOX6MGmkJRDtt6SZ6s4bpMzGf5CWLP8btZotLAIBz5hz0We/XavR15ATHO3T/2W490Qn76bNtggt3STRZlrmC2VefGSIm6Y4yJntxUt/oAkVU0oY9Wlm2wUZZYspkTfMNjs/N1KCaPjMkVD62PhNLR58BAGicgT7r82TARl+AS0qK+EiwmcyRVsP23Udnaerq28snO4lmlmXvMOu//6zDnnST4iNHFmfqmEztYpNfVi99lhQoYtQAHSzqs2T6/csyssqpPgDA2XL6+sxfZMyKyvE6ZBz5enOtCqNgp1eI8vZX/20XxustPLeWVVZCgQ18flOctrUE4pFMfZZTYr5gynQgJaVnfnHiWZlaMKfEHC1o67MBZRmXKfkRAAAaTl6f9XsyoMHQZ7byCI+4T002wZFT4aOavtJyY90V2De3WbkFi7ZqWSkP2YD3n2UKWVt8uC4W0emyMfWNUXRMjpIwfELaKXZxOa2Uk2EgLuNYTTZpRWjXwr5kmTLazc22CgDgzDlxfWbsoDKijJmsjz6L9N8sfxOp3+8H9PX9aBiOnIPqM1t/iGqsV9X6nmKk1ASZGGvoISOZfW5SnwWq2mhV9BkAQMBp67MhP7hp6wljTgrPitTY57unwg9Zlo/4ZGhPrWlooHwZF/tdxAR2Gtu25PHY2mFiS6t7TvvYDZX62hA2o5ZnXH23vmI7awftbEWbAQDOnNPWZ1MTrm/ae+3LJX67r/FjWQAAALAn6DMAAACAskCfAQAAAJQF+gwAAACgLNBnAAAAAGWBPgOYOatFtVgFB+rleipzAABgf9BnMDGrRRXIC+jBalHFYmy9rGlUAIA5c9L6LJ6l1ssaz0JhzE+fiRZP09lEddbFzKtZAQBgB/oMJmZ+QqIYfaarM9EgAACYDegzmBj02ah29IgHAIBiOWt9tl7W1Y5oi7UY02693kXnTIDBRBl8PJoZh8Az3lUjtoVuveKq9a+y1YaZxgdnSmbE6XeVPn5nS8svOUVjCV9TAABK5oz1mT69+ef5n9q5Up2URSx9dkQzbAMV3ZE8zbewO0u3MLDWbYCBVR7kKIpy0AqOWneA/+wAVznDPScnQZ8BAJTPmeszcc6MZjV3cg22/OStYaX02ZHMGJl084oWhlLF+Ty0ymobWvh2uNmZZgg16E46amcbrM8AAKB8zlifbRNE3iLJmbSfqyYxvx/LjJERZn/HLM1Cyxu1R5XlNkyZL/vPTDM0S47e2dBnAAAnzEnrs3h+M0VDei0qFZlph5rHgc2wDQxJTuwDV/QM/9kYVfZXWVMJ8/VX0pKjd7ah+88AAKB8TlufBQtExjYtz9Ngbefae6tTK4WmMGN0rF1buoXORdlqJHn/WXxaTpUVt14o2tbLWs0usZ9PiT56Zxv4/Gbb6NN3HwAAUDlxfbYJXEPOnBS4T4IZPXxSL0N25FqxWLnS4LhmjI/WvKaFu5Pq5ToQSgOqbLfhRtPEsdMwx4woNnhoNSe3sa7ywPefIdAAAIrn9PUZgESkfWb5PlddoVnarhFoc6srAMA5gT6DsyRSY9n71gpDfDLU1pqrhehlBACAckCfwbkSrm/O1Z8U76Rr32urpJ1xVQEAzgb0GQAAAEBZVP/6638JhJMM/3jyz6OF//rP//iv//yPvhZW/80NSCAQCAQhMD0QTjb848k/j1YQ+oxAIBAIIwamB8LJBvQZgUAgEGYamB4IpxV+X1SPXzX/H1+f3TyuHvy8zj8RfUYgEAgEMTA9EPYOvy+qqp8usbNq+P73Yad/99OH9uME/rMPvzzoYzn6jEAgEAhiOP3p4e3P37kvURgy6wfh90VVLW6mrlcifPj0oHo9QmVzG6SnPku04avvh1ypV9/7Zkyzvtmne6DPCAQCgSCGE58ebh5X42upWeiz3z9W1cdyjTyAPrt5XFUPf3nrHJlo/9n6p4dVt8ZqB/QZgUAgEMRw2tND6FAZJ8xBn739+V318NPbqc0Y2oYD9JlwymTPB2T3EPQZgUAgEMRw2tPD+qeHiv8s3ifkb13yV0XbHIKl0gZP/znbp3YelA+/PKgWPzXnPvzlbZsmU+H9+6eHr6uqDTuDP3x6UL3rrHU+eumFE5XQbGy/eRxWua3Uw1/e/vXq+3iNWN8upmWYbsO//lcUW5aFf8mS6B9P/nnz2HNlBR/Fq2xdSqU1ouc3ZX3ZFOdWFn1GIBAIBDGc/PTQzaM77dWEYDnMm7lt/4cS+/bn75zjziLXh18eNMqs+yfTP/Th04Pq9YOf/73N/13VabJg+TJczfzze+fEnNDqnrYF/BW6Vqm0DehXc9fIsZxyMowcmf39Z3aGb3/+Lljc/FdSn+k2qJdSaY1In61/eig4btFnBAKBQMgMZzI9NI40X6W5DrMPvzwIo3T9JM/r0ZTcJesy3zntcvTZv396GGisP7/fesKC5cubx6+rx3/uUgbetYwQ6Bivjr5nMWyrv+Tq2I6rgfrM9oQN0WfiVdAvpdIamfosDugzAoFAIIjhrKaH9U8PXZ/ZbhJ9+/N34Ybuxtclrr7J2mK34BUumQ3TZ7HG8hcxHekWecv6Pxwg6aetCknvppqnPlOvsn4pFcvRZwQCgUAYN5zX9BCuze32EoWrn7vw4ZcHWWtzuuQaps8ijXXz+PXWZ7ZzpP2rXff0dpgNeDgg5T8rXZ8N23+mXGXz6mTps9znG9BnBAKBQBDDWU0Pr74P9nr/tf7pYfX944U8ZztpPH2mvINU2pjVpU/os2ZzlV+K9wIzb/OZE9WIs8r3tL39+Z3hPxPKCoWLv7vrEPos8R7X/hkqz2+6F8XfwWZdZfVSKq2R+fxm+ziCYwD6jEAgEAhiOO3pIVyo0rZsB/N68IyhdlYcGz6cuHs+IEufhdLh94+7ZzB9f9jNY+f4h08PQjX25/e7hzdDoSaW5TwXWYUNouuz4Cw326TjSmzDfTJU3n/m9IHHr9yFbPsqy5dSaY3c95+1y6m709FnBAKBQBDDuU8P4r6lMwzqwt+cQvm/HxC+8AV9RiAQCAQxnPf00PPXEk84nIQ+Cx/JLO73N6MfwkKfEQgEAkEMZzo9dKtXiLMmnIg+8x/FPb4+a16iK6Vp3/AS9Df0GYFAIBDEwPRAONnwjyf/PFrwn9/MDegzAoFAIIih2gAAAABASaDPAAAAAMoCfQYAAABQFugzAAAAgLKYRJ+tFlVVVVW9XE9ROgAAAEDRTOc/Wy/rqlqsJisfAAAAoEwmXN9cL2tcaAAAAAAh6DMAAACAskCfAQAAAJTFlM9vrhY8IwAAAAAQMvX7NdbLuuIxAQAAAIAdU+ozFjgBAAAAYth/BgAAAFAW6DMAAACAskCfAQAAAJQF+gwAAACgLPh9JwAAAICy4PfRAQAAAMpi6vefAQAAAIAP+gwAAACgLNBnAAAAAGWBPgMAAAAoC/QZAAAAQFmgzwAAAADKAn0GAAAAUBboMwAAAICyQJ8BAAAAlAX6DAAAAKAs0GcAAAAAZYE+AwAAACgL9BkAAABAWaDPAAAAAMoCfQYAAABQFugzAAAAgLJAnwEAAACUBfoMAAAAoCzQZwAAAABlgT4DAAAAKAv0GQAAAEBZoM8AAAAAygJ9BgAAAFAW6DMAAACAskCfAQAAAJQF+gwAAACgLNBnAAAAAGWBPgMAAAAoC/QZAAAAQFmgzwAAAADKAn0GAAAAUBboMwAAAICyQJ8BAAAAlAX6DAAAAKAs0GcAAAAAZYE+AwAAACgL9BkAAABAWaDPAAAAAMoCfQYAAABQFugzAAAAgLJAnwEAAACUBfoMAAAAoCzQZwAAAABl0emz1aKqqqqql+spzQEAAAA4e3z/2XpZV9ViNZEtAAAAABCtb66XNS40AAAAgClBnwEAAACUBfoMAAAAoCzC5zdXC54RAAAAAJgS6f0a62Vd8ZgAAAAAwDSE+owFTgAAAIBpqf7n//1/AoFAIBAIBEI5AX1GIBAIBAKBUFZAnxEIBAKBQCCUFf4PuOB4tszPyN8AAAAASUVORK5CYII=" alt="" />

4.     延迟加载思考

不使用mybatis提供的association及collection中的延迟加载功能,如何实现延迟加载??

实现方法如下:

定义两个mapper方法:

1、查询订单列表

2、根据用户id查询用户信息

实现思路:

先去查询第一个mapper方法,获取订单信息列表

在程序中(service),按需去调用第二个mapper方法去查询用户信息。

总之:

使用延迟加载方法,先去查询简单的sql最好单表,也可以关联查询),再去按需要加载关联查询的其它信息。

4.  一对多延迟加载

一对多延迟加载的方法同一对一延迟加载,在collection标签中配置select内容。

5.总结:

作用:

当需要查询关联信息时再去数据库查询,默认不去关联查询,提高数据库性能。

只有使用resultMap支持延迟加载设置。

场合:

当只有部分记录需要关联查询其它信息时,此时可按需延迟加载,需要关联查询时再向数据库发出sql,以提高数据库性能。

当全部需要关联查询信息时,此时不用延迟加载,直接将关联查询信息全部返回即可,可使用resultType或resultMap完成映射。

mybatis延迟加载——(十二)的更多相关文章

  1. mybatis学习 十二 多表查询

    Mybatis 实现多表查询方式: (1)业务装配.对两个表编写单表查询语句,在业务(Service)把查询的两个结果进行关联. (2)使用Auto Mapping特性,在实现两表联合查询时通过别名完 ...

  2. Spring&plus;SpringMVC&plus;MyBatis&plus;easyUI整合基础篇(十二)阶段总结

    不知不觉,已经到了基础篇的收尾阶段了,看着前面的十几篇文章,真的有点不敢相信,自己竟然真的坚持了下来,虽然过程中也有过懒散和焦虑,不过结果还是自己所希望的,克服了很多的问题,将自己的作品展现出来,也发 ...

  3. Spring&plus;SpringMVC&plus;MyBatis深入学习及搭建&lpar;十二&rpar;——SpringMVC入门程序(一)

    转载请注明出处:http://www.cnblogs.com/Joanna-Yan/p/6999743.html 前面讲到:Spring+SpringMVC+MyBatis深入学习及搭建(十一)——S ...

  4. MyBatis基础入门《十二》删除数据 - &commat;Param参数

    MyBatis基础入门<十二>删除数据 - @Param参数 描述: 删除数据,这里使用了@Param这个注解,其实在代码中,不使用这个注解也可以的.只是为了学习这个@Param注解,为此 ...

  5. (二十二)SpringBoot之使用mybatis generator自动生成bean、mapper、mapper xml

    一.下载mybatis generator插件 二.生成generatorConfig.xml new一个generatorConfig.xml 三.修改generatorConfig.xml 里面的 ...

  6. Spring Boot 2&period;X&lpar;十二&rpar;:定时任务

    简介 定时任务是后端开发中常见的需求,主要应用场景有定期数据报表.定时消息通知.异步的后台业务逻辑处理.日志分析处理.垃圾数据清理.定时更新缓存等等. Spring Boot 集成了一整套的定时任务工 ...

  7. (二十二)SpringBoot之使用Druid连接池以及SQL监控和spring监控

    一.引入maven依赖 <dependencies> <dependency> <groupId>org.springframework.boot</grou ...

  8. SpringBoot系列&lpar;十二&rpar;过滤器配置详解

    SpringBoot(十二)过滤器详解 往期精彩推荐 SpringBoot系列(一)idea新建Springboot项目 SpringBoot系列(二)入门知识 springBoot系列(三)配置文件 ...

  9. 前端开发中SEO的十二条总结

    一. 合理使用title, description, keywords二. 合理使用h1 - h6, h1标签的权重很高, 注意使用频率三. 列表代码使用ul, 重要文字使用strong标签四. 图片 ...

  10. CRL快速开发框架系列教程十二&lpar;MongoDB支持&rpar;

    本系列目录 CRL快速开发框架系列教程一(Code First数据表不需再关心) CRL快速开发框架系列教程二(基于Lambda表达式查询) CRL快速开发框架系列教程三(更新数据) CRL快速开发框 ...

随机推荐

  1. Android成长日记-使用ViewFlipper实现屏幕切换动画效果

    (一) ViewFlipper介绍 Android系统自带的一个多页面管理控件,它可以实现子界面的自动切换 (二) 为ViewFlipper加入View 1. 静态导入:在Layout布局文件中直接导 ...

  2. Shell下的正则表达式 &lpar;鸟哥私房菜&rpar;

    "Open Source" is a good mechanism to develop programs.$ apple is my favorite food.$ Footba ...

  3. POJ 3687 逆序拓扑

    额.题目大意:有N个球.编号和重量都是唯一不重复的.然后.给你m个pair a和b,表示编号为a的点一定比编号为b的点轻.然后捏.输出每个点对应的重量.关键是要求.如果有多种可能性的话,输出让序号小的 ...

  4. spring Integration服务总线

    最新项目中使用数据交换平台,主要通过交换平台抓取HIS数据库医生医嘱检查检验等数据以及FTP上的txt文件,html等病程文件,生成XML文件,之后通过业务系统按业务规则对数据进行处理,再将其存入数据 ...

  5. 《OD学HBase》20160814

    一.HBase引入 http://hbase.apache.org/ 大数据的数据库 1. 概述 Hadoop生态系统中的一个分布式.可拓展.面向列.可伸缩,具有自动容错功能的数据库. NoSQL数据 ...

  6. 开源图形库 c语言-图形图像库 集合&lbrack;转&rsqb;

    开源图形库 c语言-图形图像库 集合[转] Google三维API O3D O3D 是一个开源的 Web API 用来在浏览器上创建界面丰富的交互式的 3D 应用程序.这是一种基于网页的可控3D标准. ...

  7. 使用jquery生成二维码

    二维码已经渗透到生活中的方方面面,不管到哪,我们都可以用扫一扫解决大多数问题.二狗为了准备应对以后项目中会出现的二维码任务,就上网了解了如何使用jquery.qrcode生成二维码.方法简单粗暴,[] ...

  8. 缓存,spring

    applicationcontext.xml xmlns:cache="http://www.springframework.org/schema/cache" xsi:schem ...

  9. js 玩一玩

    闲着没事学了学js,做了一个下页面玩玩. 下面是html代码: <!DOCTYPE html><html> <head> <meta charset=&quo ...

  10. Python编程练习:简单的闹钟提醒

    问题详情:当前时间为下午2点,你在手机上设置了一个闹钟提醒,10000秒后触发该闹钟,请问闹钟铃声响起时的具体时间?请用print打印出时间 源码: a = 10000 h,m,s=2,0,0 if ...