JTable

//Exibe em forma de tabela/listagem a tabela GG_STUDENT. 

package packs; 

import java.sql.*; 
import java.awt.*; 
import javax.swing.*; 
import java.awt.*; 
import java.awt.event.*; 
import java.util.*; 

public class TableDisplay extends JFrame { 
   private Connection connection; 
   private JTable table; 
    
   public TableDisplay() { 
      super("Listagem geral dos Pacientes"); 

      String url = "jdbc:odbc:banco.mdb"; 
      String username = "paulo"; 
      String password = "cesar"; 
       
      try { 
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
         connection = DriverManager.getConnection(url, username, password); 
      } 
      catch (ClassNotFoundException cnfex) { 
         System.err.println( 
            "Falhou a conexao com o banco"); 
         cnfex.printStackTrace(); 
          System.exit(1); 
      } 
      catch (SQLException sqlex) { 
          System.err.println("Conexao desabilitada");    
          sqlex.printStackTrace(); 
      } 
       
      getTable(); 
      setSize(800,370); 
      setLocation(5,20); 
      show(); 
   } 
    
   private void getTable() 
   { 
      Statement statement; 
      ResultSet resultset; 
       
      try { 
         String query = "Select * from Tab_Pacientes order by nome"; 
         statement = connection.createStatement(); 
         resultset = statement.executeQuery(query); 
         displayResultSet(resultset); 
         statement.close(); 
       } 
      catch ( SQLException sqlex ) { 
         sqlex.printStackTrace(); 
      } 
   } 
    
   private void displayResultSet(ResultSet rs ) 
      throws SQLException 
   { 
      boolean moreRecords = rs.next(); 
       
      if (! moreRecords) { 
         JOptionPane.showMessageDialog(this, "Nao existem registros na tabela!!"); 
         setTitle("Registros Vazios"); 
         return; 
      } 
       
//      setTitle("Listagem Geral dos dados - Tabela Student - bancoDB"); 
       
      Vector columnHeads = new Vector(); 
      Vector rows = new Vector(); 
       
      try { 
         ResultSetMetaData rsmd = rs.getMetaData(); 
         for (int i = 1; i <= rsmd.getColumnCount(); ++i) 
            columnHeads.addElement(rsmd.getColumnName(i)); 
             
         do { 
            rows.addElement(getNextRow(rs, rsmd)); 
         } while (rs.next()); 
          
         table = new JTable(rows, columnHeads); 
         JScrollPane scroller = new JScrollPane(table); 
         getContentPane().add(scroller,BorderLayout.CENTER); 
         validate(); 
      } 
      catch (SQLException sqlex) { 
         sqlex.printStackTrace(); 
      } 
   } 
    
   private Vector getNextRow( ResultSet rs, ResultSetMetaData rsmd)    
        throws SQLException 
   { 
      Vector currentRow = new Vector(); 
      for (int i = 1; i <= rsmd.getColumnCount(); ++i) 
         switch(rsmd.getColumnType(i)) { 
            case Types.VARCHAR: currentRow.addElement(rs.getString(i)); 
              break; 
            case Types.INTEGER:currentRow.addElement(new Long(rs.getLong(i))); 
              break; 
              /*case Types.LONGCHAR:currentRow.addElement(rs.getString(i)); 
                break;*/ 
            default: System.out.println("Tipo dos Dados: " + rsmd.getColumnTypeName(i)); 
       } 
     return currentRow; 
   } 
    
   public void shutDown() 
   { 
      try { 
         connection.close(); 
      } 
      catch (SQLException sqlex) { 
         System.err.println("N� foi poss�el desconectar."); 
         sqlex.printStackTrace(); 
      } 
   } 
    
   public static void montaTable() 
   { 
//      try {   //Faz o aplicativo ter apar�cias. 
//           UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); 
          //UIManager.setLookAndFeel(UIManager.getCrossPlatformLookAndFeelClassName()); 
//      } catch (Exception exc) { 
//          System.err.println("Error loading L&F: " + exc); 
//      } 
      final TableDisplay app = new TableDisplay(); 
       app.addWindowListener(new WindowAdapter() { 
          public void windowClosing(WindowEvent e) 
          { 
             //app.shutDown(); 
             //System.exit(0); 
          } 
       } 
     ); 
//   } 
    public static void main(String args[]) { 
        montaTable(); 
     }    
}