解决oracle查询超过1000条报错问题
private List<Entity> queryBatchLockEntityByDataIds(List<String> ids) {
List<Entity> entities = new ArrayList<>();
if (dataIds != null) {
int size = ids.size();
int num = size / 5 + 1;// 每次查询不超过5条
if (num == 1 || ids== null) {
return 查询方法
} else {
for (int i = 0; i < num; i++) {
int start = i * 5;
int end = (i + 1) * 5;
if (end >= size) {
end = size;
}
List<String> str = ids.subList(start, end)
List<Entity> entitiesSub = 查询方法
entities.addAll(entitiesSub);
}
}
}
return entities;
}