Java SQL ResultSet Int Read getInteger(final ResultSet rs, final String field)

Description

This method will return an Integer, functioning like getInt, but with the ability to recognize null values, instead of converting them to zero.

License

Apache License

Parameter

Parameter	Description
rs	The ResultSet to look in.
field	The field name to look for.

Exception

Parameter	Description
SQLException	If thrown by ResultSet.

Return

The Integer value of the field, may be null.

Declaration

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

Method Source Code


//package com.java2s;
/*/*ww w .  jav  a 2s  . c o  m*/
 *  Copyright 2011 Eric F. Savage, code@efsavage.com
 *
 *   Licensed under the Apache License, Version 2.0 (the "License");
 *   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 {
    /**
     * This method will return an Integer, functioning like getInt, but with the
     * ability to recognize null values, instead of converting them to zero.
     * 
     * @see ResultSet#getInt(String)
     * @see ResultSet#getObject(String)
     * @param rs
     *            The ResultSet to look in.
     * @param field
     *            The field name to look for.
     * @return The Integer value of the field, may be null.
     * @throws SQLException
     *             If thrown by ResultSet.
     */
    public static Integer getInteger(final ResultSet rs, final String field) throws SQLException {
        if (rs.getObject(field) == null) {
            return null;
        }
        return Integer.valueOf(rs.getInt(field));
    }
}