// Programm 4-3:  ./JDBCelementar/TreiberInterfaces.java
import sun.jdbc.odbc.*; 
import java.util.*;
import java.sql.*;

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