批量插入 java_批量插入

/**

* 批量插入

* @param mergerDtos

* @param mergerId

*/

private void batchSaveMergerItem(List mergerDtos, Long mergerId){

if (CollectionUtils.isNotEmpty(mergerDtos)) {

for (MergerDto mergerDto : mergerDtos) {

List ids = mergerDto.getIds();

int size = ids.size();

List batch = initList(size,BizConstant.DB_MAX_BATCH_NUM);

boolean flushFlag = false;

for (int i = 0; i < size; i++) {

if ( ((i+1) % BizConstant.DB_MAX_BATCH_NUM == 0 )

||( i == size -1)) {

flushFlag = true;

}

TrMergerMemberItemEo trMergerMemberItemEo = new TrMergerMemberItemEo();

trMergerMemberItemEo.setMergerId(mergerId);

trMergerMemberItemEo.setTableName(mergerDto.getTableName());

trMergerMemberItemEo.setBizId(ids.get(i));

batch.add(trMergerMemberItemEo);

if (flushFlag) {

trMergerMemberItemDas.insertBatch(batch);

if (i != size -1) {

flushFlag = false;

batch = initList(size,BizConstant.DB_MAX_BATCH_NUM);

}

}

}

}

}

}

private List initList(int size, int maxSize){

List list ;

if (size > maxSize) {

list = new ArrayList<>(maxSize);

} else {

list = new ArrayList<>(size);

}

return list;

}

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！