check Database Table Column Properties - Java java.sql

Java examples for java.sql:Table

  1. HOME
  2. Java
  3. java.sql
  4. Table

Description

check Database Table Column Properties

Demo Code

/**/*from   ww w. j  av a2  s.c  o m*/
 * Sonar Data Migrator, A tool to migrate sonar project data between to separate sonar instances.
 *
 * Copyright (C) 2013 Worldline or third-party contributors as
 * indicated by the @author tags or express copyright attribution
 * statements applied by the authors.
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License.
 *
 * This library 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
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, see <http://www.gnu.org/licenses/>
 */
//package com.java2s;
import java.sql.Connection;

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

public class Main {
    static void checkColumnProperties(Connection con2, String tableName)
            throws SQLException {

        PreparedStatement st4 = con2.prepareStatement("select * from "
                + tableName);
        ResultSet rs0 = st4.executeQuery();

        ResultSetMetaData rsmd = rs0.getMetaData();
        for (int i = 1; i <= rsmd.getColumnCount(); i++) {
            System.out.println("name=" + rsmd.getColumnLabel(i) + " auto "
                    + rsmd.isAutoIncrement(i) + " "
                    + rsmd.getColumnTypeName(i));
        }
    }
}

Related Tutorials