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();
}
}
浙公网安备 33010602011771号