springboot执行批量插入_Springboot 批量插入优化

//com.baomidou.mybatisplus.extension.service.impl ServiceImpl

/**

* 批量插入

*

* @param entityList

* @param batchSize

* @return

*/

@Transactional(rollbackFor = Exception.class)

@Override

public boolean saveBatch(Collection entityList, int batchSize) {

int i = 0;

String sqlStatement = sqlStatement(SqlMethod.INSERT_ONE);

try (SqlSession batchSqlSession = sqlSessionBatch()) {

for (T anEntityList : entityList) {

batchSqlSession.insert(sqlStatement, anEntityList); //每条数据都会执行，

if (i >= 1 && i % batchSize == 0) {

batchSqlSession.flushStatements();

}

i++;

}

batchSqlSession.flushStatements(); //预写入

}

return true;

}

//org.apache.ibatis.sess