package Zaddatak_2;

import java.io.*;
import java.sql.*;

public class Test_5 {

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

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

			BufferedReader in = new BufferedReader(new InputStreamReader(System.in));

			System.out.println("Uneti nastavnika");

			String s = in.readLine();
			String s1[] = s.split(",");

			BufferedReader in1 = new BufferedReader(new InputStreamReader(System.in));
			System.out.println("uneti predmet");

			String p = in1.readLine();

			String p1[] = p.split(",");

			try (Connection conn = DriverManager.getConnection(CONN, "baze2", "baze2")) {

				//Statement stmt = conn.createStatement();
				//ResultSet rs = stmt.executeQuery(s);

				//ResultSetMetaData meta = rs.getMetaData();

				PreparedStatement nas = conn
						.prepareStatement("insert into nastavnik(nastavnik_id,ime,prezime,zvanje) values(?,?,?,?)");// prepeader
																														// sa
																														// ?
																														// mozeom
																														// da
																														// namestamo
																														// parametne

				nas.setInt(1, Integer.parseInt(s1[0]));
				nas.setString(2, s1[1]);
				nas.setString(3, s1[2]);
				nas.setString(4, s1[3]);

				nas.executeUpdate();


				PreparedStatement stmt1=conn.prepareStatement("select * from nastavnik");

				int a=stmt1.executeUpdate();
				System.out.println(a);

				PreparedStatement pr=conn.prepareStatement("insert into predmet(predmet_id,naziv)values(?,?)");

				pr.setInt(1, Integer.parseInt(p1[0]));
				pr.setString(2, p1[1]);

				pr.executeUpdate();



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