Here you can find the source of getChunkDelimiters(ResultSet rs, int tsColumnIndex, int chunkSize)
| Parameter | Description |
|---|---|
| rs | the ResultSet |
| tsColumnIndex | the index of the timestamp column |
| chunkSize | the number of rows |
| Parameter | Description |
|---|---|
| SQLException | an exception |
public static List getChunkDelimiters(ResultSet rs, int tsColumnIndex, int chunkSize) throws SQLException
//package com.java2s; /*/*from w w w. jav a 2 s.c o m*/ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. * * Copyright (c) 2000-2017 Oracle and/or its affiliates. All rights reserved. * * The contents of this file are subject to the terms of either the GNU * General Public License Version 2 only ("GPL") or the Common Development * and Distribution License("CDDL") (collectively, the "License"). You * may not use this file except in compliance with the License. You can * obtain a copy of the License at * https://oss.oracle.com/licenses/CDDL+GPL-1.1 * or LICENSE.txt. See the License for the specific * language governing permissions and limitations under the License. * * When distributing the software, include this License Header Notice in each * file and include the License file at LICENSE.txt. * * GPL Classpath Exception: * Oracle designates this particular file as subject to the "Classpath" * exception as provided by Oracle in the GPL Version 2 section of the License * file that accompanied this code. * * Modifications: * If applicable, add the following below the License Header, with the fields * enclosed by brackets [] replaced by your own identifying information: * "Portions Copyright [year] [name of copyright owner]" * * Contributor(s): * If you wish your version of this file to be governed by only the CDDL or * only the GPL Version 2, indicate your decision by adding "[Contributor] * elects to include this software in this distribution under the [CDDL or GPL * Version 2] license." If you don't indicate a single choice of license, a * recipient has the option to distribute your version of this file under * either the CDDL, the GPL Version 2 or to extend the choice of license to * its licensees as provided above. However, if you add GPL Version 2 code * and therefore, elected the GPL Version 2 license, then the option applies * only if the new code is made subject to such option by the copyright * holder. */ import java.sql.*; import java.util.ArrayList; import java.util.List; public class Main { /** * A convenient method to break down the total number of rows to * delete/update into smaller chunks. This method assumes that the * specified resultset is ordered by the timestamp column. * * @param rs the ResultSet * @param tsColumnIndex the index of the timestamp column * @param chunkSize the number of rows * @return a List of timestamp to delimit each chunk * @throws SQLException */ public static List getChunkDelimiters(ResultSet rs, int tsColumnIndex, int chunkSize) throws SQLException { ArrayList list = new ArrayList(10); int rowCount = 0; while (rs.next()) { if (++rowCount == chunkSize) { rowCount = 0; list.add(Long.valueOf(rs.getLong(tsColumnIndex))); } } // Since more rows could potentially qualify at delete-time than at // select-time, the last chunk should include all records that might // be added 60 secs from now... list.add(Long.valueOf(System.currentTimeMillis() + 60000)); return list; } }