userUtils.java

package database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import database.mainConnection;

public class userUtils extends mainConnection {

	public static void main(String[] args ) throws Exception {
		registerUser("mattia3","prova2", hash("password"), "mattia", "paccamiccio", "1994-12-01", "unicam");
	}

	public static Boolean registerUser(String username, String email, String password, String name, String surname, String birthDate, String affiliation) throws Exception {
		try{
			Connection con = getConnection();

			PreparedStatement query = con.prepareStatement("INSERT INTO users (Username, Email, Password, Name, Surname, BirthDate, Affiliation) VALUES (?,?,?,?,?,?,?)");
			query.setString(1, username);
			query.setString(2, email);
			query.setString(3, password);
			query.setString(4, name);
			query.setString(5, surname);
			query.setString(6, birthDate);
			query.setString(7, affiliation);

			int result = query.executeUpdate();
			//System.out.println("registrazione eseguita con successo");
			return true;
		} catch(Exception e) {
			System.out.println(e); }
		//System.out.println("registrazione fallita");
		return false;
	}

	public static Boolean userLogin(String username, String password) throws Exception {
		Boolean bool = true;
		try{
			Connection con = getConnection();
			PreparedStatement query = con.prepareStatement("SELECT * FROM users WHERE Username=? AND Password=?");
			query.setString(1, username);
			query.setString(2, password);

			ResultSet result = query.executeQuery();

			ArrayList<String> array = new ArrayList<String>();
				if(result.next()) {
					System.out.println("login effettuato");
				}
				else {
					System.out.println("login fallito");

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

}