private void updatePersonne(int id, String adresse, String mail, String situation, String login, String oldMdp, String newMdp) {
         try {  
             
             String info = "La modification des données a été prise en compte"; 
         
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "margo", "margo");
            Statement statement = con.createStatement();
            ResultSet rs = statement.executeQuery("select p.ADRESSE,p.SITUATION,p.MDP,p.MAIL,p.LOGIN from PERSONNE p WHERE p.IDPERS="+id);
            
            rs.next();
            
            String newAdresse = rs.getString("ADRESSE");
            String newSituation = rs.getString("SITUATION");
            String mdp = rs.getString("MDP");
            String newMail = rs.getString("MAIL");
            String newLogin = rs.getString("LOGIN");
            
            if (mdp.equals(oldMdp)||oldMdp.equals("")){
                jLblMdp.setVisible(false);
                if(!newMdp.equals("")) mdp = newMdp;
                
            }else{
                jLblMdp.setVisible(true);
                info += "\n Le mot de passe n'a pas été changé.";
            }
            if(!adresse.equals("")) newAdresse = adresse;
            if(!situation.equals("")) newSituation = situation;
            if(!login.equals("")) newLogin = login;
            if(!mail.equals("")) newMail = mail;
            
            statement.executeUpdate("UPDATE PERSONNE SET ADRESSE='"+newAdresse+"',SITUATION='"+newSituation+"',MDP='"+mdp+"',MAIL='"+newMail+"',LOGIN='"+newLogin+"' WHERE IDPERS="+id);

            javax.swing.JOptionPane.showMessageDialog(null,info); 
            
        } catch (SQLException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }
    }