import java.sql.*;
import java.io.FileInputStream;
import java.util.Properties;
class jdbcCities2 {
  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:@s4.ifi.informatik.uni-goettingen.de:1521:dbis";
 Properties props = new Properties();
 try { props.load(new FileInputStream("connect.properties")); }
     catch(Exception e) {;}
 Connection conn = DriverManager.getConnection(url, props);
 // 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();
}}