// Programm 1-3: BSP_ROOT/meinewebapp/WEB-INF/classes/intro/FuenfSchritte.java
  import java.sql.*; 
  public class FuenfSchritte {
    public static void main(String[] args) throws Exception {

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection c = DriverManager.getConnection("jdbc:odbc:Kurse");
      Statement s = c.createStatement();
      s.execute("SELECT * FROM Personen WHERE nachname LIKE 'K%'");
      ResultSet r = s.getResultSet();
      while(r.next())
        System.out.println(r.getString("vorname")+" "+r.getString("nachname"));
      c.close();
    }
  }