// Programm 3-3: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/TreiberInterfaces.java
import java.util.*;
import java.sql.*;
public class TreiberInterfaces {
  public static void main(String[] args) throws Exception {
    Driver d = new sun.jdbc.odbc.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"));
  }
}