/**
 *
 * @author Pete Cappello
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class DisplayMandelbrotDB 
{
    static final String DATABASE_URL = "jdbc:derby://localhost:1527/Mandelbrot";
    
    public static void main( String[] args )
    {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        
        try
        {
            connection = DriverManager.getConnection( DATABASE_URL, "nbuser", "nbuser" );
            statement = connection.createStatement();
            resultSet = statement.executeQuery( "SELECT * FROM APP.MODELS" );
            
            ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
            int numColumns = resultSetMetaData.getColumnCount();
            System.out.println( "MODELS table" );
            for ( int columnNum = 1; columnNum <= numColumns; columnNum++ )
            {
                System.out.printf("%-14s\t", resultSetMetaData.getColumnName( columnNum ) );
            }
            System.out.println();
            
            while ( resultSet.next() )
            {
                for ( int columnNum = 1; columnNum <= numColumns; columnNum++ )
                {
                    System.out.printf("%-14s\t", resultSet.getObject( columnNum ) );
                }
                System.out.println();
            }
        }
        catch ( SQLException sqlException)
        {
            sqlException.printStackTrace();
        }
        finally
        {
            try
            {
                resultSet.close();
                statement.close();
                connection.close();
            }
            catch ( Exception exception )
            {
                exception.printStackTrace();
            }
        }
    }
}