e247. listing all table names in a database.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 20 行

try {
        // Gets the database metadata
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Specify the type of object; in this case we want tables
        String[] types = {"TABLE"};
        ResultSet resultSet = dbmd.getTables(null, null, "%", types);
    
        // Get the table names
        while (resultSet.next()) {
            // Get the table name
            String tableName = resultSet.getString(3);
    
            // Get the table's catalog and schema names (if any)
            String tableCatalog = resultSet.getString(1);
            String tableSchema = resultSet.getString(2);
        }
    } catch (SQLException e) {
    }