private void submitLP(){
    PreparedStatement St;
           String login = userChamp.getText();
           String password = mdpChamp.getText();
           String sql;
           ResultSet Rs;

           try{ ///chaine de conection avec BD Mysql
               // Class.forName("com.mysql.jdbc.Driver");
                 Connection cnx = GESTFORM.mdbc.getMyConnection();
                 //^^^^^^ ON INITIALISE LA CONNECTION PLUS HAUT Connection cnx =    DriverManager.getConnection("jdbc:mysql://82.127.32.30:3306/veyre_ppe2","root", "root"); 
                          sql = "SELECT nLicence FROM ADHERENT WHERE username= ? AND password = ?";
                      St = (PreparedStatement) cnx.prepareStatement(sql);
                      St.setString(1, login);
                      St.setString(2, password);
                      Rs = St.executeQuery();
                   
                    if   (!Rs.next()) {
                        sql = "SELECT idOrganisateur FROM ORGANISATEUR WHERE username= ? AND password = ?";
                      St = (PreparedStatement) cnx.prepareStatement(sql);
                      St.setString(1, login);
                      St.setString(2, password);
                      Rs = St.executeQuery();
                            
                                if   (!Rs.next()) {
                                    infoLab.setText("echec d'autentification");

                                }
                                else {
                                    GESTFORM.id=Rs.getString(1);
                                    GESTFORM.org=true;
                                    
        this.dispose();// fermer la frame courante
        //this.setVisible(false);// fermer la frame courante auth
       new orgFrame().setVisible(true);// ouvre la frame principale
   }  
                    }
                     else {
                        GESTFORM.id=Rs.getString(1);
                                    GESTFORM.org=false;
        this.dispose();// fermer la frame courante
        //this.setVisible(false);// fermer la frame courante auth
       new mainFrame().setVisible(true);// ouvre la frame principale
   }  
    
                          }
                        catch (Exception e) {
                            JOptionPane.showMessageDialog(null, "Authentification Echouer " +e.getMessage());
                        } 
    }