{"id":677,"date":"2019-10-19T11:27:28","date_gmt":"2019-10-19T03:27:28","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=677"},"modified":"2019-10-19T11:33:50","modified_gmt":"2019-10-19T03:33:50","slug":"mybatis-xml%e5%b8%b8%e7%94%a8%e5%86%99%e6%b3%95-%e4%bc%a0%e5%85%a5%e6%95%b0%e7%bb%84list","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=677","title":{"rendered":"mybatis xml\u5e38\u7528\u5199\u6cd5-\u4f20\u5165\u6570\u7ec4list"},"content":{"rendered":"<h1>\u9700\u6c42\uff1axml\u4e2d\u4f20\u5165\u53c2\u6570\u4e2d\u5305\u542b\u4e00\u4e2alist\uff0c\u9700\u8981\u5728where\u4e2d\u62fc\u63a5in\u8bed\u53e5<\/h1>\n<div class=\"mume markdown-preview \">\n<p>\u5047\u8bbe\u67e5\u8be2person\u8868\uff0c\u53c2\u6570\u7c7b\u578b\u4e3aXXXVo\uff0cXXXVo\u4e2d\u5305\u542b\u4e00\u4e2aList\u5bf9\u8c61\uff0c\u4fdd\u5b58\u4e86\u72b6\u6001\u5217\u8868\uff0c\u6b64\u65f6\u53ef\u4ee5\u53c2\u8003\u5982\u4e0b\u67e5\u8be2<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>&lt;select id=\"queryXXX\" parameterType=\"XXXVo\"\r\n\t\t\tresultMap=\"XXXResult\"&gt;\r\n\t\tselect *\r\n\t\tfrom person\r\n\t\t WHERE 1=1\r\n\t\t&lt;if test=\"statusFilter != null and statusFilter.size() &gt; 0\"&gt;\r\n            and status in\r\n            &lt;foreach collection=\"statusFilter\" item=\"statusId\" index=\"i\" open=\"(\" close=\")\" separator=\",\"&gt;\r\n                #{statusId}\r\n            &lt;\/foreach&gt;\r\n        &lt;\/if&gt;\r\n\t\t ORDER BY DEPTID\r\n\t&lt;\/select&gt;\r\n<\/code><\/pre>\n<p><!--more--><\/p>\n<h2 id=\"%E9%80%9A%E8%BF%87map%E5%AF%B9%E8%B1%A1%E4%BC%A0%E9%80%92%E5%8F%82%E6%95%B0%E7%BB%99xml\" class=\"mume-header\">\u901a\u8fc7Map\u5bf9\u8c61\u4f20\u9012\u53c2\u6570\u7ed9xml<\/h2>\n<p>\u53c2\u6570\u540c\u6837\u53ef\u4ee5\u901a\u8fc7Map\u5bf9\u8c61\u4f20\u9012\u5230xml\u8fd9\u4e2a\u5c42\u9762\uff0c\u6b64\u65f6\u8fd9\u6837\u5199\u5373\u53ef\uff1a<br \/>\njava\u4ee3\u7801\uff1a<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>map.put(statusFilter, \u5217\u8868\u5b9e\u4f8b\u5bf9\u8c61);\r\n<\/code><\/pre>\n<p>xml\u4ee3\u7801\uff1a<\/p>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>&lt;select id=\"queryXXX\" parameterType=\"java.util.HashMap\"\r\n\t\t\tresultMap=\"XXXResult\"&gt;\r\n\t\tselect *\r\n\t\tfrom person\r\n\t\t WHERE 1=1\r\n\t\t&lt;if test=\"statusFilter != null and statusFilter.size() &gt; 0\"&gt;\r\n            and status in\r\n            &lt;foreach collection=\"statusFilter\" item=\"statusId\" index=\"i\" open=\"(\" close=\")\" separator=\",\"&gt;\r\n                #{statusId}\r\n            &lt;\/foreach&gt;\r\n        &lt;\/if&gt;\r\n\t\t ORDER BY DEPTID\r\n\t&lt;\/select&gt;\r\n<\/code><\/pre>\n<h1 id=\"%E5%8F%82%E8%80%83%E6%96%87%E7%AB%A0\" class=\"mume-header\">\u53c2\u8003\u6587\u7ae0<\/h1>\n<ul>\n<li><a href=\"https:\/\/blog.csdn.net\/qq_15204179\/article\/details\/1000425509\">myBatis\u7684xml\u6620\u5c04\u6587\u4ef6\u4e2d\u4f20\u5165list\u96c6\u5408\u4e0e\u6570\u7ec4\u505a\u6761\u4ef6<\/a><\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9700\u6c42\uff1axml\u4e2d\u4f20\u5165\u53c2\u6570\u4e2d\u5305\u542b\u4e00\u4e2alist\uff0c\u9700\u8981\u5728where\u4e2d\u62fc\u63a5in\u8bed\u53e5 \u5047\u8bbe\u67e5\u8be2person\u8868\uff0c\u53c2\u6570\u7c7b\u578b\u4e3aX <a href='http:\/\/prayerlaputa.com\/?p=677' 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":[6,86],"tags":[33,87],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/677"}],"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=677"}],"version-history":[{"count":1,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/677\/revisions"}],"predecessor-version":[{"id":678,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/677\/revisions\/678"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=677"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}