String title = (String) titleCB.getSelectedItem();
        String name = nameTF.getText();
        String surname = surnameTF.getText();
        String year = (String) yearCB.getSelectedItem();
        String month = (String) monthCB.getSelectedItem();
        String day = (String) dayCB.getSelectedItem();
        String email = emailTF.getText();
        String password = new String(passwordPF.getText());
        String emailcon = emailconfirmTF.getText();
        String passwordcon = new String(passwordconfirmPF.getText());
        Connection connection = null;
        Statement stmt = null;

        if (emailcon.equals(email)) {
            if (passwordcon.equals(password)) {
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    connection = DriverManager
                            .getConnection("jdbc:mysql://localhost:3306/healthapp", "root", "");

                    stmt = connection.createStatement();
                    stmt.execute("INSERT INTO DOCTOR (DOCTOR_TITLE,DOCTOR_NAME,DOCTOR_SURNAME,DOCTOR_DOB,DOCTOR_EMAIL,DOCTOR_PASSWORD,DOCTOR_TELNUMBER,HOSPITAL_CODE) "
                            + "VALUES ('" + title + "','" + name + "','" + surname + "','" + year + "-" + month + "-" + day + "','" + email + "','" + password + "','+353868728668','9')");
                } catch (Exception e) {
                    e.printStackTrace();
                } finally {
                    try {
                        stmt.close();
                        connection.close();
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }

                LayoutManager layout = getParent().getLayout();
                if (layout instanceof CardLayout) {
                    CardLayout cl = (CardLayout) layout;
                    cl.show(getParent(), "WELCOME");
                }
            }
            else{
                JOptionPane.showMessageDialog(null, "passwords do not match, please try again");
            }
        } else {
            JOptionPane.showMessageDialog(null, "emails do not match, please try again");
        }





String title = (String) titleCB.getSelectedItem();
        String name = nameTF.getText();
        String surname = surnameTF.getText();
        String year = (String) yearCB.getSelectedItem();
        String month = (String) monthCB.getSelectedItem();
        String day = (String) dayCB.getSelectedItem();
        String email = emailTF.getText();
        String password = new String(passwordPF.getText());
        String emailcon = emailconfirmTF.getText();
        String passwordcon = new String(passwordconfirmPF.getText());
        String city = cityTF.getText();
        String country = (String) countryCB.getSelectedItem();
        String address = addressTF.getText();

        Connection connection = null;
        Statement stmt = null;

        if (emailcon.equals(email)) {
            if (passwordcon.equals(password)) {
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    connection = DriverManager
                            .getConnection("jdbc:mysql://localhost:3306/healthapp", "root", "");

                    stmt = connection.createStatement();
                    stmt.execute("INSERT INTO PATIENT (PATIENT_TITLE,PATIENT_NAME,PATIENT_SURNAME,PATIENT_DOB,PATIENT_EMAIL,PATIENT_PASSWORD,PATIENT_ADDRESS,PATIENT_CITY,PATIENT_COUNTRY) "
                            + "VALUES ('" + title + "','" + name + "','" + surname + "','" + year + "-" + month + "-" + day + "','" + email + "','" + password + "','"+address+"', '"+city+"','"+country+"')");
                } catch (Exception e) {
                    e.printStackTrace();
                } finally {
                    try {
                        stmt.close();
                        connection.close();
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }

                LayoutManager layout = getParent().getLayout();
                if (layout instanceof CardLayout) {
                    CardLayout cl = (CardLayout) layout;
                    cl.show(getParent(), "WELCOME");
                }
            }
            else{
                JOptionPane.showMessageDialog(null, "passwords do not match, please try again");
            }
        } else {
            JOptionPane.showMessageDialog(null, "emails do not match, please try again");
        }