// Programm 3-6: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/StatementUndResultset2.java
import java.sql.*;
public class StatementUndResultset2 {
  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 rn = s.executeQuery("SELECT * FROM Personen");
    while(rn.next()) {
      System.out.println(rn.getString("nachname"));     // zum Ersten und ...
      System.out.println(rn.getString("nachname"));     // ... zum Zweiten
    }
  }
}