{"id":9957,"date":"2024-03-14T10:23:12","date_gmt":"2024-03-14T10:23:12","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/"},"modified":"2024-03-20T16:45:01","modified_gmt":"2024-03-20T16:45:01","slug":"how-can-mybatis-update-data-in-bulk","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/","title":{"rendered":"How can MyBatis update data in bulk?"},"content":{"rendered":"

In MyBatis, batch update can be used to update multiple records simultaneously. Here are the steps to perform batch update using MyBatis:<\/p>\n

    \n
  1. Create a Mapper interface that defines a method for batch updating data. For example:<\/li>\n<\/ol>\n
    public<\/span> interface<\/span> UserMapper<\/span> {\r\n    void<\/span> batchUpdate<\/span>(List<User> userList)<\/span>;\r\n}\r\n<\/code><\/pre>\n
      \n
    1. Write the SQL statements in the corresponding Mapper.xml file, using the foreach tag to loop through and update the data. For example:<\/li>\n<\/ol>\n
      <update<\/span> id<\/span>=\"batchUpdate\"<\/span> parameterType<\/span>=\"java.util.List\"<\/span>><\/span>\r\n    update user\r\n    <set<\/span>><\/span>\r\n        <foreach<\/span> collection<\/span>=\"list\"<\/span> item<\/span>=\"item\"<\/span> separator<\/span>=\",\"<\/span>><\/span>\r\n            name = #{item.name},\r\n            age = #{item.age}\r\n        <\/foreach<\/span>><\/span>\r\n    <\/set<\/span>><\/span>\r\n    where id in\r\n    <foreach<\/span> collection<\/span>=\"list\"<\/span> item<\/span>=\"item\"<\/span> open<\/span>=\"(\"<\/span> close<\/span>=\")\"<\/span> separator<\/span>=\",\"<\/span>><\/span>\r\n        #{item.id}\r\n    <\/foreach<\/span>><\/span>\r\n<\/update<\/span>><\/span>\r\n<\/code><\/pre>\n
        \n
      1. In Java code, call the method of the Mapper interface and pass in the list of data that needs to be updated. For example:<\/li>\n<\/ol>\n
        List<User> userList = new<\/span> ArrayList<\/span><>();\r\nUser<\/span> user1<\/span> =<\/span> new<\/span> User<\/span>(1<\/span>, \"Alice\"<\/span>, 25<\/span>);\r\nUser<\/span> user2<\/span> =<\/span> new<\/span> User<\/span>(2<\/span>, \"Bob\"<\/span>, 30<\/span>);\r\nuserList.add(user1);\r\nuserList.add(user2);\r\n\r\nuserMapper.batchUpdate(userList);\r\n<\/code><\/pre>\n
        By following the above steps, you can use MyBatis to batch update data. In practical applications, you can define Mapper interfaces and SQL statements according to specific business requirements to achieve batch update functionality.<\/p>\n","protected":false},"excerpt":{"rendered":"
        In MyBatis, batch update can be used to update multiple records simultaneously. Here are the steps to perform batch update using MyBatis: Create a Mapper interface that defines a method for batch updating data. For example: public interface UserMapper { void batchUpdate(List<User> userList); } Write the SQL statements in the corresponding Mapper.xml file, using the […]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-9957","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow can MyBatis update data in bulk? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can MyBatis update data in bulk?\" \/>\n<meta property=\"og:description\" content=\"In MyBatis, batch update can be used to update multiple records simultaneously. Here are the steps to perform batch update using MyBatis: Create a Mapper interface that defines a method for batch updating data. For example: public interface UserMapper { void batchUpdate(List<User> userList); } Write the SQL statements in the corresponding Mapper.xml file, using the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T10:23:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T16:45:01+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How can MyBatis update data in bulk?\",\"datePublished\":\"2024-03-14T10:23:12+00:00\",\"dateModified\":\"2024-03-20T16:45:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\"},\"wordCount\":124,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\",\"name\":\"How can MyBatis update data in bulk? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T10:23:12+00:00\",\"dateModified\":\"2024-03-20T16:45:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can MyBatis update data in bulk?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can MyBatis update data in bulk? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/","og_locale":"en_US","og_type":"article","og_title":"How can MyBatis update data in bulk?","og_description":"In MyBatis, batch update can be used to update multiple records simultaneously. Here are the steps to perform batch update using MyBatis: Create a Mapper interface that defines a method for batch updating data. For example: public interface UserMapper { void batchUpdate(List<User> userList); } Write the SQL statements in the corresponding Mapper.xml file, using the […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T10:23:12+00:00","article_modified_time":"2024-03-20T16:45:01+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How can MyBatis update data in bulk?","datePublished":"2024-03-14T10:23:12+00:00","dateModified":"2024-03-20T16:45:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/"},"wordCount":124,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/","name":"How can MyBatis update data in bulk? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T10:23:12+00:00","dateModified":"2024-03-20T16:45:01+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-mybatis-update-data-in-bulk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can MyBatis update data in bulk?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9957"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9957\/revisions"}],"predecessor-version":[{"id":43161,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9957\/revisions\/43161"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}