package Cas3;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Types;

public class Primer1 {

    private final static String CONN_STRING = "jdbc:oracle:thin:@nastava.is.pmf.uns.ac.rs:1521:xe";

    public static void main(String[] args) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            System.out.println("Ucitao oracle dirver");

            try (Connection conn = DriverManager.getConnection(CONN_STRING, "baze2", "baze2")){
                conn.setAutoCommit(false);

                PreparedStatement ps1 =
                        conn.prepareStatement("insert into nastavnik (nastavnik_id, ime, prezime, zvanje) values (?, ?, ?, ?)");
                ps1.setInt(1, 1239875);
                ps1.setString(2, "Aleksa");
                ps1.setString(3, "Novkovic");
                ps1.setString(4, "student");

                System.out.println("UPDATE 1 vratio: " + ps1.executeUpdate());

                PreparedStatement ps2 = conn.prepareStatement("insert into predmet (predmet_id, naziv) values (?, ?)");
                ps2.setInt(1, 1239875);
                ps2.setString(2, "Opstenarodna ribologija");

                System.out.println("UPDATE 2 vratio: " + ps2.executeUpdate());

                CallableStatement cs = conn.prepareCall("{ ? = call povezi (?, ?, ?)}");
                cs.registerOutParameter(1, Types.INTEGER);
                cs.setString(2, "Aleksa");
                cs.setString(3, "Milosevic");
                cs.setString(4, "Opstenarodna ribologija");

                cs.executeQuery();

                System.out.println("funkcija vratila: " + cs.getInt(1));

                conn.commit();//rollback();

            } catch (Exception e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

    }

}