Java SQL ResultSet Int Read getInteger(ResultSet rs, String columnName)

Description

get an Integer object 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 Integer getInteger(ResultSet rs, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*//from   w  w w .  j ava  2 s . c  om
 * 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 an Integer object 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 Integer getInteger(ResultSet rs, String columnName) throws SQLException {
        int value = rs.getInt(columnName);
        if (rs.wasNull()) {
            return null;
        }
        return value;
    }
}

Related

1. getInt(ResultSet rs, String columnName)
2. getInteger(final ResultSet rs, final String field)
3. getInteger(ResultSet resultSet, String columnName)
4. getInteger(ResultSet rs, String colName)
5. getInteger(ResultSet rs, String column)
6. getInteger(ResultSet rs, String strColName)
7. getInteger(ResultSet s, int idx)
8. getIntegerFromResultSet(ResultSet rs, String db_name)
9. getIntegerList(ResultSet resultSet, String columnName)