public static void updateActionCom(int idaction, int idactiontype, int idutilisateur, Date dateaction, String actioncommercial) throws SQLException {

        String query = "";

        try {
            query = " UPDATE ACTION_COM SET ID_ACTION_TYPE=?,ID_INTERLOCUTEUR=?,ACTDATE=?,ACTCOMM=? where ID_ACTION=?  ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(5, idaction);
            pStatement.setInt(1, idactiontype);
            pStatement.setInt(2, idutilisateur);
            pStatement.setObject(3, dateaction);
            pStatement.setString(4, actioncommercial.toLowerCase());
            pStatement.executeUpdate();

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

        }
    }