// Programm 3-5: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/StatementUndResultset1.java
import java.sql.*;
public class StatementUndResultset1 {
  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 r1 = s.executeQuery("SELECT * FROM Personen");
    ResultSet r2 = s.executeQuery( "SELECT * FROM Dozenten");
    while(r1.next())
      System.out.println(r1.getString("nachname"));
  }
}