import com.sun.org.apache.xerces.internal.dom.PSVIAttrNSImpl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;


//alt shift f za formatiranje koda

//nauciti i statement i prepairedstatement jer na testu naglase koji treba da se koristi
//vjezbaj getdate setdate

public class Main {

    private static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    private static String user = "student";
    private static String password = "student";

    public static void main(String[] args) {
        System.out.println("Pre unosa: ");
        vratiSvaOdeljenja();
        dodadajOdeljenje(999, "labis", "krusevac");
        System.out.println("Posle unosa: ");
        vratiSvaOdeljenja();


    }

    public static void dodadajOdeljenje(int sifra, String naziv, String grad){
        try {
            String query = "insert into odeljenje values(?, ?, ?)";
            Connection connection = DriverManager.getConnection(url, user, password);
            connection.setAutoCommit(false);
            //da ne commituje posle inserta u slucaju da od 10 nisu insertovani svi

            PreparedStatement ps = connection.prepareStatement(query);

            ps.setInt(1, sifra);
            ps.setString(2, naziv);
            ps.setString(3, grad);

            int number = ps.executeUpdate();
            //vraca br redova koji su se promenili u bazi
            //vraca 1
            if(number == 1)
                connection.commit();
            connection.rollback();

            ps.close();
            connection.close();

        } catch (SQLException ex) {
            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

    public static void vratiSvaOdeljenja() {

        String query = "SELECT * FROM odeljenje";

        try /*(Connection connection = DriverManager.getConnection(url, user, password);

            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery(query);)
        brisemo 3 linije ove ispod i one za close*/{
            Connection connection = DriverManager.getConnection(url, user, password);

            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery(query);

            while (rs.next()) {
                int sifraOdeljenja = rs.getInt("sifraodelj");
                String naziv = rs.getString(2);
                String grad = rs.getString("grad");

                System.out.println("Sifra: " + sifraOdeljenja + "Naziv: " + naziv + "grad: " + grad);
            }

            rs.close();
            stmt.close();
            connection.close();

        } catch (SQLException ex) {
            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

}