private void btn_modifierAdhActionPerformed(java.awt.event.ActionEvent evt) {                                                
        if(evt.getSource() == btn_modifierAdh){
            try {
                int adhId;
                String code;
                int ligne = tableadherent.getSelectedRow();
                if(tableadherent.isRowSelected(ligne)){
                    adhId = Integer.parseInt(tableadherent.getValueAt(ligne, 9).toString()); // 9 est la position du champ Id dans la table1
                    code = jcb_exeAccueil.getSelectedItem().toString();
                   
                    String sql = "SELECT * FROM Adherent WHERE adhId = ? AND code = ?";
                    PreparedStatement pstmt = conn.prepareStatement(sql);
                    pstmt.setInt(1, adhId);
                    pstmt.setString(2, code);
                    ResultSet rs = pstmt.executeQuery();
                    rs.next();

                    String civil = rs.getString("civil");
                    String nom = rs.getString("nom");
                    String prenom = rs.getString("prenom");
                    String cni = rs.getString("CNI");
                    Date dateNaiss = rs.getDate("dateNaiss");
                    String phone1 = rs.getString("phone1");
                    String phone2 = rs.getString("phone2");
                    String pays = rs.getString("pays");
                    String ville = rs.getString("ville");
                    String quartier = rs.getString("quartier");
                    String rue = rs.getString("rue");
                    String email = rs.getString("email");
                    String pathPhoto = rs.getString("photo");
                    String nomMed = rs.getString("nomMed");
                    String paysMed = rs.getString("paysMed");
                    String villeMed = rs.getString("villeMed");
                    String quartierMed = rs.getString("quartierMed");
                    String phone1Med = rs.getString("phone1Med");
                    String phone2Med = rs.getString("phone2Med");
                    String emailMed = rs.getString("emailMed");
                    String persAprev1 = rs.getString("persAprev1");
                    String phone1persAprev1 = rs.getString("phone1persAprev1");
                    String phone2persAprev1 = rs.getString("phone2persAprev1");
                    String phone3persAprev1 = rs.getString("phone3persAprev1");
                    String emailpersAprev1 = rs.getString("emailpersAprev1");
                    /////////////////////////////////////////////////////////////////
                    String persAprev2 = rs.getString("persAprev2");
                    String phone1persAprev2 = rs.getString("phone1persAprev2");
                    String phone2persAprev2 = rs.getString("phone2persAprev2");
                    String phone3persAprev2 = rs.getString("phone3persAprev2");
                    String emailpersAprev2 = rs.getString("emailpersAprev2");

                    fa.setAdhId(adhId);
                    fa.fillJtfExeAccueil(jcb_exeAccueil.getSelectedItem().toString());
                    fa.setCivil(civil);
                    fa.setNom(nom);
                    fa.setPrenom(prenom);
                    fa.setCni(cni);
                    fa.setDateNaiss(dateNaiss);
                    fa.setPhone1(phone1);
                    fa.setPhone2(phone2);
                    fa.fillComboPays(fa.jcb_pays);
                    fa.setPays(pays);
                    fa.setVille(ville);
                    fa.setQuartier(quartier);
                    fa.setRue(rue);
                    fa.setEmail(email);
                    fa.setPhoto(pathPhoto);
                    fa.setNomMed(nomMed);
                    fa.fillComboPays(fa.jtf_paysMed);
                    fa.setPaysMed(paysMed);
                    fa.setVilleMed(villeMed);
                    fa.setQuartierMed(quartierMed);
                    fa.setPhone1Med(phone1Med);
                    fa.setPhone2Med(phone2Med);
                    fa.setEmailMed(emailMed);
                    fa.setPersAprev1(persAprev1);
                    fa.setPhone1PersAprev1(phone1persAprev1);
                    fa.setPhone2PersAprev1(phone2persAprev1);
                    fa.setPhone3PersAprev1(phone3persAprev1);
                    fa.setEmailPersAprev1(emailpersAprev1);
                    fa.setPersAprev2(persAprev2);
                    fa.setPhone1PersAprev2(phone1persAprev2);
                    fa.setPhone2PersAprev2(phone2persAprev2);
                    fa.setPhone3PersAprev2(phone3persAprev2);
                    fa.setEmailPersAprev2(emailpersAprev2);   
                    
                    fa.btn_enr.setVisible(false);
                    fa.btn_modif.setVisible(true);

                    fa.setVisible(true);

                    if(fa.getIsUpdate()){
                        afficherAdherentBegin(ligne);
                        afficherFicheAdherent(ligne);
                        afficherAdherentTable4();
                        afficherAdherentCaisseTable8(); 
                        fillComboAdh(jcb_Adh);
                    }
                } else {
                     JOptionPane.showMessageDialog(this, "Veuillez sélectionner un adhérent !");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }