writing mongodb syntax on java api

Question

How do I write this query on java api ? ',' means 'or' clause

db.questions.find( { user_id: /bc/ },{user_name:/bc/},{age:/2/} )

I've tried different ways, but I've been successful using one option only. How to add multiple options using "or" clause ?

here my code :

MongoClient mongoClient;
                DB db;

                DBCollection table;
                DBCursor cursor = null;

                mongoClient = new MongoClient("localhost", 27017);
                db = mongoClient.getDB("stackoverflow");
                boolean auth = db.authenticate("aku", "kamu".toCharArray());
                table = db.getCollection("questions");
                cursor = table.find(new BasicDBObject("user_id", java.util.regex.Pattern.compile("milk")));
                while (cursor.hasNext()) {
                    DBObject object = cursor.next();%>
                    out.print(object.get("user_id"));
                }

Using mySQL, the query is :

select * from questions where user_id like '%bc%' or user_name like %bc% or age like %2%

I'm new to mongoDB, I feel like it's fairly hard to convert queries from mySQL..

here the error

Tiago Bértolo · Accepted Answer · 2016-06-30 09:31:14Z

2

You can use the $or operator - manual link

db.questions.find( "{ $or : [user_id: '/bc/' ,user_name:'/bc/',age:'/2/'] }")

You can use this query within java like this:

FindIterable<Document> iterable = db.getCollection("questions").find( "{ $or : [user_id: '/bc/' ,user_name:'/bc/',age:'/2/'] }" );

iterable.forEach(new Block<Document>() {
    @Override
    public void apply(final Document document) {
        System.out.println(document);
    }
});

edited Jun 30, 2016 at 9:31

answered Jun 30, 2016 at 8:35

Tiago Bértolo

4,4053 gold badges39 silver badges57 bronze badges

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

7 Comments

Tiago Bértolo Over a year ago

anything else you need mate?

beboy Over a year ago

hey bro, how to apply it on web project (jsp)..it cant be implemented btw thanks, i just knowing thats way, so the query can be directly writen on java api like that...

Tiago Bértolo Over a year ago

i would recommend you to check a tutorial on this matter.

beboy Over a year ago

sure bro, here the picture of error i upload on the questions, can you make it clear bro?

Tiago Bértolo Over a year ago

dont forget " around the find. i will edit my post aswell

|

Tan Kim Loong · Accepted Answer · 2016-07-09 08:49:03Z

0

I'm not sure if your question is already answered but if you're using a later version or mongodb java driver, it can be written this way. I'm not familiar with how BasicDBObject works, am more used to Documents. Both works.

List<Document> orQueryList = new ArrayList<Document>();
orQueryList.add("user_id", "bc");
orQueryList.add("user_name", "bc");
orQueryList.add("age", "2");

Document orDoc = new Document("$or", orQueryList);

MongoCursor<Document> cursor = table.find(orDoc).iterator();

while (cursor.hasNext()) {
   Document dbObj = cursor.next();

   System.out.println(dbObj.getString("user_id");
}

answered Jul 9, 2016 at 8:49

Tan Kim Loong

1,0358 silver badges14 bronze badges

2 Comments

beboy Over a year ago

thanks for helping @tan kim loong, actually my questions is not answered yet, i use mongoDB api version 2.X, i'll try your answer to implement my source...

Tan Kim Loong Over a year ago

It should mean that your "user_id" field is an Integer. Use dbObj.getInteger("user_id") or Integer.parseInt(dbObj.get("user_Id").toString()) instead.

Collectives™ on Stack Overflow

writing mongodb syntax on java api

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related