Java SQL ResultSet Double Read getDouble(ResultSet rs, String columnName)

Description

get a Double from a result set column with given name

License

Open Source License

Parameter

Parameter	Description
rs	a parameter
columnName	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

the value, which may be null

Declaration

public static Double getDouble(ResultSet rs, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*/*w  ww  .j  a  v a 2s  .co m*/
 * Copyright 2010 Research Studios Austria Forschungsgesellschaft mBH
 *
 * This file is part of easyrec.
 *
 * easyrec 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, either version 3 of the License, or
 * (at your option) any later version.
 *
 * easyrec 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 easyrec.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.sql.*;

public class Main {
    /**
     * get a Double from a result set column with given name
     *
     * @param rs
     * @param columnName
     * @return the value, which may be <code>null</code>
     * @throws SQLException
     */
    public static Double getDouble(ResultSet rs, String columnName) throws SQLException {
        double val = rs.getDouble(columnName);
        if (rs.wasNull()) {
            return null;
        }
        return val;
    }
}

Related

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