import java.sql.*;
class jdbcCities {
  public static void main (String args [])
   throws SQLException {
 // Oracle-Treiber laden
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 // Verbindung zur Datenbank herstellen
 String url =
    "jdbc:oracle:thin:@oracle11.informatik.uni-goettingen.de:1521:dbis";
 Connection conn =
    DriverManager.getConnection(url,"scott","tiger");
 // Anfrage an die Datenbank
 Statement stmt = conn.createStatement();
 ResultSet rset =
   stmt.executeQuery("SELECT Name, Population FROM City");
 while (rset.next()) {
      // Verarbeitung der Ergebnismenge
  String s = rset.getString(1);
  int i = rset.getInt("Population");
  System.out.println (s + " " + i + "\n"); }
 conn.close();
}}
