Java SQL Table Column columnExists(Connection connection, String table, String column)

Description

column Exists

License

Apache License

Declaration

static boolean columnExists(Connection connection, String table, String column) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from   w w  w  .j  a  v a2s  . co  m*/
 * Copyright 2017 the original author or authors.
 *
 * 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.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    static boolean columnExists(Connection connection, String table, String column) throws SQLException {
        ResultSet columns = null;
        boolean exists;

        try {
            columns = connection.getMetaData().getColumns(null, null, table, column);
            exists = columns.next();
        } finally {
            if (columns != null) {
                columns.close();
            }
        }
        return exists;
    }
}

Related

1. columnExists(Connection con, String tableName, String columnName)
2. columnLabels(final ResultSet results)
3. containsColumn(ResultSet rs, String columnName)
4. extractColumnTypeName(ResultSetMetaData resultSetMetaData, int index)
5. generateKey(Statement statement, String TableName, String KeyColumn)