Java SQL ResultSet Long Read getLong(ResultSet rs, String columnName)

Description

get a Long object from a result set column with given name

License

Open Source License

Parameter

Parameter	Description
rs	a parameter
columnName	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

the value, which may be null

Declaration

public static Long getLong(ResultSet rs, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*/*w w  w  .  ja va 2 s.  c  o  m*/
 * Copyright 2010 Research Studios Austria Forschungsgesellschaft mBH
 *
 * This file is part of easyrec.
 *
 * easyrec is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * easyrec 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with easyrec.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.sql.*;

public class Main {
    /**
     * get a Long object from a result set column with given name
     *
     * @param rs
     * @param columnName
     * @return the value, which may be <code>null</code>
     * @throws SQLException
     */
    public static Long getLong(ResultSet rs, String columnName) throws SQLException {
        long value = rs.getLong(columnName);
        if (rs.wasNull()) {
            return null;
        }
        return value;
    }
}

Related

1. getLong(ResultSet resultSet, int index)
2. getLong(ResultSet resultSet, String columnName)
3. getLong(ResultSet rs, String colName)
4. getLong(ResultSet rs, String column)
5. getLong(ResultSet rs, String columnName)
6. getLongDateFromResultSet(ResultSet rset, Enum field)
7. getLongFromResultSet(ResultSet rs, String db_name)
8. getLongFromResultSet(ResultSet rs, String field)
9. getLongList(ResultSet resultSet, String columnName)