java操作mongodb查询总数_java操作mongodb——查询数据
field为查询字段,value为查询值,也可以通过过滤器Filters,Filters提供了一系列查询条件的静态方法相等 — =FindIterable iter = doc.find(new Document("name","张三"));// 或者 FindIterable iter =doc.find(new Document("age",new Document("$eq",24))).
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
更多推荐
所有评论(0)