import java.sql.*;
import java.util.*;

public class SelectConta {
    
    public static void main( String args[] ) {
        String url = "jdbc:odbc:Banco";
        Connection connection = null;
        
        // Cria a conexão com o banco
        try {
            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
            connection = DriverManager.getConnection( url );
        }
        catch ( ClassNotFoundException cnfex ) {
            System.err.println( "Driver JDBC/ODBC nao encontrado." );
            cnfex.printStackTrace();
            System.exit( 1 );  
        }
        catch ( SQLException sqlex ) {
            System.err.println( "Falha na conexao." );
            sqlex.printStackTrace();
            System.exit( 1 );              
        }
        
        try {
            // Executa a query
            String query = "select conta, nome, agencia, saldo from contas";
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery( query );
            
            // Imprime o resultado
            System.out.println( "Contas do Banco" );
            System.out.println( "Conta\tNome\tAgencia\tSaldo" );
            while ( resultSet.next() ) {
                System.out.println( resultSet.getInt( 1 ) + "\t" + 
                resultSet.getString( 2 ) + "\t" +
                resultSet.getInt( 3 ) + "\t" + 
                resultSet.getFloat( 4 ) );
            }
            
            // Fecha a conexão com o banco
            statement.close();
            connection.close();
        }
        catch ( SQLException sqlex ) {
            sqlex.printStackTrace();
        }
    }
}