package Cas3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;

public class Zadatak {

    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");

            Scanner sc = new Scanner(System.in);
            System.out.println("ID nastavnika:");
            String id = sc.nextLine();
            System.out.println("Ime nastavnika:");
            String ime = sc.nextLine();
            System.out.println("Prezime nastavnika:");
            String prezime = sc.nextLine();
            System.out.println("Zvanje:");
            String zvanje = sc.nextLine();

            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, Integer.parseInt(id));
                ps1.setString(2, ime);
                ps1.setString(3, prezime);
                ps1.setString(4, zvanje);

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

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

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

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