Java JDBC Database Metadata getPrimaryKeyColumnNames(Connection connection, String tableName)

Description

get Primary Key Column Names

License

Open Source License

Declaration

public static List<String> getPrimaryKeyColumnNames(Connection connection, String tableName)
            throws SQLException 

Method Source Code

//package com.java2s;
/*//w  w  w  .ja  v  a2  s  . c o m
 * Copyright (C) 2008-2015 by Holger Arndt
 *
 * This file is part of the Universal Java Matrix Package (UJMP).
 * See the NOTICE file distributed with this work for additional
 * information regarding copyright ownership and licensing.
 *
 * UJMP 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
 * of the License, or (at your option) any later version.
 *
 * UJMP 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 UJMP; if not, write to the
 * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
 * Boston, MA  02110-1301  USA
 */

import java.sql.Connection;
import java.sql.DatabaseMetaData;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;

public class Main {
    public static List<String> getPrimaryKeyColumnNames(Connection connection, String tableName)
            throws SQLException {
        List<String> primaryKeyColumnNames = new LinkedList<String>();
        DatabaseMetaData dbm = connection.getMetaData();
        ResultSet rs = dbm.getPrimaryKeys(null, null, tableName);
        while (rs.next()) {
            String keyColumnName = rs.getString("COLUMN_NAME");
            primaryKeyColumnNames.add(keyColumnName);
        }
        rs.close();
        return primaryKeyColumnNames;
    }
}

Related

1. getJDBCMajorVersion(Connection conn)
2. getNullableDescription(int type)
3. getOnly1PrimaryKey(Connection conn, String tableName)
4. getPrimaryKey(DatabaseMetaData metadata, String tableName)
5. getPrimaryKeyColumn(DatabaseMetaData md, String TableName)
6. getPrimaryKeys(Connection conn, String tableName)
7. getQualifiedTableName(DatabaseMetaData dbmd, String catalog, String schema, String table, boolean useQuotes)
8. getSchemaPattern(final DatabaseMetaData dbData, String schemaName)
9. getSchemas(Connection c)