循环优化

final static int PAGE_NUMBER = 200;

        int size = pts.size();

int loop = size / PAGE_NUMBER;

if(size % PAGE_NUMBER > 0){

 loop ++;

}

for(int k =0 ; k < loop ; k++){

        int toIdnex = ((k+1) * PAGE_NUMBER);

if(toIdnex > size){

toIdnex = size;

}

List<Long> list = pts.subList((k * PAGE_NUMBER), toIdnex);

String pics = list.toString().substring(1, list.toString().indexOf("]", 1));

String sql = "UPDATE wms_pick_ticket p SET p.ele_status = 'DISTRIBUTION',p.elec_date =                                       p.order_date"+" WHERE p.ID IN ("+pics+")";

dh.query(sql);

}