Java SQL ResultSet String Read getString(ResultSet resultSet, String columnName)

Description

get String

License

Apache License

Parameter

Parameter	Description
E	a parameter
resultSet	String
columnName	String

Exception

Parameter	Description
SQLException	an exception

Return

E

Declaration

public static String getString(ResultSet resultSet, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*//from   ww w.java2  s .  c  o m
 * SpiderDB - Lightweight Database Schema Crawler
 * Copyright (c) 2010, Avdhesh yadav.
 * Contact: avdhesh.yadav@gmail.com
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * 
 * http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */

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

public class Main {
    /**
     * 
     * @param <E> 
     * @param resultSet String
     * @param columnName String
     * 
     * @return E
     * 
     * @throws SQLException
     */
    public static String getString(ResultSet resultSet, String columnName) throws SQLException {
        String value = null;
        if (checkColumn(resultSet, columnName))
            value = resultSet.getString(columnName);
        return value;
    }

    /**
     * 
     * @param resultSet ResultSet
     * @param columnName String
     * 
     * @return boolean
     * 
     * @throws SQLException
     */
    public static boolean checkColumn(ResultSet resultSet, String columnName) throws SQLException {
        ResultSetMetaData rsMetaData = resultSet.getMetaData();
        for (int i = 0; i < rsMetaData.getColumnCount(); i++) {
            String col = rsMetaData.getColumnLabel(i + 1);
            if (col != null && col.equalsIgnoreCase(columnName))
                return true;
        }
        return false;
    }
}

Related

1. getString(ResultSet p_rset, int p_col)
2. getString(ResultSet res, String name)
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 column)