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

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

            while (resultat.next()) {

                Commande = new CommandeFournisseur(resultat.getInt("ID_CMDFOUR"), resultat.getInt("ID_UTILISATEUR"), resultat.getString("COMFOUREF"), resultat.getDate("COMFOUDATE"), resultat.getFloat("COMFOUREMISE"));
            }

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

        }
        return Commande;
    }