import java.sql.*;
import java.util.Scanner;

public class Unos {
	static{
		try{
			Class.forName("com.ibm.db2.jcc.DB2Driver");

		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		try{
			Connection con = null;
			String url = "jdbc:db2://localhost:50001/vstud";

			if(args.length == 0){
				con = DriverManager.getConnection(url,"student","abcdef");
			}
			else if(args.length == 2){
				con = DriverManager.getConnection(url,args[1],args[2]);
			}
			else{
				throw new Exception("\nUsage java MyJDBC[,username,passwd]");
			}

			//TODO Zameniti scannere input poljima

			Scanner input = new Scanner(System.in);

			System.out.println("Unesite Godinu");
			int godina = input.nextInt();
			System.out.println("Unesite oznaku");
			String oznaka = input.next();
			System.out.println("Unesite naziv");
			String naziv = input.next();
			System.out.println("Unesite pocetak u formatu gggg-mm-dd");
			String pocetak = input.next();
			System.out.println("Unesite kraj");
			String kraj = input.next();
			System.out.println("Unesite tip");
			String tip = input.next();

			input.close();

			PreparedStatement upit = con.prepareStatement("INSERT INTO ispitni_rok " +
														  "values(?,?,?,?,?,?)");

			upit.setInt(1, godina);
			upit.setString(2, oznaka);
			upit.setString(3, naziv);
			upit.setDate(4, java.sql.Date.valueOf(pocetak));
			upit.setDate(5, java.sql.Date.valueOf(kraj));
			upit.setString(6, tip);

			int insCount = upit.executeUpdate();

			System.out.println("Uspelo kao:" + insCount);

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

}