This is example of batch executor.
```java
public void batchUpdate(List<People> peopleList) {
SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
try {
for (People people : peopleList) {
peopleMapper.update(people);
}
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
} finally {
sqlSession.close();
}
}
<update id="update" parameterType="com.lb.springboot.DO.People">
update people set
name = #{name},
age = #{age},
gmt_create = #{gmtCreate},
gmt_modify = #{gmtModify},
`type` = #{type},
location = #{location},
sex = #{sex},
class = #{clazz},
school = #{school},
rand = #{rand}
where id = #{id}
</update>
```
This is example of Splicing update SQL.
```xml
<update id="batchUpdate" parameterType="java.util.List">
<foreach collection="peopleList" item="item" index="index" open="" close="" separator=";">
update people
<set>
name = #{
item.name},
age = #{item.age},
gmt_create = #{item.gmtCreate},
gmt_modify = #{item.gmtModify},
`type` = #{item.type},
location = #{item.location},
sex = #{item.sex},
class = #{item.clazz},
school = #{item.school},
rand = #{item.rand}
</set>
where id = #{
item.id}
</foreach>
</update>
```
The length of peopleList is 10k.