// Programm 2-7: BSP_ROOT/meinewebapp/WEB-INF/classes/relsql/GroupByHaving.java 
import java.sql.*;
public class GroupByHaving {
  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";
    sql += " HAVING COUNT(typ) > 1";
    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"));
      }
    }
  }
}