Parse mongodb document into string variables

Question

I am a MongoDB beginner. I am trying to use it with java api. I have few documents inserted into mongodb and I am done with connecting to mongo instance using java.

My challenge is, I am getting one document as a result of mongodb query through java.

The result is one document in mongo which looks like:

{ "_id" : { "$oid" : "528f13b5b55008f6487f7988"} , "NodeName" : "saurabhdeshpande" , "FirstName" : "saurabh" , "LastName" : "deshpande" }

I want to take all these returned values into string variables like

String nodename, String firstname, String lastname

Please suggest - Hw do i go about this?

Code I tried is -

    DBCursor cursor = coll.find();
        BasicDBObject query = new BasicDBObject("NodeName", name);

        cursor = coll.find(query);
        try {
            while (cursor.hasNext()) {

                System.out.println(cursor.next());
                DBObject tobj = cursor.next();
                details[0] = (String) tobj.get("NodeName");
                details[1] = (String) tobj.get("FirstName");
                details[2] = (String) tobj.get("LastName");

                System.out.println("in details ");
                for (int i = 0; i < details.length; i++) {
                    System.out.println("in details " + details[i]);
                }
            }
        } finally {
            cursor.close();
        }
        mongoClient.close();
    } catch (UnknownHostException e) {
        e.printStackTrace();
    }

share your code what u tried ??

GaneshP
– GaneshP

2013-12-05 06:13:31 +00:00
Commented Dec 5, 2013 at 6:13 — GaneshP
– GaneshP, Commented Dec 5, 2013 at 6:13

4J41 · Accepted Answer · 2013-12-05 06:13:59Z

2

Your result will be a BasicDBObject(which is basically a Map) say result.

String nodename = (String)result.get("NodeName");
String firstname = (String)result.get("FirstName");
String lastname= (String)result.get("LastName");

answered Dec 5, 2013 at 6:13

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

5 Comments

Saurabh Deshpande Over a year ago

Thanks Ajai.. I tried this previously but it shows java.lang.RuntimeException: no more as an error.

4J41 Over a year ago

I meant could you edit your question to include the snippet you has tried?

Saurabh Deshpande Over a year ago

please have a look now. Thanks!

4J41 Over a year ago

//System.out.println(cursor.next()); Try this. You are doing two cursor.next within the same iteration, which could make you go outside the bounds.

Saurabh Deshpande Over a year ago

hey.. it worked! getting values prinjted in details array. Thanks a ton!

4J41 · Accepted Answer · 2013-12-05 07:04:52Z

You are doing two cursor.next() in the same iteration which could cause runtime exception.

DBCursor cursor = coll.find();
    BasicDBObject query = new BasicDBObject("NodeName", name);

    cursor = coll.find(query);
    try {
        while (cursor.hasNext()) {

            //System.out.println(cursor.next());
            DBObject tobj = cursor.next();
            System.out.println(tobj);
            details[0] = (String) tobj.get("NodeName");
            details[1] = (String) tobj.get("FirstName");
            details[2] = (String) tobj.get("LastName");

            System.out.println("in details ");
            for (int i = 0; i < details.length; i++) {
                System.out.println("in details " + details[i]);
            }
        }
    } finally {
        cursor.close();
    }
    mongoClient.close();
} catch (UnknownHostException e) {
    e.printStackTrace();
}

Collectives™ on Stack Overflow

Parse mongodb document into string variables

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related