MongoDB Java -3.x，根据mongoshell pgmm的大数据集中的特定关键字

Question

规格: mongo-java-driver-3.3.0.jar，jdk1.7，Mongodb 3.0.12

MongoShell : db.getCollection("Table-WEBSRVS-DTLS").find({"col1":"1000","col4":"EMEA"},{"col1":"1","col2":"1"})

问:如何在Java for Mongo-java 3.x API中实现这个mongoshell命令？

thx

Answer 1

下面是上述查询的等效Java代码。您可能需要在下面的代码中相应地更改数据库和集合名称。

import org.bson.Document;

import com.mongodb.MongoClient;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.model.Filters;
import com.mongodb.client.model.Projections;

public class GetDataFromTableWebsrvsDtls {
    public static void main(String[] args) {

        MongoClient client = new MongoClient();

        MongoDatabase database = client.getDatabase("localhost");

        MongoCollection<Document> collection = database.getCollection("TableWebsrvsDtls");

        FindIterable<Document> collectionData = collection
                .find(Filters.and(Filters.eq("col1", "1000"), Filters.eq("col4", "EMEA")))
                .projection(Projections.include("col1", "col2"));

        for (Document doc : collectionData) {
            System.out.println(doc.toJson());
        }

        client.close();

    }

}