/******************************************************************
 *                        EXAMPLE2.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - vkladani a mazani zaznamu.                                   *
 * Max OTTA, 5/2000                                               *
 *                                                                *
 * Prelozeni a spusteni programu :                                *
 *                                                                *
 * javac example2.java                                            *
 * java  example2                                                 *
 ******************************************************************/

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

public class example2 {

    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;
	int nrows;
	PreparedStatement st;
	float  plat;

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

	    /*
	     * JDBC driver dela automaticky COMMIT po kazdem
             * volani executeUpdate(). Zde jej vypnem.
	     */
	    db.setAutoCommit(false);

	    st = db.prepareStatement(
              "INSERT INTO osoby (jmeno, prijmeni, naroz, plat)" +
              "  VALUES(?, ?, ?, ?)");

	    st.setString(1, "Pavel");
	    st.setString(2, "Pavlovic");
	    st.setDate(3, Date.valueOf("1966-12-31"));
	    plat = (float) 3333.55;
	    st.setFloat(4, plat);

	    nrows = st.executeUpdate();
	    st.close();
	    db.commit();

	    st = db.prepareStatement(
              "DELETE FROM osoby" +
              " WHERE plat > ?");

            st.setFloat(1, plat);

            nrows = st.executeUpdate();
	    st.close();
	    db.commit();

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