mysql 批量插入

不努力就种地~

于 2022-09-02 10:42:52 发布

阅读量276

点赞数 1

分类专栏： java mysql 文章标签： java mybatis 数据库

本文链接：https://blog.csdn.net/qq_33919114/article/details/126657941

版权

java 同时被 2 个专栏收录

40 篇文章 1 订阅

订阅专栏

mysql

12 篇文章 0 订阅

订阅专栏

@Service
public class UserService extends ServiceImpl<UserMapper, User> implements IUserService {
    private static final Logger logger = LoggerFactory.getLogger(UserService.class);
    @Autowired
    UserMapper userMapper;
    @Autowired
    SqlSessionFactory sqlSessionFactory;
 
    @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));
    }
}