how to insert/put a json array in the BasicDBObject

Question

I am using mongo db driver 2.11.2. I am bit puzzled how to insert/add an array to the BasicDBObject. All the example which I come across are does not show how to achieve this :(. In the below example how would I insert employees array in the dbo object ?

 /*
    {
    "company" : "stackoverflow",
    "established": "when I started coding"
    "employees":[
        {"firstName":"John", "lastName":"Doe"},
        {"firstName":"Anna", "lastName":"Smith"},
        {"firstName":"Peter", "lastName":"Jones"}
       ]
    }
     */

    BasicDBObject basicDBObject = new BasicDBObject();
    basicDBObject.put("company", "stackoverflow");
    basicDBObject.put("established", "when I started coding");
    System.out.println(basicDBObject.toString());

}

AKS you are awesome , struggling for this for couple of hours — forum.test17
– forum.test17, Commented Jul 31, 2015 at 7:58

Blakes Seven · Accepted Answer · 2015-07-31 08:04:52Z

2

Use the Arrays.asList as a contructor for the list. It's just a list. And .append() the object keys rather than "put". Again, it's just as HashMap interface:

    BasicDBObject basicDBObject = new BasicDBObject();
    basicDBObject.put("company", "stackoverflow");
    basicDBObject.append("established", "when I started coding");
    basicDBObject.append("employees", Arrays.<DBObject>asList(
        new BasicDBObject("firstName", "john")
            .append("lastName", "doe"),
        new BasicDBObject("firstName", "anna")
            .append("lastName", "smith"),
        new BasicDBObject("firstName", "peter")
            .append("lastName", "jones")
    ));
    System.out.println(basicDBObject.toString());

edited Jul 31, 2015 at 8:04

answered Jul 31, 2015 at 7:54

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

forum.test17 Over a year ago

just for the info, you have missed an comma after "smith"

Blakes Seven Over a year ago

@rockyit86 Cut and paste bites me every time. Did not have an IDE open and just typed in here.

forum.test17 Over a year ago

no worries , I cannot type anything without an IDE , such a poor typist, and I guess I am not alone :)

Collectives™ on Stack Overflow

how to insert/put a json array in the BasicDBObject

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related