/******************************************************************
 *                        EXAMPLE3.JAVA                           *
 *                                                                *
 * Ukazka JDBC.                                                   *
 * - zamykani zaznamu a jejich aktualizace.                       *
 * Max OTTA, 5/2000                                               *
 *                                                                *
 * Prelozeni a spusteni programu                                  *
 *  VYZADUJE JDBC 2.0 !!!                                         *
 *                                                                *
 * javac example3.java                                            *
 * java  example3                                                 *
 ******************************************************************/

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

public class example3 {

    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;
	float  plat;

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

	    db.setAutoCommit(false);

	    st = db.prepareStatement(
              "SELECT  prijmeni, jmeno, plat" +
              "  FROM  osoby" +
              " WHERE  plat < 2000" +
              " FOR UPDATE");

	    rs = st.executeQuery();

	    if (rs != null) {
		while (rs.next()) {
		    plat = rs.getFloat(3);
		    plat = plat * (float) 1.25;
		    rs.updateFloat(3, plat);
		    rs.updateRow(); /* teprve ted se provede UPDATE v databazi */
		}
		rs.close();
	    }

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