mybatis批量更新sqlsession方式实现

MyBatis provides two ways to perform batch updates using the SqlSession interface:

Using the insert, update, or delete methods of the SqlSession interface: You can pass a list of objects to these methods, and MyBatis will execute the statement multiple times for each object in the list. Here's an example:

List<User> userList = new ArrayList<>();
// populate the userList with the objects to be updated

try (SqlSession session = sqlSessionFactory.openSession()) {
    for (User user : userList) {
        session.update("updateUser", user);
    }
    session.commit();
}

In this example, the updateUser statement is executed for each object in the userList, and the changes are committed to the database after all updates are performed.

Using the batch method of the SqlSession interface: This method allows you to execute a batch of statements defined in a Mapper XML file. Here's an example:

try (SqlSession session = sqlSessionFactory.openSession()) {
    BatchExecutor batchExecutor = ((DefaultSqlSession) session).getBatchExecutor();

    for (User user : userList) {
        batchExecutor.doUpdate(session.getConfiguration().getMappedStatement("updateUser"), user);
    }
    session.commit();
}

In this example, the updateUser statement is executed for each object in the userList using the doUpdate method of the BatchExecutor. The changes are committed to the database after all updates are performed.

Both methods provide a way to perform batch updates in MyBatis. Choose the method that best fits your requirements and coding style