Java SQL ResultSet String Read getString(ResultSet rs, String column)

Description

ResultSets often come with "NULL" and return nulls, we preferr actual objects with appropriate values.

License

Open Source License

Parameter

Parameter	Description
rs	The ResultSet to get this String column from
column	The name of the column to get

Exception

Parameter	Description
SQLException	if column does not exist or other SQLExceptions

Return

The target column value

Declaration

public static String getString(ResultSet rs, String column) throws SQLException 

Method Source Code

//package com.java2s;
/*//from www . ja va2s. c o  m
 * Copyright 2011, United States Geological Survey or
 * third-party contributors as indicated by the @author tags.
 *
 * 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 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/  >.
 *
 */

import java.sql.ResultSet;

import java.sql.SQLException;

public class Main {
    /** ResultSets often come with "NULL" and return nulls, we preferr
    actual objects with appropriate values.  Return a "" if result is null.
    *@param rs The ResultSet to get this String column from
    *@param column The name of the column to get
    *@return The target column value
    *@throws SQLException if column does not exist or other SQLExceptions
     */
    public static String getString(ResultSet rs, String column) throws SQLException {
        //    try {
        String t = rs.getString(column);
        //    Util.prt("Util.getString for " + column + "=" +t + "| wasnull=" +rs.wasNull());
        if (rs.wasNull())
            t = "";
        //    } catch (SQLException e) {throw e};
        return t;
    }

    /** ResultSets often come with "NULL" and return nulls, we preferr
    actual objects with appropriate values.  Return a "" if result is null.
    *@param rs The ResultSet to get this column from
    *@param column The  column to get
    *@return The target column value
    *@throws SQLException if column does not exist or other SQLExceptions
     */
    public static String getString(ResultSet rs, int column) throws SQLException {
        //    try {
        String t = rs.getString(column);
        //    Util.prt("Util.getString for " + column + "=" +t + "| wasnull=" +rs.wasNull());
        if (rs.wasNull())
            t = "";
        //    } catch (SQLException e) {throw e};
        return t;
    }
}

Related

1. getString(ResultSet res, String name)
2. getString(ResultSet resultSet, String columnName)
3. getString(ResultSet resultSet, String columnName)
4. getString(ResultSet rs, int index, boolean trim)
5. getString(ResultSet rs, int ix, int sql_type)
6. getString(ResultSet rs, String columnLabel)
7. getString(ResultSet rs, String columnName)
8. getString(ResultSet rs, String name)
9. getString(ResultSet rs, String name, String ifnull)