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

Here you can find the source of getInteger(ResultSet rs, String colName)

Description

get Integer

License

Open Source License

Declaration

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

Method Source Code

//package com.java2s;
/*/*www  .  j a  v a  2  s .c  o  m*/
 * Copyright
 *   2005 axYus - www.axyus.com
 *   2005 C.Marchand - christophe.marchand@axyus.com
 *
 * This file is part of XEMELIOS.
 *
 * XEMELIOS 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 2 of the License, or
 * (at your option) any later version.
 *
 * XEMELIOS 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 XEMELIOS; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */

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

public class Main {
    static public Integer getInteger(ResultSet rs, String colName) throws SQLException {
        int res = rs.getInt(colName);
        return rs.wasNull() ? null : new Integer(res);
    }

    static public Integer getInteger(ResultSet rs, int colIndex) throws SQLException {
        int res = rs.getInt(colIndex);
        return rs.wasNull() ? null : new Integer(res);
    }
}

Related

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