mybatis批处理mysql

<!-- mybatis-config.xml -->
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydb"/>
                <property name="username" value="root"/>
                <property name="password" value="password"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

<!-- UserMapper.xml -->
<mapper namespace="com.example.UserMapper">
    <insert id="insertUser" parameterType="com.example.User">
        INSERT INTO users (name, email) VALUES (#{name}, #{email})
    </insert>
</mapper>

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

public class BatchExample {
    public static void main(String[] args) {
        String resource = "mybatis-config.xml";
        InputStream inputStream = BatchExample.class.getClassLoader().getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        try (SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH)) {
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

            List<User> users = new ArrayList<>();
            for (int i = 0; i < 1000; i++) {
                User user = new User();
                user.setName("User " + i);
                user.setEmail("user" + i + "@example.com");
                users.add(user);
                userMapper.insertUser(user);
            }

            sqlSession.commit();
        }
    }
}

try (SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH)) {
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

    List<User> users = new ArrayList<>();
    for (int i = 0; i < 1000; i++) {
        User user = new User();
        user.setName("User " + i);
        user.setEmail("user" + i + "@example.com");
        users.add(user);
        userMapper.insertUser(user);

        if (users.size() % 100 == 0) {
            sqlSession.flushStatements();
            users.clear();
        }
    }

    sqlSession.commit();
}