/******************************************************************
 *                        EXAMPLE6.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - Soucasne pripojeni do vice databazi.                         *
 * Max OTTA, 5/2000                                               *
 *                                                                *
 * Prelozeni a spusteni programu :                                *
 *                                                                *
 * Postgres :                                                     *
 * CLASSPATH = $CLASSPATH:$PGLIB/postgresql.jar                   *
 * export CLASSPATH                                               *
 *                                                                *
 * Oracle 8i (Linux) :                                            *
 * CLASSPATH = $CLASSPATH:$ORACLE_HOME/jdbc/lib/classes111.zip    *
 * CLASSPATH = $CLASSPATH:$ORACLE_HOME/jdbc/lib/nls_charset11.zip *
 * export CLASSPATH                                               *
 *                                                                *
 * javac example6.java                                            *
 * java  example6                                                 *
 ******************************************************************/

import java.lang.*;
import java.sql.*;

public class example6 {

    /* Postgres (lokalni pristup) : */
    public static String pg_driver = "postgresql.Driver";
    public static String pg_dburl  = "jdbc:postgresql:pgdb";
    public static String pg_user = "uzivatel";
    public static String pg_pwd  = "";

    /* Oracle : */
    public static String ora_driver = "oracle.jdbc.driver.OracleDriver";
    public static String ora_dburl  = "jdbc:oracle:thin:@stroj.zcu.cz:1521:oradb";
    public static String ora_user = "uzivatel";
    public static String ora_pwd  = "heslo";

    public static void main(String args[]) {
	Connection db1, db2;
	ResultSet  rs1, rs2;
	PreparedStatement st1, st2;
	String cmd = "SELECT prijmeni, jmeno, plat FROM osoby";

	try {
	    Class.forName(pg_driver);
	} catch (ClassNotFoundException e) {
	    System.out.println("Nemohu najit ovladac pro Postgres.");
	    return;
	}
	try {
	    Class.forName(ora_driver);
	} catch (ClassNotFoundException e) {
	    System.out.println("Nemohu najit ovladac pro Oracle.");
	    return;
	}
	try {
	    /*
	     * DriverManager na zaklade URL zavola spravny ovladac.
	     */
	    db1 = DriverManager.getConnection(pg_dburl, pg_user, pg_pwd);
	    db2 = DriverManager.getConnection(ora_dburl, ora_user, ora_pwd);

	    st1 = db1.prepareStatement(cmd);
	    st2 = db2.prepareStatement(cmd);

	    rs1 = st1.executeQuery();
	    rs2 = st2.executeQuery();

	    System.out.println();
	    System.out.println("Postgres :");
	    if (rs1 != null) {
		while (rs1.next()) {
		    System.out.println(
		      rs1.getString("prijmeni") + " " +
                      rs1.getString("jmeno") + " " +
		      rs1.getString("plat"));
		}
		rs1.close();
	    }

	    System.out.println();
	    System.out.println("Oracle :");
	    if (rs2 != null) {
		while (rs2.next()) {
		    System.out.println(
		      rs2.getString("prijmeni") + " " +
                      rs2.getString("jmeno") + " " +
		      rs2.getString("plat"));
		}
		rs2.close();
	    }

	    db1.close();
	    db2.close();
	    System.out.println();

	} catch (Exception e) {
	    System.out.println("Chyba :");
	    e.printStackTrace();
	}
    }
}
/*** EOF ***/