{"id":14282,"date":"2023-12-04T01:15:36","date_gmt":"2023-12-03T17:15:36","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=14282"},"modified":"2023-12-04T01:16:21","modified_gmt":"2023-12-03T17:16:21","slug":"mybatis-ru-he-zhi-xing-pi-liang-cha-ru","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/12\/04\/mybatis-ru-he-zhi-xing-pi-liang-cha-ru\/","title":{"rendered":"MyBatis \u5982\u4f55\u6267\u884c\u6279\u91cf\u63d2\u5165\uff1f"},"content":{"rendered":"<p>MyBatis \u6267\u884c\u6279\u91cf\u63d2\u5165\u901a\u5e38\u4f7f\u7528 <code>foreach<\/code> \u6807\u7b7e\u6216\u8005\u4f7f\u7528\u6279\u91cf\u64cd\u4f5c\u7684 API \u6765\u5b9e\u73b0\u3002<\/p>\n<h3>\u4f7f\u7528 foreach \u6807\u7b7e\uff1a<\/h3>\n<p>\u5728 XML \u6620\u5c04\u6587\u4ef6\u4e2d\uff0c\u53ef\u4ee5\u5229\u7528 <code>foreach<\/code> \u6807\u7b7e\u6267\u884c\u6279\u91cf\u63d2\u5165\u64cd\u4f5c\uff0c\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n<pre data-language=XML><code class=\"language-markup  line-numbers\">&lt;insert id=\"batchInsertUsers\" parameterType=\"java.util.List\"&gt;\n  INSERT INTO user_table (user_id, user_name) VALUES\n  &lt;foreach collection=\"list\" item=\"user\" separator=\",\"&gt;\n    (#{user.userId}, #{user.userName})\n  &lt;\/foreach&gt;\n&lt;\/insert&gt;\n<\/code><\/pre>\n<p>\u5728 Java \u4ee3\u7801\u4e2d\uff0c\u5c06\u8981\u6279\u91cf\u63d2\u5165\u7684\u6570\u636e\u5c01\u88c5\u4e3a List\uff0c\u7136\u540e\u8c03\u7528 Mapper \u4e2d\u5bf9\u5e94\u7684\u65b9\u6cd5\uff1a<\/p>\n<pre><code class=\"language-java  line-numbers\">void batchInsertUsers(List&lt;User&gt; userList);\n<\/code><\/pre>\n<h3>\u4f7f\u7528\u6279\u91cf\u64cd\u4f5c\u7684 API\uff1a<\/h3>\n<p>\u5728 MyBatis \u4e2d\u4e5f\u63d0\u4f9b\u4e86\u6279\u91cf\u64cd\u4f5c\u7684 API\uff0c\u6bd4\u5982 <code>SqlSession<\/code> \u7684 <code>insert<\/code>\u3001<code>update<\/code>\u3001<code>delete<\/code> \u65b9\u6cd5\u3002\u793a\u4f8b\uff1a<\/p>\n<pre><code class=\"language-java  line-numbers\">List&lt;User&gt; userList = new ArrayList&lt;&gt;();\n\/\/ \u586b\u5145 userList...\n\ntry (SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH)) {\n    int batchSize = 100; \/\/ \u6307\u5b9a\u6279\u91cf\u64cd\u4f5c\u7684\u5927\u5c0f\n    int batchCount = 0;\n\n    for (User user : userList) {\n        sqlSession.insert(\"insertUser\", user);\n\n        batchCount++;\n        if (batchCount % batchSize == 0 || batchCount == userList.size()) {\n            sqlSession.flushStatements(); \/\/ \u6267\u884c\u6279\u91cf\u64cd\u4f5c\n        }\n    }\n\n    sqlSession.commit();\n}\n<\/code><\/pre>\n<p>\u4ee5\u4e0a\u65b9\u6cd5\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u9700\u6c42\u9009\u62e9\u5408\u9002\u7684\u65b9\u5f0f\u6765\u8fdb\u884c\u6279\u91cf\u63d2\u5165\u64cd\u4f5c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis \u6267\u884c\u6279\u91cf\u63d2\u5165\u901a\u5e38\u4f7f\u7528 foreach \u6807\u7b7e\u6216\u8005\u4f7f\u7528\u6279\u91cf\u64cd\u4f5c\u7684 API \u6765\u5b9e\u73b0\u3002 \u4f7f\u7528 fore [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[113],"tags":[],"class_list":["post-14282","post","type-post","status-publish","format-standard","hentry","category-mybatis"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=14282"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14282\/revisions"}],"predecessor-version":[{"id":14283,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/14282\/revisions\/14283"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=14282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=14282"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=14282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}