Java SQL ResultSet Int Read getInt(ResultSet rs, int columnIndex)

Description

get Int

License

Open Source License

Declaration

@CheckForNull
    public static Integer getInt(ResultSet rs, int columnIndex) throws SQLException 

Method Source Code

//package com.java2s;
/*// ww w.  j  a va2 s . c  om
 * SonarQube
 * Copyright (C) 2009-2017 SonarSource SA
 * mailto:info AT sonarsource DOT com
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 3 of the License, or (at your option) any later version.
 *
 * This program 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
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program; if not, write to the Free Software Foundation,
 * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */

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

import javax.annotation.CheckForNull;

public class Main {
    @CheckForNull
    public static Integer getInt(ResultSet rs, String columnName) throws SQLException {
        int i = rs.getInt(columnName);
        return rs.wasNull() ? null : i;
    }

    @CheckForNull
    public static Integer getInt(ResultSet rs, int columnIndex) throws SQLException {
        int i = rs.getInt(columnIndex);
        return rs.wasNull() ? null : i;
    }
}

Related

1. getInt(ResultSet p_rset, int p_col)
2. getInt(ResultSet res, String name)
3. getInt(ResultSet results, int parameterIndex)
4. getInt(ResultSet rs, String column)
5. getInt(ResultSet rs, String columnName)
6. getInteger(final ResultSet rs, final String field)
7. getInteger(ResultSet resultSet, String columnName)