// Programm 4-2:  ./JDBCelementar/TreiberKlassen.java
import java.util.*;
import sun.jdbc.odbc.*; 
// import java.sql.*;  hier nicht erforderlich!!

public class TreiberKlassen {
  public static void main(String[] args) throws Exception {
    JdbcOdbcDriver d = new JdbcOdbcDriver();
    Properties p = new Properties();
    p.put("user", "gast"); p.put("password", "");
    JdbcOdbcConnection c = 
          (JdbcOdbcConnection) d.connect("jdbc:odbc:Kurse", p);
    JdbcOdbcStatement s = 
                       (JdbcOdbcStatement) c.createStatement();
    JdbcOdbcResultSet r = (JdbcOdbcResultSet) s.executeQuery(
         "SELECT * FROM Personen WHERE nachname LIKE 'K%'");
    while(r.next())
      System.out.println(r.getString("nachname") + ", " +
                         r.getString("vorname"));
  }
}                                  // Ende class TreiberKlassen