数据拆分操作策略

最新推荐文章于 2022-08-31 14:53:19 发布

原创最新推荐文章于 2022-08-31 14:53:19 发布 · 615 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据 #操作

javase 专栏收录该内容

31 篇文章

订阅专栏

public void selectTempAndInsertToDetail() {
		List<ExpressCwbOrderDTO> transOrderList = expressCwbOrderDataImportDAO.getTransOrderTempByKeys();
		if (transOrderList == null || transOrderList.size() == 0) {
			return;
		}
		// 分组操作数据
		int k = 1;
		int batch = 50;
		while (true) {
			int fromIndex = (k - 1) * batch;
			if (fromIndex >= transOrderList.size()) {
				break;
			}
			int toIdx = k * batch;
			if (k * batch > transOrderList.size()) {
				toIdx = transOrderList.size();
			}
			List<ExpressCwbOrderDTO> subList = transOrderList.subList(fromIndex, toIdx);
			importSubList(subList);
			k++;
		}
	}