// Programm 2-6: BSP_ROOT/meinewebapp/WEB-INF/classes/relsql/GroupBy.java 
import java.sql.*;
public class GroupBy {
  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();
    String sql = "SELECT typ, COUNT(*) AS count FROM Kurse GROUP BY typ";
    ResultSet sr =s.executeQuery(sql);
    while(sr.next()) {
      String typ = sr.getString("typ");
      System.out.println(typ+", " + sr.getString("count") + "x");
      Statement t = c.createStatement();
      ResultSet tr = t.executeQuery("SELECT * FROM Kurse WHERE typ LIKE'"+typ+"'");
      while(tr.next()) {
        System.out.print(" > "+ tr.getString("datum")+ ":  ");
        System.out.println(tr.getString("bezeichnung"));
      }
    }
  }
}