field为查询字段,value为查询值,也可以通过过滤器Filters,Filters提供了一系列查询条件的静态方法

相等 — =

FindIterable iter = doc.find(new Document("name","张三"));

// 或者  FindIterable iter = doc.find(new Document("age",new Document("$eq",24)));

//或者   FindIterable iter = doc.find(Filters.eq("name", "张三"));

iter.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

不等 — !=

// FindIterable iter = doc.find(new Document("age",new Document("$ne",24)));

FindIterable iter = doc.find(Filters.ne("name", "张三"));

iter.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

大于 — >

FindIterable iter = doc.find(new Document("age",new Document("$gt",22)));

//或者   FindIterable iter = doc.find(Filters.gt("age",22));

iter.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

大于等于 — >=

用法同上,符号为$gte

小于 — <

FindIterable iter1 = doc.find(new Document("age",new Document("$lt",22)));

//或者   FindIterable iter = doc.find(Filters.lt("age",22));

iter1.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

小于等于 — <=

用法同上,符号为$lte

且 — and

FindIterable iter1 = doc.find(new Document("age",20).append("name", "张三"));

//或者 FindIterable iter1 = doc.find(Filters.and(Filters.eq("name", "张三"),Filters.lt("age", 30)));

iter1.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

或者 — or

List list = new ArrayList();

list.add(new Document("name","张三"));

list.add(new Document("age",24));

FindIterable iter1 = doc.find(new Document("$or", list));

//FindIterable iter1 = doc.find(Filters.and(Filters.eq("name", "张三"),Filters.lt("age", 30)));

iter1.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

存在 — in

// List list = new ArrayList();

//list.add("张三");

//list.add("李四");

//FindIterable iter = doc.find(new Document("name",new Document("$in",list)));

FindIterable iter = doc.find(Filters.in("name", "张三","李四","王五"));

iter.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

不存在 — not in

用法同上,符号为$nin

排序 — sort

FindIterable iter1 = doc.find().sort(new Document("age",1).append("phone", 1));

//FindIterable iter1 = doc.find().sort(Sorts.orderBy(Sorts.ascending("age"),Sorts.descending("phone")));

iter1.forEach(new Block() {

public void apply(Document _doc) {

System.out.println(_doc.toJson());

}

});

java操作mongodb——查询数据

标签:操作   lis   string   hone   asc   ase   等于   集合   filters

本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源:http://www.cnblogs.com/adjk/p/6430074.html

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐