{"id":754,"date":"2020-02-01T11:32:35","date_gmt":"2020-02-01T03:32:35","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=754"},"modified":"2020-02-01T11:32:35","modified_gmt":"2020-02-01T03:32:35","slug":"mybatis_plus%e5%b8%b8%e8%a7%81%e7%94%a8%e6%b3%95-%e4%b8%8d%e7%94%a8xml%e5%ae%9e%e7%8e%b0%e8%87%aa%e5%ae%9a%e4%b9%89%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=754","title":{"rendered":"mybatis_plus\u5e38\u89c1\u7528\u6cd5-\u4e0d\u7528xml\u5b9e\u73b0\u81ea\u5b9a\u4e49\u67e5\u8be2"},"content":{"rendered":"<p>\u627e\u5230\u4e24\u79cd\u65b9\u6cd5\uff1a<br \/>\n1\u3001\u91c7\u7528mybatis\u6ce8\u89e3\u7684\u65b9\u5f0f<br \/>\n\u53c2\u89c1\uff1a<a href=\"https:\/\/blog.csdn.net\/weixin_31058701\/article\/details\/102834031\">MyBatis Plus \u81ea\u5b9a\u4e49\u67e5\u8be2\u8bed\u53e5<\/a><br \/>\nDAO\u5c42\uff1a<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>@Select(\"select b.bomName, \" +\r\n\t\t\"b.bomProductType, b.bomMaterial, \" +\r\n\t\t\"o.customerID AS bomID, \" +\r\n\t\t\"o.ordersDataNo AS qrCode, \" +\r\n\t\t\"s.deliveryDate AS barCode, \" +\r\n\t\t\"s.mainType AS workshop \" +\r\n\t\t\"FROM mes_order_bom b \" +\r\n\t\t\"LEFT JOIN mes_order_ordersdata o ON b.ordersID = o.id \" +\r\n\t\t\"LEFT JOIN mes_order_soncontract s ON o.sonContractID = s.id \" +\r\n\t\t\"WHERE o.ordersDataNo IN (#{orderNoList})\")\r\nList&lt;MesOrderBom&gt; getBomAndOrderCodeNumber(@Param(\"orderNoList\")List&lt;String&gt; orderNoList);\r\n<\/code><\/pre>\n<p><!--more--><\/p>\n<p>Service\u5c42\uff1a<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>List&lt;MesOrderBom&gt; getBomAndOrderCodeNumber(List&lt;String&gt; orderNoList);\r\n<\/code><\/pre>\n<p>Service\u5b9e\u73b0\u7c7b:<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>@Override\r\npublic List&lt;MesOrderBom&gt; getBomAndOrderCodeNumber(List&lt;String&gt; orderNoList) {\r\n\treturn this.baseMapper.getBomAndOrderCodeNumber(orderNoList);\r\n}\r\n<\/code><\/pre>\n<p>2\u3001\u81ea\u5b9a\u4e49\u5b9e\u73b0<br \/>\n<a href=\"https:\/\/cloud.tencent.com\/developer\/article\/1492870\">\u7ed3\u5408mybatis-plus \u5b9e\u73b0\u65e0XML\u591a\u8868\u8054\u67e5\u8be2<\/a><br \/>\n\u9879\u76ee\u5730\u5740\uff1a<a href=\"https:\/\/github.com\/yangaijun\/multipleselect\">multipleselect<\/a><br \/>\njava \u7ed3\u5408mybatis-plus \u5b9e\u73b0\u975e\u624b\u5199sql\u591a\u8868\u67e5\u8be2<\/p>\n<h2 id=\"%E5%8F%82%E8%80%83%E8%B5%84%E6%96%99\" class=\"mume-header\">\u53c2\u8003\u8d44\u6599<\/h2>\n<ul>\n<li><a href=\"https:\/\/blog.csdn.net\/weixin_31058701\/article\/details\/102834031\">MyBatis Plus \u81ea\u5b9a\u4e49\u67e5\u8be2\u8bed\u53e5<\/a><\/li>\n<li><a href=\"https:\/\/cloud.tencent.com\/developer\/article\/1492870\">\u7ed3\u5408mybatis-plus \u5b9e\u73b0\u65e0XML\u591a\u8868\u8054\u67e5\u8be2<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u627e\u5230\u4e24\u79cd\u65b9\u6cd5\uff1a 1\u3001\u91c7\u7528mybatis\u6ce8\u89e3\u7684\u65b9\u5f0f \u53c2\u89c1\uff1aMyBatis Plus \u81ea\u5b9a\u4e49\u67e5\u8be2\u8bed\u53e5 DAO\u5c42\uff1a  <a href='http:\/\/prayerlaputa.com\/?p=754' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[86],"tags":[88],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/754"}],"collection":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=754"}],"version-history":[{"count":1,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/754\/revisions"}],"predecessor-version":[{"id":755,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/754\/revisions\/755"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=754"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}