Java SQL ResultSet Int Read getInteger(ResultSet s, int idx)

Description

Get the Integer result in slot 'idx' of ResultSet 's', being careful to return null when it's NULL.

License

Apache License

Parameter

Parameter	Description
s	statement to modify
idx	index in statement to set

Exception

Parameter	Description
SQLException	an exception

Return

integer in slot idx of s

Declaration

public static Integer getInteger(ResultSet s, int idx) throws SQLException 

Method Source Code

//package com.java2s;
/**//from  w  w  w. ja  v a  2 s. com
 * Marmoset: a student project snapshot, submission, testing and code review
 * system developed by the Univ. of Maryland, College Park
 * 
 * Developed as part of Jaime Spacco's Ph.D. thesis work, continuing effort led
 * by William Pugh. See http://marmoset.cs.umd.edu/
 * 
 * Copyright 2005 - 2011, Univ. of Maryland
 * 
 * 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 {
    /** 
     * Get the Integer result in slot 'idx' of ResultSet 's', being
     * careful to return null when it's NULL.
     * 
     * @param s    statement to modify
     * @param idx  index in statement to set
     * @return     integer in slot idx of s
     * @throws SQLException
     */
    public static Integer getInteger(ResultSet s, int idx) throws SQLException {
        if (s.getString(idx) == null) {
            return null;
        } else {
            return s.getInt(idx);
        }
    }
}

Related

1. getInteger(ResultSet resultSet, String columnName)
2. getInteger(ResultSet rs, String colName)
3. getInteger(ResultSet rs, String column)
4. getInteger(ResultSet rs, String columnName)
5. getInteger(ResultSet rs, String strColName)
6. getIntegerFromResultSet(ResultSet rs, String db_name)
7. getIntegerList(ResultSet resultSet, String columnName)
8. getIntegerNotZeroNotMinValue(ResultSet rs, String columnLabel)
9. getIntegers(ResultSet rs, String column)