import java.sql.*;

public class GebJahr {
 public static void main (String[] args) {
  try {
    System.out.println("* Treiber laden");
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    System.out.println("* Datenbank-Verbindung beginnen");
    Connection con = DriverManager.getConnection
        ("jdbc:odbc:TestDB1", "", "");
    con.setReadOnly(true);
    System.out.println("* Statement beginnen");
    Statement stmt = con.createStatement();

    System.out.println("* Abfrage beginnen");
    ResultSet rs = stmt.executeQuery
      ("SELECT Vorname, Geburtsjahr FROM Mitarbeiter ORDER BY Vorname");
    System.out.println("* Ergebnisse anzeigen");
    while (rs.next()) {
      System.out.println( rs.getString(1) + " " + rs.getInt(2) );
    }

    System.out.println("* Statement beenden");
    stmt.close();
    System.out.println("* Datenbank-Verbindung beenden");
    con.close();
  } catch (Exception e) {
      System.out.println("*** Fehler: " + e);
  }
 }
}