import java.sql.*;

public class Tema6 {
	public static void main(String[] args) {
		String host = "jdbc:oracle:thin:@localhost:1521:xe";
		String uName = "STUDENT";
		String uPass = "STUDENT";

		try{
			//step1 load the driver class
			Class.forName("oracle.jdbc.driver.OracleDriver");

			//step2 create  the connection object
			Connection con = DriverManager.getConnection(host, uName, uPass);

			Angajat a = new Angajat("ttt", 999);

			Statement stmt = con.createStatement();
			stmt.executeUpdate("INSERT INTO OOP VALUES(angajat(\'" + a.getName() + "\', " + a.getSalary() + "))", Statement.RETURN_GENERATED_KEYS);

			Statement query = con.createStatement();

			/*ResultSet rs = query.executeQuery("SELECT * FROM OOP");
			while(rs.next()) {
				//System.out.println(rs.getString(1));
				//Angajat b = new Angajat(rs.getString(1), rs.getInt(2));
				Object[] attrs = ((oracle.sql.STRUCT) rs.getObject(1)).getAttributes();
				System.out.println("Result: " + attrs[0].toString());
			}*/
			//step5 close the connection object
			con.close();

		}catch(Exception e){ System.out.println(e);}
	}
}

class Angajat {
	private String nume;
	private Integer salariu;

	public Angajat(String nume, Integer salariu) {
		this.nume = nume;
		this.salariu = salariu;
	}

	public String getName() {
		return nume;
	}

	public Integer getSalary() {
		return salariu;
	}
}