java - 如何更新结构复杂的Mongodb文档

Question

我有一个具有以下结构的 mongoDB 文档

{
  "id": 9595511812,
  "Feeds": [
    {
      "department": "mseb",
      "consumer_number": 1234567890,
      "due_date": "2016-11-11",
      "due_amount": 400,
      "balance_amount": 0,
      "unitsConsumed": 40,
      "freezeDate": "2016-11-11",
      "lastPaidDate": "2016-11-11",
      "billNumber": "9877",
      "id": "1",
      "paid": false
    },
    {
      "department": "mseb",
      "consumer_number": 1234567890,
      "due_date": "2016-11-21",
      "due_amount": 400,
      "balance_amount": 0,
      "unitsConsumed": 40,
      "freezeDate": "2016-11-21",
      "lastPaidDate": "2016-11-21",
      "billNumber": "9877",
      **"id": "2",**
      "paid": false
    }
  ]
}

我想为 id=2 的 Feed 更新paid == true(** 上面标记的字段)。如何使用 mongo java 客户端做到这一点？

我已经尝试过

 DB db = DBConnection.getDatabaseConnection();
        DBCollection table = db.getCollection("customer");
        BasicDBObject newDocument = new BasicDBObject();
        newDocument.append("$set", new BasicDBObject().append("Feeds.paid", "true"));

        BasicDBObject searchQuery = new BasicDBObject().append("id", "9595511812");

        table.update(searchQuery, newDocument);

Answer 1

Feeds 是一个数组，您要更新第二个元素，因此 set 将以:

.append("Feeds.1.paid", "true"));

而不是:

.append("Feeds.paid", "true"));