Tells whether the table has an index with the given index, or not. - Java java.sql

Java examples for java.sql:Table

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

Description

Tells whether the table has an index with the given index, or not.

Demo Code

/*/* ww w .  j  a va 2 s. c  o  m*/
 * Zed Attack Proxy (ZAP) and its related class files.
 * 
 * ZAP is an HTTP/HTTPS proxy for assessing web application security.
 * 
 * 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.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.log4j.Logger;

public class Main{
    private static final Logger logger = Logger.getLogger(DbUtils.class);
    /**
     * Tells whether the table {@code tableName} has an index with the given
     * {@code indexName}, or not.
     * 
     * @param connection
     *            the connection to the database
     * @param tableName
     *            the name of the table that may have the index
     * @param indexName
     *            the name of the index that will be checked
     * @return {@code true} if the table {@code tableName} has the index
     *         {@code indexName}, {@code false} otherwise.
     * @throws SQLException
     *             if an error occurred while checking if the table has the
     *             index
     */
    public static boolean hasIndex(final Connection connection,
            final String tableName, final String indexName)
            throws SQLException {
        boolean hasIndex = false;

        ResultSet rs = null;
        try {
            rs = connection.getMetaData().getIndexInfo(null, null,
                    tableName, false, false);
            while (rs.next()) {
                if (indexName.equals(rs.getString("INDEX_NAME"))) {
                    hasIndex = true;
                    break;
                }
            }
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
            } catch (SQLException e) {
                if (logger.isDebugEnabled()) {
                    logger.debug(e.getMessage(), e);
                }
            }
        }

        return hasIndex;
    }
}

Related Tutorials