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

Description

This method will return a null rather than zero if the database has a null value for the column.

License

RPL License

Parameter

Parameter	Description
rs	a parameter
strColName	a parameter

Exception

Parameter	Description
SQLException	an exception

Declaration

static public Integer getInteger(ResultSet rs, String strColName) throws SQLException 

Method Source Code

//package com.java2s;
/*//  w  w  w  .java2  s  . c o  m
 * Unless explicitly acquired and licensed from Licensor under another license, the contents of
 * this file are subject to the Reciprocal Public License ("RPL") Version 1.5, or subsequent
 * versions as allowed by the RPL, and You may not copy or use this file in either source code
 * or executable form, except in compliance with the terms and conditions of the RPL
 *
 * All software distributed under the RPL is provided strictly on an "AS IS" basis, WITHOUT
 * WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, AND LICENSOR HEREBY DISCLAIMS ALL SUCH
 * WARRANTIES, INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
 * PARTICULAR PURPOSE, QUIET ENJOYMENT, OR NON-INFRINGEMENT. See the RPL for specific language
 * governing rights and limitations under the RPL.
 *
 * http://opensource.org/licenses/RPL-1.5
 *
 * Copyright 2012-2015 Open Justice Broker Consortium
 */

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

public class Main {
    /**
     * This method will return a null rather than zero if the database has a null
     * value for the column.
     * 
     * See here:
     * http://stackoverflow.com/questions/2920364/checking-for-a-null-int-value-from-a-java-resultset
     * 
     * @param rs
     * @param strColName
     * @return
     * @throws SQLException
     */
    static public Integer getInteger(ResultSet rs, String strColName) throws SQLException {
        int nValue = rs.getInt(strColName);
        return rs.wasNull() ? null : nValue;
    }
}

Related

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