Executing Mongo like Query (JSON)through Java

Question

I was wondering if there is a way to execute mongo like query directly through Java i.e. we give mongoDB like query as a String to a function in Java driver for mongoDB as a String Object and an DBCursor Object is returned. Something like:

import com.mongodb.*;
import java.net.UnknownHostException;
public class ExecuteQuery {
public static void main(String args[]){
    try{
          Mongo m = new Mongo();
          DB db = m.getDB("test");
          DBCollection coll = db.getCollection("first");
          DBObject doc = new BasicDBObject();
          DBCursor cur =coll.executeQuery("db.first.find({"username":"joe"})");
       }
       catch(UnknownHostException e){
          System.out.println(e);
       }
       catch (MongoException.DuplicateKey e) {
          System.out.println("Exception Caught" + e);
       }
}
}

Note: executeQuery() is not a built in function. It is just used for demonstration purposes. So, Is there a function in the java api which converts a json string to a BasicDBObject instance? Thanks.

You can check this link. It might help. stackoverflow.com/questions/47093563/… — Charudatta Joshi
– Charudatta Joshi, Commented Nov 8, 2017 at 10:13

AlikElzin-kilaka · Accepted Answer · 2016-09-15 13:04:56Z

12

Yes, there is way, by passing the filter as a string. Example:

BasicDBObject query = BasicDBObject.parse("{userId: {$gt: \"1\"}}");
FindIterable<Document> dumps = crapCollection.find(query);

You can Also use com.mongodb.util.JSON, but I don't recommend it. It's less descriptive.

DBObject dbObject = (DBObject)JSON.parse("{userId: {$gt: \"1\"}}");

Please notice that this might be vulnerable to SQL injections because you parse/build the filter yourself.

I recommend using Jongo's parameterized query.

answered Sep 15, 2016 at 13:04

AlikElzin-kilaka

36.3k39 gold badges204 silver badges298 bronze badges

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

Comments

pingw33n · Accepted Answer · 2011-02-02 10:34:10Z

9

What you showed here is not JSON, it's Javascript code for embedded MongoDB Shell. If you need for some reason to execute the code inside Java environment you will have to embed Javascript engine (like Rhino) and implement compatible API.

Otherwise you just need to convert JSON to DBObject and you can do this with JSON.parse() method or any other JSON-mapping library like Jackson. Note that MongoDB uses extended set of data types that are not present in JSON: http://www.mongodb.org/display/DOCS/Data+Types+and+Conventions

UPD: Scott Hernandez pointed out about JSON.parse.

edited Feb 2, 2011 at 10:34

answered Feb 1, 2011 at 11:21

pingw33n

12.6k2 gold badges39 silver badges38 bronze badges

2 Comments

Scott Hernandez Over a year ago

There is a JSON.parse() method to convert json string to a DBObject.

aditya_gaur Over a year ago

Thank you for the correction. Yeah I have tried out the JSON parser provided in the MongoDB library for Java. If possible can you please let me know a bit more about Rhino.

Ryan Kimber · Accepted Answer · 2013-03-17 15:01:05Z

2

Take a look at the Jongo library - it will allow you to run even pretty advanced queries using the command-line syntax.

It also uses a very fast GSON mapper to return your own objects back to you as the result of the query, instead of a list of BasicDBObjects.

answered Mar 17, 2013 at 15:01

Ryan Kimber

4951 gold badge6 silver badges14 bronze badges

Comments

LLB · Accepted Answer · 2013-07-19 14:05:03Z

1

I would recommend to use mongo-shell-like-query utility (jar). It allows you to write mongo queries in java (or scala) code using the same syntax as that of mongo command shell. To be more specific, you can write mongo queries in string format. It also supports advance features such as aggregation pipeline. Have a look at https://github.com/EqualExperts/mongo-shell-like-query

answered Jul 19, 2013 at 14:05

LLB

911 silver badge7 bronze badges

Comments

Scott Hernandez · Accepted Answer · 2011-02-01 18:09:42Z

-1

You can follow the example in the tutorial:

http://www.mongodb.org/display/DOCS/Java+Tutorial#JavaTutorial-GettingASetofDocumentsWithaQuery

Note their use a of (Basic)DBObject to create the query, not a string.

answered Feb 1, 2011 at 18:09

Scott Hernandez

7,5902 gold badges36 silver badges25 bronze badges

Collectives™ on Stack Overflow

Executing Mongo like Query (JSON)through Java

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related