Java SQL ResultSet Read getCountFromResultSet(ResultSet rs)

Description

get Count From Result Set

License

Open Source License

Parameter

Parameter	Description
rs	a parameter

Return

-1 on error

Declaration

public static int getCountFromResultSet(ResultSet rs) 

Method Source Code

//package com.java2s;
/**//from w w w.  j a va  2  s  .  c o  m
 * Copyright 2005 Osmosis networks and consulting and contributors.
 * 
 * This code use code fragments under the GNU Public License and is
 * licensed under the Apache License, Version 2.0 (the "License")
 * plus some restrictions/modifications desribed below;
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 */

import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    /**
     * 
     * @param rs
     * @return -1 on error
     */
    public static int getCountFromResultSet(ResultSet rs) {

        int count = -1;

        try {
            if (!rs.next()) {
                return -1;
            }
            count = rs.getInt(1);
        } catch (SQLException ex) {
            System.out.println(ex.getMessage());
        } finally {

        }

        return count;
    }
}

Related

1. getBigObject(ResultSet set, int columnIndex)
2. getCalendar(ResultSet resultSet, String columnName)
3. getCharacterStream(ResultSet resultSet, String columnName)
4. getChunkDelimiters(ResultSet rs, int tsColumnIndex, int chunkSize)
5. getClassName(ResultSetMetaData meta, int index)
6. getData(final ResultSet rs)
7. getDataDupls(ResultSet rs)
8. getDateList(ResultSet resultSet, String columnName)
9. getDbDateValue(ResultSet rs, String columnName)