// Programm 3-2: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/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"));
  }
}