MongoDB update in Java

1) oracle

      

    UPDATE TESTCOLLECTION SET AGE = "15" WHERE NAME = "YUNJ"

 

2) MongDB

 

    (1)

      { "_id" : { "$oid" : "519318731f5a822743d00b46"} , "name" : "yunj" , "age" : "30" , "detail" : { "x" : 99 , "y" : "55"}}
      
       

      BasicDBObject newDocument = new BasicDBObject();
      newDocument.put("age", "15");
 
      BasicDBObject searchQuery = new BasicDBObject().append("name", "yunj");
 
      collection.update(searchQuery, newDocument);

 
 위와 같은 식으로 하면 모든 자료가 새로운 자료로 replace 되버린다.
 
      { "_id" : { "$oid" : "519318731f5a822743d00b46"} , "age" : "15"}
 

   

    (2) with $set

 

      BasicDBObject newDocument = new BasicDBObject();
      newDocument.append("$set", new BasicDBObject().append("age", "15"));
 
      BasicDBObject searchQuery = new BasicDBObject().append("name", "yunj");
 
      collection.update(searchQuery, newDocument)

 

       { "_id" : { "$oid" : "519318731f5a822743d00b46"} , "name" : "yunj" , "age" : "15" , "detail" : { "x" : 99 , "y" : "55"}}

   

   

    (3) with $unset
     

      BasicDBObject newDocument = new BasicDBObject();
      newDocument.append("$unset", new BasicDBObject().append("age", "15"));
 
      BasicDBObject searchQuery = new BasicDBObject().append("name", "yunj");
 
      collection.update(searchQuery, newDocument)

 

        { "_id" : { "$oid" : "519318731f5a822743d00b46"} , "name" : "yunj" , "detail" : { "x" : 99 , "y" : "55"}}

[출처] MongoDB update in Java (대전 안드로이드) |작성자 두눈박이