import java.sql.*;

public class ConnectBD {
    private Connection con;
    private Statement st;
    private ResultSet rs;


    public ConnectBD() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/projectopdm", "root", "");
            st = con.createStatement();
        } catch (Exception e) {
            System.out.println("Error" + e);
        }
    }

    public boolean testPW(String email,String passe){
        String query="Select password from utilizador where IDUtilizador='"+email+"'";
        try{
            rs=st.executeQuery(query);
            if(rs.next()){
                String passeword=rs.getString(1);
                return passe.equals(passeword);
            }
        }catch(Exception e){
            System.out.println("ERROR: "+e);
        }
        return false;
    }

    public boolean inserirUser(String email,String nome,String passe,String dataNascimento){
        //completar
        return true;
    }

}