/******************************************************************
 *                        EXAMPLE1.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - jednoduchy dotaz s jednim parametrem.                        *
 * 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 example1.java                                            *
 * java  example1 Jiricka                                         *
 ******************************************************************/

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

public class example1 {

    /* Postgres (lokalni pristup) :
     * public static String driver = "postgresql.Driver";
     * public static String dburl  = "jdbc:postgresql:databaze";
     * public static String user = "uzivatel";
     * public static String pwd  = "";
     */
    /* Oracle : */
    public static String driver = "oracle.jdbc.driver.OracleDriver";
    public static String dburl  = "jdbc:oracle:thin:@stroj.zcu.cz:1521:databaze";
    public static String user = "uzivatel";
    public static String pwd  = "heslo";

    public static void main(String args[]) {
	Connection db;
	ResultSet  rs;
	PreparedStatement st;

	if (args.length != 1) {
	    System.out.println("Chybi parametr.");
	    return;
	}
	/*
	 * Prilinkovani pozadovaneho ovladace za behu.
	 */
	try {
	    Class.forName(driver);
	} catch (ClassNotFoundException e) {
	    System.out.println("Nemohu najit ovladac.");
	    return;
	}
	try {
	    /*
	     * Vytvoreni spojeni s databazi.
	     */
	    db = DriverManager.getConnection(dburl, user, pwd);
	    /*
	     * Specifikace dotazu. Mista pro parametry jsou oznacena otaznikem.
	     */
	    st = db.prepareStatement(
              "SELECT  prijmeni, jmeno, plat" +
              "  FROM  osoby" +
              " WHERE  prijmeni = ?");
	    /*
	     * Nastaveni prvniho parametru (podle poradi ve spec. dotazu).
	     */
	    st.setString(1, args[0]);
	    /*
	     * Spusteni dotazu. V pripade uspechu vraci objekt tridy ResultSet.
	     */
	    rs = st.executeQuery();

	    if (rs != null) {
		/*
		 * Opakuj, dokud jsou k dispozici zaznamy vybrane dotazem.
		 */
		while (rs.next()) {
		    System.out.println(
		      rs.getString("prijmeni") + " " +
                      rs.getString("jmeno") + " " +
		      rs.getString("plat"));
		}
		rs.close();
	    }
	    db.close();

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