在mongo shell中的查询语句是这样的..
db.user.find({"age":{"$gt":5,"$lt":14}})
我们用Java连接mongo来实现.
mongo库中的数据
代码
package com.java.module.mongo.mongo_test_1;
import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.DBObject;
import com.mongodb.MongoClient;
/**
* Java多条件查询mongo
*/
public class JavaManyConditionsQuery {
public static void main(String[] args) {
try {
MongoClient mongoClient = new MongoClient("192.168.125.125", 27017);
DB db = mongoClient.getDB("test");
DBCollection dbCollection = db.getCollection("user");
//将两个并联的查询条件放入一个里面.
DBObject dbQuery = new BasicDBObject();
dbQuery.put("$gt", 5);
dbQuery.put("$lt", 14);
DBObject query = new BasicDBObject("age",dbQuery);
DBCursor dbCursor = dbCollection.find(query);
while (dbCursor.hasNext()) {
System.out.println(dbCursor.next());
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
查询结果