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