public void pageQuery() { List<Map<String, Object>> bjList = new ArrayList<>(); //起始页 Integer currPage = 1; //每页展示条数 Integer pageSize = 10000; for (int i = 1; i < 1000000; i++) { currPage = (i - 1) * pageSize; //自己的查询sql bjList = fenceDataMapper.selectBjAll(currPage, pageSize); if (CollectionUtil.isEmpty(bjList)) { break; } else { beijingWLSave(bjList); } } }
java循环操作分页查询
最新推荐文章于 2024-04-15 11:02:25 发布