import java.sql.*;

public class mein {

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

    public static void main(String args[]) throws SQLException {
        Connection conn = DriverManager.getConnection(CONN_STR, "baze2", "baze2");
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            System.out.println("UCITAN DRIVER");


            Statement stmnt = conn.createStatement();
            /*ResultSet rs = stmnt.executeQuery("Select p.naziv from Nastavnik n, Predmet p, predaje pj "
                    + " where n.nastavnik_id = pj.nastavnik_id and p.predmet_id = pj.predmet_id and ime = 'Ana'");



            while(rs.next()) {
                System.out.println(rs.getString(1));
            }
            */
            //ISCITAVANJE SVEGA
            ResultSet rs = stmnt.executeQuery("Select * from nastavnik");
            while(rs.next()) {
                System.out.println(rs.getInt(1)+", "+rs.getString(2)+", "+rs.getString(3)+", "+rs.getString(4));

            }
            stmnt.execute("delete from nastavnik where zvanje='podpukovnik u penziji'");
            //dodavanje u tabelu
//           int broj = stmnt.executeUpdate("INSERT INTO NASTAVNIK values (64617, 'MILE', 'SEVIC', 'bik') ");
//           System.out.println("dodato:" + broj);

            //conn.setAutoCommit(false); //na testu ce biti povezana brisanja//


//          PreparedStatement pstmt = conn.prepareStatement("Insert into Nastavnik values(?, ?, ?, ?)");
//
//           pstmt.setInt(1, 5112122);
//           pstmt.setString(2, "Klemi");
//           pstmt.setString(3, "SEVIC");
//           pstmt.setString(4, "BB");
//           pstmt.executeUpdate();
//
//           pstmt.setInt(1, 511);
//           pstmt.setString(2, "Klemi");
//           pstmt.setString(3, "SEVIC");
//           pstmt.setString(4, "BB");
//           pstmt.executeUpdate();
//
//
//
//           pstmt.close();
//
             //conn.commit();

            rs.close();
            stmnt.close();
            conn.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
            try {
                conn.rollback();
            } catch(Exception ex) {
                ex.printStackTrace();
            }
        } finally {
            try {
                conn.close();
            } catch(Exception ex1) {
                ex1.printStackTrace();
            }
        }

    }

}