How can MyBatis update multiple fields of data in a batch?

2 years ago
Olivia Parker
2 minutes

MyBatis offers a method for batch updating multiple fields of data. Here is a common approach:

  1. Firstly, define a batch update method in the Mapper interface, as shown below:
void updateBatch(List<YourClass> list);
  1. Write the corresponding SQL statements in the Mapper XML file and use the dynamic SQL foreach tag for batch update operations. An example is shown below:
<update id="updateBatch" parameterType="java.util.List">
  update your_table
  <set>
    <foreach collection="list" item="item" separator=",">
      field1 = #{item.field1},
      field2 = #{item.field2},
      ...
    </foreach>
  </set>
  where id = #{item.id}
</update>

In the example above, your_table is the name of the table to be updated, field1 and field2 are the names of the fields to be updated, item.field1 and item.field2 are the corresponding field names in the Java object, and id is used to specify the update condition.

  1. In Java code, call the batch update method of the Mapper interface. First, assemble the list of data to be updated, then call the method to perform batch updates. An example is shown below:
YourMapper mapper = sqlSession.getMapper(YourMapper.class);
List<YourClass> list = new ArrayList<>();
// 组装要更新的数据列表
YourClass item1 = new YourClass();
item1.setId(1);
item1.setField1(newValue1);
item1.setField2(newValue2);
// 添加更多要更新的数据项...
list.add(item1);
// 批量更新
mapper.updateBatch(list);

The above are the basic steps for batch updating multiple field data using MyBatis. Depending on your actual needs, you may need to adjust the specific implementation details in the SQL statements and Java code.

bannerAds