将大数据，分批分段，插入数据库

来源：互联网发布：js date 函数编辑：程序博客网时间：2024/05/18 14:27

import java.util.ArrayList;import java.util.List;public class FenDuan {/** * @param args */public static void main(String[] args) {//1.总记录数List<String> oldList = new ArrayList<String>();for (int i = 0; i < 1045; i++) {oldList.add((i+1)+"");}//2.分页数据信息int totalSize = oldList.size(); //总记录数int pageSize = 10; //每页N条int totalPage = totalSize/pageSize; //共N页if (totalSize % pageSize != 0) {  totalPage += 1;  if (totalSize < pageSize) {  pageSize = oldList.size(); }  }  System.out.println("循环保存的次数："+totalPage);//循环多少次  for (int pageNum = 1; pageNum < totalPage+1; pageNum++) {int starNum = (pageNum-1)*pageSize;int endNum = pageNum*pageSize>totalSize?(totalSize):pageNum*pageSize;System.out.println("起始："+starNum+"-"+endNum);String str = "";for (int i = starNum; i < endNum; i++) {str += oldList.get(i) +"   ";}System.out.println("第"+pageNum+"批：" +str);}}}

0 0