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());

        Connection connection = null;
        Statement stmt = null;
        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_ID,DOCTOR_TITLE,DOCTOR_NAME,DOCTOR_SURNAME,DOCTOR_DOB,DOCTOR_EMAIL,DOCTOR_PASSWORD,DOCTOR_TELNUMBER,HOSPITAL_CODE) "
                                + "VALUES (10,'"+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");
        }
    }

    private void backBTNActionPerformed(java.awt.event.ActionEvent evt) {
        LayoutManager layout = getParent().getLayout();
        if (layout instanceof CardLayout) {
            CardLayout cl = (CardLayout)layout;
            cl.show(getParent(), "DOCWELCOME");
        }