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

public class Azuriranje {
	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 i naziv roka koji zelite da promenite");
			int godina = input.nextInt();
			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("UPDATE ispitni_rok " +
														  "SET naziv = ?, " +
														  "pocetak_prijavljivanja = ?, " +
														  "kraj_prijavljivanja = ?, " +
														  "tip = ? " +
														  "WHERE godina = ? and oznaka = ?");

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

			int insCount = upit.executeUpdate();

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

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

}