Java SQL Table countTables(Connection connection)

Description

count Tables

License

Open Source License

Declaration

static int countTables(Connection connection) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from  ww w.j  av  a2s.com*/
 * SonarQube
 * Copyright (C) 2009-2017 SonarSource SA
 * mailto:info AT sonarsource DOT com
 *
 * This program 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 3 of the License, or (at your option) any later version.
 *
 * This program 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 program; if not, write to the Free Software Foundation,
 * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */

import java.sql.Connection;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    static int countTables(Connection connection) throws SQLException {
        int count = 0;
        ResultSet resultSet = connection.getMetaData().getTables("", null, null, new String[] { "TABLE" });
        while (resultSet.next()) {
            count++;
        }
        resultSet.close();
        return count;
    }
}

Related

1. clearTables(Connection conn, String[] tables)
2. clearTables(Connection connection)
3. columnExist(String table, String column, Connection con)
4. constructObject(Class theClass, Connection db, int objectId, String tableName, String uniqueField)
5. count(Connection conn, String table)
6. createBagValuesTables(Connection con)
7. createFreqTable()
8. createHSQLTables(LineNumberReader reader, Statement statement)
9. createSourceTable(Connection con)