package  InteractiveSQL;
 import  java.sql.*;
 import  javax.swing.table.*;
 import  java.util.Vector;


 public   class  ResultModel  extends  AbstractTableModel{
    
    /** Creates a new instance of ResultModel */
    
      public   void  setResultSet(ResultSet results){
        
         try {
            ResultSetMetaData metadata=results.getMetaData();
             int  columns=metadata.getColumnCount();
            columnNames= new  String[columns];
             for ( int  i= 0 ;i<columns;i++)
                columnNames[i]=metadata.getColumnLabel(i+ 1 );
            dataRows= new  Vector<String[]>();
            String[] rowData;
             while (results.next()){
                rowData= new  String[columns];
                 for ( int  i= 0 ;i<columns;i++)
                    rowData[i]=results.getString(i+ 1 );
                dataRows.addElement(rowData);
                
            }
            fireTableChanged( null );
        } catch (SQLException sqle){
            System.err.println(sqle);
        }
    }
     public   int  getColumnCount(){
         return  columnNames.length;
        
    }
     public   int  getRowCount(){
         if (dataRows== null )
             return   0 ;
         else 
             return  dataRows.size();
    }
     public  Object getValueAt( int  row,  int  column){
        
         return  ((String[])(dataRows.elementAt(row)))[column];
    }
     public  String getColumnName( int  column){
         return  columnNames[column]== null ?"No Name":columnNames[column];
    }
    
    String[] columnNames;
    Vector<String[]> dataRows;
}

 package  InteractiveSQL;
 import  java.awt.*;
 import  java.awt.event.*;
 import  javax.swing.*;
 import  javax.swing.table.*;
 import  java.sql.*;
        


 public   class  InteractiveSQL  extends  JFrame{
    
     public  Connection connection;
     public  Statement statement;
     public  ResultModel model;
    
    /**
     * @param args the command line arguments
     */
     public   static   void  main(String[] args) {
        // TODO code application logic here
        InteractiveSQL theApp= new  InteractiveSQL(
                "sun.jdbc.odbc.JdbcOdbcDriver",
                "jdbc:odbc:fantasy2go_access",
                "guest",
                "guest");
    }
    
    /** Creates a new instance of InteractiveSQL */
     public  InteractiveSQL(String driver, String url, String user, String password) {
         super ("InteractiveSQL"); 
        setBounds( 0 ,  0 ,  400 ,  300 ); 
        setDefaultCloseOperation(DISPOSE_ON_CLOSE);  
        addWindowListener( new  WindowHandler());  
        
        command.setToolTipText("Key SQL command and press Enter");
        getContentPane().add(command, BorderLayout.NORTH);
        
        
        status.setLineWrap(true);
        status.setWrapStyleWord(true);
        getContentPane().add(status, BorderLayout.SOUTH);
        
        
        JMenu fileMenu= new  JMenu("File");
        fileMenu.setMnemonic('F'); 
        fileMenu.add(clearQueryItem); 
        fileMenu.add(exitItem); 
        menuBar.add(fileMenu); 
        setJMenuBar(menuBar); 
        
        
        
         try {
             Class .forName(driver);
            connection=DriverManager.getConnection(url,user,password);
            statement=connection.createStatement();
            
            model= new  ResultModel();
            JTable table= new  JTable(model);
            
            table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
            
            resultsPane= new  JScrollPane(table);
            getContentPane().add(resultsPane,BorderLayout.CENTER);
            
        } catch (ClassNotFoundException cnfe){
            System.err.println(cnfe);
        } catch (SQLException sqle){
            System.err.println(sqle);
        }
        pack();
        setVisible(true);
        
    }
    
    JTextField command= new  JTextField();
    JTextArea status= new  JTextArea();
    
    JScrollPane resultsPane;
    JMenuBar menuBar= new  JMenuBar();
    JMenuItem clearQueryItem= new  JMenuItem("Clear Query");
    JMenuItem exitItem= new  JMenuItem("Exit");
    
    
    
     class  WindowHandler  extends  WindowAdapter{
        
         public   void  WindowClosing(WindowEvent e){
            dispose();
            System.exit( 0 );
        }
    }
}