Find all objects in collection Java Mongodb

Question

Below code finds the first document in a collection :

package database;

import com.mongodb.BasicDBObject;
import com.mongodb.BulkWriteOperation;
import com.mongodb.BulkWriteResult;
import com.mongodb.Cursor;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.DBObject;
import com.mongodb.MongoClient;
import com.mongodb.ParallelScanOptions;
import com.mongodb.ServerAddress;

import java.net.UnknownHostException;
import java.util.List;
import java.util.Set;

import static java.util.concurrent.TimeUnit.SECONDS;

// based on http://mongodb.github.io/mongo-java-driver/2.13/getting-started/quick-tour/

public class Mongo {

    public void getCon() {
        // or
        MongoClient mongoClient;
        try {
            mongoClient = new MongoClient("localhost", 27017);
            DB db = mongoClient.getDB("mydb");
            DBCollection coll = db.getCollection("testCollection");

            BasicDBObject doc = new BasicDBObject("name", "MongoDB")
                    .append("type", "database")
                    .append("count", 1)
                    .append("info",
                            new BasicDBObject("x", 203).append("y", 102));
            coll.insert(doc);

            coll.findOne();
        } catch (UnknownHostException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}

There does not appear to be a findAll method. How to find all the documents in the collection testCollection ?

Konstantin Yovkov · Accepted Answer · 2015-04-15 19:52:11Z

10

You have to use the DBCollection.find() method, which

Select all documents in collection and get a cursor to the selected documents.

So, what you have to do, is:

DBCursor cursor = coll.find();
while (cursor.hasNext()) {
   DBObject obj = cursor.next();
   //do your thing
}

answered Apr 15, 2015 at 19:52

Konstantin Yovkov

63k9 gold badges107 silver badges152 bronze badges

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

Comments

jyemin · Accepted Answer · 2015-04-15 20:39:18Z

6

If you know that the query will return a small enough number of documents, you can use the DBCursor.toArray() method to get all the results into a List:

List<DBObject> all = coll.find().toArray();

answered Apr 15, 2015 at 20:39

jyemin

3,81327 silver badges16 bronze badges

Comments

Vladi · Accepted Answer · 2021-08-01 11:53:15Z

0

My solution :

preparation :

       MongoClient mongoClient = new MongoClient("localhost", 27017);
       MongoDatabase database = mongoClient.getDB("mydb");
       MongoCollection<Document> collection = database.getCollection("collectionName");

declare of cursor

       MongoCursor<Document> cursor = collection.find().iterator();
        while (cursor.hasNext()) {
            System.out.println("collection is " +cursor.next() );
        }

answered Aug 1, 2021 at 11:53

Vladi

2,03823 silver badges36 bronze badges

Collectives™ on Stack Overflow

Find all objects in collection Java Mongodb

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related