/*
 * Hauptfenster.java
 *
 */

package gui;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Vector;
import javax.swing.JTable;


public class Hauptfenster extends javax.swing.JFrame {
    
    /** Creates new form Hauptfenster */
    public Hauptfenster() {
        initComponents();
        aktualisiereTabelle();
    }
    
    private void aktualisiereTabelle() {
        Vector columnNames = new Vector();
        Vector data = new Vector();
        try{
            //Abfrage definieren
            String query = "SELECT * FROM adressen;";
            //Datenbankverbindung herstellen
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection( "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/tutorial/kontakte.mdb","","" );
            System.out.println("Connection Successful ");
            Statement stmt = con.createStatement();
            ResultSet rst = stmt.executeQuery(query);
            ResultSetMetaData md = rst.getMetaData();
            int columns = md.getColumnCount();
            //  Spaltennamen ermitteln
            for (int i = 1; i <= columns; i++) {
                String colname=md.getColumnName(i);
                columnNames.addElement( colname );
            }
            //  Zeileninhalt ermitteln
            while (rst.next()) {
                Vector row = new Vector(columns);
                for (int i = 1; i <= columns; i++) {
                    row.addElement( rst.getObject(i) );
                }
                data.addElement( row );
            }
            rst.close();
            stmt.close();
        } catch(Exception e) {
            e.printStackTrace();
        }
        //  Tabelle erzeugen
        JTable table = new JTable(data, columnNames);
        scrollTabelle.setViewportView(table);
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">//GEN-BEGIN:initComponents
    private void initComponents() {
        scrollTabelle = new javax.swing.JScrollPane();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        getContentPane().add(scrollTabelle, java.awt.BorderLayout.CENTER);

        java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-800)/2, (screenSize.height-200)/2, 800, 200);
    }// </editor-fold>//GEN-END:initComponents
    
    /**
     * MAIN-Methode
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Hauptfenster().setVisible(true);
            }
        });
    }
    
    // Variablendeklaration
    private javax.swing.JScrollPane scrollTabelle;
    
}