Java SQL ResultSet Double Read getDoubleOrNanFromResultSet(ResultSet rs, int index)

Description

get Double Or Nan From Result Set

License

Open Source License

Declaration

private static double getDoubleOrNanFromResultSet(ResultSet rs,
            int index) throws SQLException 

Method Source Code

//package com.java2s;
/*/*w w  w  . j  a  v  a 2s  . co m*/
 * RHQ Management Platform
 * Copyright (C) 2005-2008 Red Hat, Inc.
 * All rights reserved.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation version 2 of the License.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
 */

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

public class Main {
    private static double getDoubleOrNanFromResultSet(ResultSet rs,
            int index) throws SQLException {
        double value = rs.getDouble(index);
        if (rs.wasNull()) {
            value = Double.NaN;
        }
        return value;
    }
}

Related

1. getDouble(ResultSet rs, String column)
2. getDouble(ResultSet rs, String columnName)
3. getDouble2(ResultSet rs, int index)
4. getDoubleList(ResultSet resultSet, String columnName)
5. getDoubleNotZero(ResultSet rs, String columnLabel)
6. getDoubleOrNull(ResultSet rs, String columnName)
7. getDoubleValue(ResultSet resultSet, int columnIndex)
8. readDouble(ResultSet resultSet, String columnName)
9. readDoubleFromResultSet(ResultSet rs, String column)