public static void updateCommandeClient(int idcommandeclient, int identreprise,int idinterlocuteur,  Date datecommandeclient,String referencecommandeclient,Float totalhtcommandeclient,Float totalttccommandeclient, Float remisecommandeclient) throws SQLException {

        String query = "";

        try {
            query = " UPDATE COMMANDE_CLIENT SET ID_ENTREPRISE=?,ID_INTERLOCUTEUR=?,COMDATE=?,COMREF=?,COMHT=?,COMTTC=?,COMREMISE=?  where ID_COMMANDE=?  ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(6, idcommandeclient);
            pStatement.setInt(1, identreprise);
            pStatement.setInt(2, idinterlocuteur);
            pStatement.setObject(3, datecommandeclient);
            pStatement.setString(4, referencecommandeclient);
            pStatement.setFloat(5, totalhtcommandeclient);
            pStatement.setFloat(6, totalttccommandeclient);
            pStatement.setFloat(7, remisecommandeclient);
            pStatement.executeUpdate();

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

        }
    }