for ( int i = 0; i < schemas.length; i++ ) { theSchemaNode = new DatabaseExplorerNode(); theSchemaNode.setName( schemas[i].getSchemaName() ); theSchemaNode.setImage( SCHEMA_IMAGE ); theSchemaNode.setIsSchema( true ); String[] theTableNames = schemas[i].getItems(); if ( theTableNames != null ) { for ( int i2 = 0; i2 < theTableNames.length; i2++ ) { DatabaseExplorerNode theTableNode = new DatabaseExplorerNode(); theTableNode.setIsTable( true ); theTableNode.setSchema( schemas[i].getSchemaName() ); theTableNode.setName( theTableNames[i2] ); theTableNode.setImage( TABLE_IMAGE );
String[] schemasFilterArray = schemasFilterCommaList.split( "," ); for ( int i = 0; i < schemasFilterArray.length; i++ ) { schemaList.add( new Schema( schemasFilterArray[i].trim() ) ); while ( schemaResultSet != null && schemaResultSet.next() ) { String schemaName = schemaResultSet.getString( "name" ); schemaList.add( new Schema( schemaName ) ); while ( schemaResultSet != null && schemaResultSet.next() ) { String schemaName = schemaResultSet.getString( 1 ); schemaList.add( new Schema( schemaName ) ); ResultSet schemaTablesResultSet = dbmd.getTables( null, schema.getSchemaName(), null, null ); while ( schemaTablesResultSet.next() ) { String tableName = schemaTablesResultSet.getString( 3 ); schema.setItems( schemaTables.toArray( new String[schemaTables.size()] ) );
String schemaName = dmi.getSchemas()[0].getSchemaName(); // for example, we String[] tableNames = dmi.getSchemas()[0].getItems(); // for example, all
String schemaName = dmi.getSchemas()[0].getSchemaName(); // for example, we take the first... String[] tableNames = dmi.getSchemas()[0].getItems(); // for example, all tables from the first schema