import java.sql.*;
class JdbcCities {
 public static void main (String args [])
  throws Exception {
 // Oracle-Treiber laden
 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 // Verbindung zur Datenbank herstellen
 props.load(new FileInputStream("conn.props"));
 Connection conn = DriverManager.getConnection(props.get("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); }
  rset.close(); stmt.close(); conn.close();
}}