Java SQL Table Column isNull(ResultSet resultSet, String columnName)

Description

Validates if the supplied value is null from the result set.

License

Open Source License

Parameter

Parameter	Description
resultSet	a parameter
columnName	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

true if the column was null.

Declaration

public static boolean isNull(ResultSet resultSet, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*//from w  w  w  . jav  a  2  s .c o  m
*  Adito
*
*  Copyright (C) 2003-2006 3SP LTD. All Rights Reserved
*
*  This program 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 2 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 General Public License for more details.
*
*  You should have received a copy of the GNU General Public
*  License along with this program; if not, write to the Free Software
*  Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
*/

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

public class Main {
    /**
     * Validates if the supplied value is null from the result set. This is
     * useful for primitive type checking.
     * 
     * @param resultSet
     * @param columnName
     * @return true if the column was null.
     * @throws SQLException
     */
    public static boolean isNull(ResultSet resultSet, String columnName) throws SQLException {
        return null == resultSet.getObject(columnName);
    }
}

Related

1. hasColumns(Connection conn, String tableName, Collection colNames)
2. hasTableAndColumns(Connection conn, String tableName, String... colNames)
3. indent_DisplayBanner(PrintWriter out, ResultSetMetaData rsmd, int indentLevel, int[] displayColumns, int[] displayColumnWidths)
4. isColumnNullable(Connection conn, String table, String column)
5. isColumnNullable(Connection conn, String table, String column)
6. lookupColumnIndex(final ResultSetMetaData resultSetMetaData, final String columnName)
7. lookupColumnIndex(ResultSetMetaData resultSetMetaData, String name)
8. lookupColumnName(ResultSetMetaData resultSetMetaData, int columnIndex)
9. printTableColumn(Connection conn, String sql)