package demo;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.Instant;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.Locale;
import java.util.Scanner;
import java.util.TimeZone;
import java.sql.Timestamp;

public class Dao {
	Connection con = null;

	public Dao(Connection con) {
		this.con = con;
	}

	public void execute() throws SQLException, ClassNotFoundException, ParseException {
		ArrayList<String> username = new ArrayList<>();
		ArrayList<String> pwd = new ArrayList<>();

		/*Scanner lettore = new Scanner(System.in);
		System.out.print("Inserisci username: ");
		String nome = lettore.nextLine();
		System.out.print("Inserisci password: ");
		String pass = lettore.nextLine();
		*/

		/*for(int i = 0; i < username.size(); i++) {
			if(nome.equals(username.get(i)) && pass.equals(pwd.get(i))) {
				System.out.print("ok");
			}
			else {
				System.out.println("dati non corrispondono");
			}
		}*/

		java.sql.Timestamp date = new java.sql.Timestamp(new java.util.Date().getTime());

		Statement s = con.createStatement();

		ResultSet rs = s.executeQuery("select Username from Persone");
		ResultSetMetaData rsmd = rs.getMetaData();


		int columnsNumber = rsmd.getColumnCount();
		while (rs.next()) {
			for (int i = 1; i <= columnsNumber; i++) {
				if (i > 1)
					System.out.print(",  ");
				String columnValue = rs.getString(i);
				username.add(columnValue);

			}
			System.out.println("");
		}

		ResultSet rs2 = s.executeQuery("select Pwd from Persone");
		while (rs2.next()) {
			for (int i = 1; i <= columnsNumber; i++) {
				if (i > 1)
					System.out.print(",  ");
				String columnValue2 = rs2.getString(i);
				pwd.add(columnValue2);

			}
			System.out.println("");
		}



		Persona p2 = new Persona("Ssssalsa", "Hilfiger", "Tommy", "New York", "auaa", date);

		String q = "INSERT INTO Persone " + "VALUES ('" + p2.getUsername() + "','" + p2.getCognome() + "','"
				+ p2.getNome() + "','" + p2.getCittà() + "','" + p2.getPwd() + "','" + p2.getData() + "'" + ")";

		if (username.isEmpty()) {
			s.executeUpdate(q);
		} else {
			for (int i = 0; i < username.size(); i++) {
				if (p2.getUsername().equals(username.get(i))) {
					System.out.println("Username già esistente!");
				} else {
					s.executeUpdate(q);
				}
			}
		}

	}

}