/******************************************************************
 *                        EXAMPLE5.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - Dynamicke SQL. Mluvit v kontextu JDBC o dynamickem SQL nema  *
 *   prakticky smysl. Priklad slouzi pouze ke srovnani stejne     *
 *   ulohy ve vnorenem SQL (v jazyce C - viz EXAMPLE6.ESQL).      *
 * Max OTTA, 5/2000                                               *
 *                                                                *
 * Prelozeni a spusteni programu :                                *
 *                                                                *
 * javac example5.java                                            *
 * java example5 "plat < 1000"                                    *
 * java example5 "plat > 2000 and jmeno = 'Pavel'"                *
 * java example5 "prijmeni like 'Hon%'"                           *
 ******************************************************************/

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

public class example5 {

    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;
	PreparedStatement st;
	ResultSet rs;

	if (args.length != 1) {
	    System.out.println("Chybi parametr.");
	    return;
	}
	try {
	    Class.forName(driver);
	} catch (ClassNotFoundException e) {
	    System.out.println("Nemohu najit ovladac.");
	    return;
	}
	try {
	    db = DriverManager.getConnection(dburl, user, pwd);

            st = db.prepareStatement(
              "SELECT  prijmeni, jmeno, plat" +
              "  FROM  osoby" +
              " WHERE  " + args[0]);

	    rs = st.executeQuery();

	    if (rs != null) {
		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 ***/