批量插入mysql

@Transactional(rollbackFor = Exception.class)
public void addUserOneByOne(List<User> users) {
    SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH);
    UserMapper um = session.getMapper(UserMapper.class);
    long startTime = System.currentTimeMillis();
    for (User user : users) {
        um.addUserOneByOne(user);
    }
    session.commit();
    long endTime = System.currentTimeMillis();
    logger.info("一条条插入 SQL 耗费时间 {}", (endTime - startTime));
}