Java SQL Table Column getColumnTypes(ResultSet rs)

Description

Determines the SQL column types used in the provided resultset.

License

Open Source License

Parameter

Parameter	Description
rs	the resultset to inspect

Exception

Parameter	Description
SQLException	if querying the meta-data fails

Return

the SQL column types

Declaration

public static int[] getColumnTypes(ResultSet rs) throws SQLException 

Method Source Code

//package com.java2s;
/*//from  w w  w .  j  a  v  a  2 s  .com
 *   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.ResultSetMetaData;
import java.sql.SQLException;

public class Main {
    /**
     * Determines the SQL column types used in the provided resultset.
     *
     * @param rs      the resultset to inspect
     * @return      the SQL column types
     * @see      Types
     * @throws SQLException        if querying the meta-data fails
     */
    public static int[] getColumnTypes(ResultSet rs) throws SQLException {
        return getColumnTypes(rs.getMetaData());
    }

    /**
     * Determines the SQL column types used in the provided resultset.
     *
     * @param rs      the metadata resultset to inspect
     * @return      the SQL column types
     * @see      Types
     * @throws SQLException   if querying the meta-data fails
     */
    public static int[] getColumnTypes(ResultSetMetaData rs) throws SQLException {
        int[] result;
        int i;

        result = new int[rs.getColumnCount()];
        for (i = 1; i <= rs.getColumnCount(); i++)
            result[i - 1] = rs.getColumnType(i);

        return result;
    }
}

Related

1. getColumns(ResultSetMetaData rsMetaData)
2. getColumnsNames(ResultSet rs)
3. getColumnType(ResultSet resultSet, int i, Map typeCache)
4. getColumnType(ResultSetMetaData rsm)
5. getColumnType(ResultSetMetaData rsmd, int idx)
6. getColumnValue(ResultSet rs, ResultSetMetaData rsmd, int colIndex)
7. getColumnValue(String column, String defaultValue, Map columnIndexMap, ResultSet res)
8. getColumnValueFromResultSet(int columnIndex, int argType, ResultSet rs)
9. getColunmNames(ResultSetMetaData rsmd)