// Programm 4-5:  ./JDBCelementar/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 rn = s.executeQuery("SELECT * FROM Personen");
    ResultSet rv = s.executeQuery( "SELECT * FROM Dozenten");
    while(rn.next())
      System.out.println(rn.getString("nachname"));
  }
}                          // Ende class StatementUndResultset1