List tables in a database : JDBC ODBC « Database « Java Tutorial

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Main {

  public static void main(String args[]) throws Exception {
    String URL = "jdbc:odbc:dbName";
    Connection conn = DriverManager.getConnection(URL, "user", "passw");

    DatabaseMetaData dmd = conn.getMetaData();
    ResultSet rs1 = dmd.getSchemas();
    while ( {
      String ss = rs1.getString(1);
      ResultSet rs2 = dmd.getTables(null, ss, "%", null);
      while (
        System.out.println(rs2.getString(3) + " " + rs2.getString(4));

20.33.1.Connect to Access Database using JDBC-ODBC bridge
20.33.2.sun.jdbc.odbc.JdbcOdbcDriver Connection Example
20.33.3.Load JdbcOdbcDriver and create a table
20.33.4.Query a jdbc odbc connection
20.33.5.Get metadata from jdbc:odbc connection
20.33.6.Working with a Result Set
20.33.7.Working with ResultSetMetaData
20.33.8.List tables in a database