List result = new ArrayList();
try {
DatabaseMetaData metaData = this.connection_.getMetaData();
System.out.println("Datenbank-Produktname : "
+ metaData.getDatabaseProductName());
System.out.println("Datenbank-Produktversion: "
+ metaData.getDatabaseProductVersion());
System.out.println("Datenbank-Datei : " + db);
ResultSet catalogs = metaData.getCatalogs();
while (catalogs.next()) {
String tableCatalog = catalogs.getString("TABLE_CAT");
String catalog = Helper.ersetzeBackslash(tableCatalog);
System.out.println("Catalog: " + catalog);
// von db noch die Extension '.mdb' abschneiden
String cat = db.substring(0, db.indexOf(".mdb"));
// Namen der Relationen einlesen
if (catalog.equals(cat)) {
String[] types = { "TABLE" };
ResultSet tables = metaData
.getTables(tableCatalog, null, null, types);
List namen = new ArrayList();
while (tables.next()) {
namen.add(tables.getString("TABLE_NAME").toLowerCase());
}
// hier jetzt die Spalten einlesen und weitermachen ...
}
else {
System.out.println("Nicht relevante DB: " + catalog);
}
}
}
catch (SQLException exception) {
Sytem.err.println(exception.getMessage());
}