public static CommandeClient SelectCommandeClientById(int id) throws SQLException {
        String query = "";
        CommandeClient Commande = new CommandeClient();
        ResultSet resultat;
        
        

        try {
            query = "SELECT * from COMMANDE_CLIENT  where ID_COMMANDE =? ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();

            while (resultat.next()) {

              //  Commande = new CommandeClient(resultat.getInt("ID_COMMANDE"), resultat.getInt("ID_ENTREPRISE"), resultat.getInt("ID_INTERLOCUTEUR"),resultat.getDate("COMDATE"), resultat.getString("COMREF"),resultat.getFloat("COMHT"),resultat.getFloat("COMTTC"),  resultat.getFloat("COMREMISE"));
            
                 Commande.setIdcommandeclient(resultat.getInt("ID_COMMANDE"));
                 Commande.setIdentreprise(resultat.getInt("ID_ENTREPRISE"));
                 Commande.setIdinterlocuteur(resultat.getInt("ID_INTERLOCUTEUR"));
                 Commande.setDatecommandeclient(resultat.getDate("COMDATE"));
                 Commande.setReferencecommandeclient(resultat.getString("COMREF"));
                 Commande.setTotalhtcommandeclient( resultat.getFloat("COMHT"));
                 Commande.setTotalttccommandeclient( resultat.getFloat("COMTTC"));
                 Commande.setRemisecommandeclient( resultat.getFloat("COMREMISE"));
                
                Commande.setDatecommandeclient(resultat.getDate("COMDATE"));
           
            }

        } catch (SQLException ex) {
            Logger.getLogger(RequetesCommandeClient.class.getName()).log(Level.SEVERE, null, ex);

        }
        return Commande;
    }