Java SQL ResultSet Int Read getInt(ResultSet res, String name)

Description

Returns the values of the specified column as an Integer.

License

MIT License

Parameter

Parameter	Description
res	a result set.
name	a name of the column.

Exception

Parameter	Description
SQLException	if an error occurs.

Return

the value of the column.

Declaration

public static Integer getInt(ResultSet res, String name) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from w w w  .  j  a  v  a2s  .com*/
 * Copyright (c) 2015-2016 QuartzDesk.com.
 * Licensed under the MIT license (https://opensource.org/licenses/MIT).
 */

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

public class Main {
    /**
     * Returns the values of the specified column as an Integer. If the column
     * value is null, this method returns null.
     *
     * @param res  a result set.
     * @param name a name of the column.
     * @return the value of the column.
     * @throws SQLException if an error occurs.
     */
    public static Integer getInt(ResultSet res, String name) throws SQLException {
        int v = res.getInt(name);
        return res.wasNull() ? null : v;
    }
}

Related

1. getInt(ResultSet p_rset, int p_col)
2. getInt(ResultSet results, int parameterIndex)
3. getInt(ResultSet rs, int columnIndex)
4. getInt(ResultSet rs, String column)
5. getInt(ResultSet rs, String columnName)