批量插入

最新推荐文章于 2024-10-06 20:55:19 发布

weixin_30402343

最新推荐文章于 2024-10-06 20:55:19 发布

阅读量66

点赞数

原文链接：http://www.cnblogs.com/stromluo/p/9208732.html

版权

/**
 * 批量插入
 * @param mergerDtos
 * @param mergerId
 */
private void batchSaveMergerItem(List<MergerDto> mergerDtos, Long mergerId){
    if (CollectionUtils.isNotEmpty(mergerDtos)) {
        for (MergerDto mergerDto : mergerDtos) {
            List<Long> ids = mergerDto.getIds();

            int size = ids.size();
            List<TrMergerMemberItemEo> 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;
}