mybatis大批量数据高效插入

@Resource
private SqlSessionFactory sqlSessionFactory;

public void insert(List<User> insertList) {
//具体实现
SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
try {
Long mm = System.currentTimeMillis();
UserDao mapper = sqlSession.getMapper(UserDao.class);
insertList.stream().forEach(item -> {
mapper.insert(item);
});
sqlSession.clearCache();
sqlSession.commit();
} catch (Exception e) {
throw new RuntimeException(e);
} finally {
sqlSession.close();
}

}
posted @ 2023-03-15 17:36  六個字的昵称  阅读(59)  评论(0)    收藏  举报