private SqlStatement GetUpdateStatement(Entity entity) throws Exception {
    StringBuffer builder = new StringBuffer();
    SqlStatement sql = new SqlStatement();

    // et...
    EntityType et = getEntityType();

    // update...
    builder.append("UPDATE ");
    builder.append(et.getNativeName());
    builder.append(" SET ");

    // walk...
    boolean first = true;
    EntityField key = null;
    for (int index = 0; index < et.getFields().size(); index++) {
      EntityField field = (EntityField) et.getFields().elementAt(index);
      if (field.getIsKey()) key = field;
      else if (entity.getIsModified(field)) {
        if (first) first = false;
        else builder.append(", ");

        // add the snippet...
        builder.append(field.getNativeName());
        builder.append("=?");

        // add the parameter...
        Object value = entity.GetValue(field);
        sql.AddParameterValue(value);
      }
    }

    // append...
    AppendIdConstraint(builder, sql, key, entity);

    // return...
    sql.setCommandText(builder.toString());
    return sql;
  }
  private SqlStatement GetInsertStatement(Entity entity) throws Exception {
    StringBuffer builder = new StringBuffer();
    SqlStatement sql = new SqlStatement();

    // et...
    EntityType et = getEntityType();

    // create...
    builder.append("INSERT INTO ");
    builder.append(et.getNativeName());
    builder.append(" (");
    boolean first = true;
    for (int index = 0; index < et.getFields().size(); index++) {
      EntityField field = (EntityField) et.getFields().elementAt(index);
      if (entity.getIsModified(field)) {
        if (first) first = false;
        else builder.append(", ");
        builder.append(field.getNativeName());
      }
    }
    builder.append(") VALUES (");
    first = true;
    for (int index = 0; index < et.getFields().size(); index++) {
      EntityField field = (EntityField) et.getFields().elementAt(index);
      if (entity.getIsModified(field)) {
        if (first) first = false;
        else builder.append(", ");
        builder.append("?");

        // add in the parameter....
        sql.AddParameterValue(entity.GetValue(field));
      }
    }
    builder.append(")");

    // return...
    sql.setCommandText(builder.toString());
    return sql;
  }
  private void PushChanges() throws Exception {
    BookmarkCollection updates = Bookmark.GetBookmarksForServerUpdate(getContextSource());
    BookmarkCollection deletes = Bookmark.GetBookmarksForServerDelete(this.getContextSource());
    if (updates.size() == 0 && deletes.size() == 0) return;

    // et...
    EntityType et = EntityType.GetEntityType(Bookmark.class);

    // get the server ones...
    BookmarksService service = new BookmarksService();
    BookmarkCollection fromServer = service.GetAll();

    // walk the locally updated items…
    for (Bookmark local : updates) {
      // find it in our server set...
      Bookmark toUpdate = null;
      for (Bookmark server : fromServer) {
        if (local.getOrdinal() == server.getOrdinal()) {
          toUpdate = server;
          break;
        }
      }

      // did we have one to change?
      if (toUpdate != null) {
        // walk the fields...
        int serverId = 0;
        for (EntityField field : et.getFields()) {
          if (!(field.getIsKey()))
            toUpdate.SetValue(field, local.GetValue(field), SetReason.UserSet);
          else serverId = toUpdate.getBookmarkId();
        }

        // send that up...
        service.PushUpdate(this.getContextSource(), toUpdate, serverId);
      } else {
        // we need to insert it...
        service.PushInsert(this.getContextSource(), local);
      }
    }

    // what about ones to delete?
    for (Bookmark local : deletes) {
      // find a matching ordinal on the server...
      for (Bookmark server : fromServer) {
        if (local.getOrdinal() == server.getOrdinal())
          service.PushDelete(this.getContextSource(), server, server.getBookmarkId());
      }
    }
  }