// Programm 3-6: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/StatementUndResultset3.java
import java.sql.*;
public class StatementUndResultset3 {
  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();
    ResultSet rs = s.executeQuery("SELECT * FROM Kurse");
    while(rs.next()) {
      System.out.print(rs.getString(2) + ", ");
      System.out.print(rs.getString("bezeichnung") + ", ");
      System.out.print(rs.getDate("datum") + ", ");
      System.out.println(rs.getInt(6));
    }
  }
}