如何通过MongoDB Java驱动修改嵌套文档的occupant值

I have a MongoDB document structure for building facilities as follows:

{ 
  "_id" : ObjectId("5a5081321d5e182e14f20589"), 
  "building_number" : "01", 
  "floor_1" : { 
    "roomA" : { "occupant" : "vacant", "department" : "science", "space_code" : "103", "space_type" : "office", "furniture_assets" : { ... } },
    "roomB" : { "occupant" : "vacant", ... },
    "roomC" : { "occupant" : "vacant", ... }
  }, 
  "floor_2" : { 
    "roomA" : { "occupant" : "vacant", ... },
    "roomB" : { "occupant" : "vacant", ... },
    "roomC" : { "occupant" : "vacant", ... }
  } 
}

I want to change the occupant value from "vacant" to a user's email for a specified room. But my current code runs without errors but doesn't modify the database:

DBCollection coll = db.getCollection("Facilities");
String buildingNum = (String) buildingBox.getValue();
String floorNum = (String) floorBox.getValue();
String roomNum = (String) roomBox.getValue();
BasicDBObject document = new BasicDBObject();
document.put("building_number", buildingNum);
DBCursor dbCursor = coll.find(document);
while(dbCursor.hasNext()) {
 DBObject dbo = dbCursor.next();
 String email = userDetails.get(0);
 BasicDBObject occupant = new BasicDBObject();
 occupant.append("$set",new BasicDBObject().append( "occupant",email));
 DBObject findRoom = (DBObject) ((DBObject) dbo.get(floorNum)).get(roomNum);
 coll.update(findRoom,occupant,false,false);
}

How can I fix this using MongoDB Java Driver, preferably adapting my existing code?

The Issue with Your Current Code #

The core problem is how you're targeting the update:

• You're extracting the nested room object (findRoom) and passing it as the query filter. MongoDB can't reliably match this sub-object to its parent document in the collection, so no updates are applied.
• You need to target the parent building document with a reliable filter (like building_number) and use a dot-separated field path to directly update the nested occupant value.

Fixed Code (Adapted from Your Existing Code) #

Here's the adjusted version that works with your legacy MongoDB Java Driver 2.x setup:

DBCollection coll = db.getCollection("Facilities");
String buildingNum = (String) buildingBox.getValue();
String floorNum = (String) floorBox.getValue();
String roomNum = (String) roomBox.getValue();
String email = userDetails.get(0);

// 1. Build query filter to locate the correct building document
BasicDBObject query = new BasicDBObject("building_number", buildingNum);

// 2. Construct the dot-separated path to the nested occupant field
String occupantFieldPath = floorNum + "." + roomNum + ".occupant";
// Build the $set operation to update that specific field
BasicDBObject update = new BasicDBObject(
    "$set", new BasicDBObject(occupantFieldPath, email)
);

// 3. Execute the update: use multi=true if multiple buildings share the same number
// Parameters: upsert=false, multi=false (update only one matching document)
coll.update(query, update, false, false);

Key Improvements Explained #

1. Reliable Query Filter: We stick to using building_number to target the exact building document—this is efficient and ensures we're modifying the right parent document.
2. Dot-Path Nested Update: Instead of extracting sub-objects, we use a path like floor_1.roomA.occupant to tell MongoDB exactly which nested field to update. This avoids any ambiguity about where the change should be applied.
3. Simplified Logic: We don't need to iterate with a cursor unless your building_number isn't unique. The update() method handles locating and modifying the document in one step.

If You Need to Update Multiple Matching Documents #

If multiple documents share the same building_number, you can still iterate through the cursor but update each document using its unique _id:

DBCursor dbCursor = coll.find(query);
while(dbCursor.hasNext()) {
    DBObject dbo = dbCursor.next();
    // Use the document's _id as the filter to ensure we update the exact record
    BasicDBObject docFilter = new BasicDBObject("_id", dbo.get("_id"));
    coll.update(docFilter, update, false, false);
}

This guarantees you're modifying each specific building document returned by the initial query.

内容的提问来源于stack exchange，提问作者Muiz Uvais