/*
 * Main.java
 * Created on 2006. srpanj 12, 10:48
 */
package testb2091213;
/**
 *
 * @author Tonci
 * mysql-connector-java-3.1.13, GA
 * JDK 1.6
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.DatabaseMetaData;

public class Main {
    Connection con;

    public void setUp() throws Exception
    {
        Class.forName("com.mysql.jdbc.Driver");
        con=DriverManager.getConnection("jdbc:mysql://munja:3307/mysql?user=root&password=");
        System.out.println("Connected");
        System.out.println("");

        DatabaseMetaData dbmd = con.getMetaData();
        String[] tableTypes = { "TABLE" }; 

        System.out.println("Testing default schema, schema not-null (mysql)");
        testResult(dbmd.getTables("mysql", null, "%", tableTypes));
        System.out.println("");

        System.out.println("Testing default schema, schema null (mysql)");
        testResult(dbmd.getTables(null, null, "%", tableTypes));
        System.out.println("");
    
        System.out.println("Testing not-default schema, schema not-null (test)");
        testResult(dbmd.getTables("test", null, "%", tableTypes));
        System.out.println("");

        System.out.println("Testing default schema, schema not-null (mysql), pattern 'time%'");
        testResult(dbmd.getTables("mysql", null, "time%", tableTypes));
        System.out.println("");

        System.out.println("Testing not-default schema, schema not-null (test), pattern 'TEST%'");
        testResult(dbmd.getTables("test", null, "TEST%", tableTypes));
        //System.out.println("");
    }

    public void tearDown() throws Exception
    {
        con.close();
    }
    
    /** Creates a new instance of Main */
    public Main() {
        try
        {
            setUp();
        }
        catch(Exception e1)
        {
            e1.printStackTrace();
        }
        finally
        {
            try
            {
                tearDown();
            }
            catch(Throwable t){}
        }
    }
    
   private void testResult(ResultSet rs) throws Exception { 
        rs.next(); 
        System.out.println("  Schema: " + rs.getString(1));
        while (!rs.isAfterLast()) {
            System.out.println("    ROW: " + rs.getRow() + " Table: " + rs.getString(3));
            rs.next();
        }
   }    
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        new Main();
    }
}