Java SQL Table isTableEmpty(Connection con, String schemaName, String tableName)

Description

is Table Empty

License

Open Source License

Declaration

public static boolean isTableEmpty(Connection con, String schemaName,
            String tableName) 

Method Source Code

//package com.java2s;
/*//from w w  w  . j ava  2  s .c o m
 * The Kuali Financial System, a comprehensive financial management system for higher education.
 * 
 * Copyright 2005-2014 The Kuali Foundation
 * 
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero 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 Affero General Public License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.sql.Connection;

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

public class Main {
    public static boolean isTableEmpty(Connection con, String schemaName,
            String tableName) {
        boolean result = false;
        try {
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM "
                    + schemaName + "." + tableName);
            rs.next();
            int rowCount = rs.getInt(1);
            if (rowCount == 0) {
                result = true;
            }
            rs.close();
            stmt.close();
        } catch (SQLException ex) {
            System.err.println("Error checking table row count ("
                    + schemaName + "." + tableName + ") : "
                    + ex.getMessage());
        }
        return result;
    }
}

Related

1. getTotalRows(String tableName, Statement statement)
2. hasTable(Connection conn, String schemaName, String tableName)
3. hasTable(String TableName, Connection conn)
4. isExistsDerbyTable(Connection derbyConnection, String schema, String table)
5. isFileImportable(File file, String prefix)
6. normalizeTableName(String table, Connection con)
7. parse(Connection connection, String tableName, String type)
8. queryAllFromTable(String tableName)
9. quoteSchemaTable(Connection conn, String schema, String table)