// Programm 4-6:  ./JDBCelementar/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"));
      System.out.println(rn.getString("nachname"));
    }
  }
}