Java SQL ResultSet Print printColTypes(ResultSetMetaData rsmd)

Description

print Col Types

License

Apache License

Declaration

public static void printColTypes(ResultSetMetaData rsmd)
            throws SQLException 

Method Source Code

//package com.java2s;
/*//w  w w  .ja  va  2  s  .c  om
 * Crunchy Data Solutions
 * Copyright 2014
 *
 * 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.*;

public class Main {
    public static void printColTypes(ResultSetMetaData rsmd)
            throws SQLException {

        int columns = rsmd.getColumnCount();
        for (int i = 1; i <= columns; i++) {
            int jdbcType = rsmd.getColumnType(i);
            String name = rsmd.getColumnTypeName(i);
            //System.out.print("Column " + i + " is JDBC type " + jdbcType);
            //System.out.println(", which the DBMS calls " + name);
        }
    }
}

Related

1. prettyFormat(ResultSet res)
2. print(ResultSet resultSet)
3. print(ResultSet rs, PrintStream out)
4. print(ResultSet rs, PrintStream out)
5. printCols(final ResultSetMetaData paymentTableResultSetMetaData, final String logging_prefix)
6. printHeader(PrintWriter pw, ResultSet rs)
7. printHeaders(ResultSetMetaData rsmd, PrintStream out)
8. printItems(ResultSet rs)
9. printoutDB(ResultSet rs)