springdatamongodb之查询操作

只查询符合条件的第一条数据，返回Article对象

query = Query.query(Criteria.where("author").is("yinjihuan"));
Article article = mongoTemplate.findOne(query, Article.class);


查询集合中所有数据，不加条件

articles = mongoTemplate.findAll(Article.class);


查询符合条件的数量

query = Query.query(Criteria.where("author").is("yinjihuan"));
long count = mongoTemplate.count(query, Article.class);


根据主键ID查询

article = mongoTemplate.findById(new ObjectId("57c6e1601e4735b2c306cdb7"), Article.class);


in查询

List authors = Arrays.asList("yinjihuan", "jason");
query = Query.query(Criteria.where("author").in(authors));
articles = mongoTemplate.find(query, Article.class);


ne（!=）查询

query = Query.query(Criteria.where("author").ne("yinjihuan"));
articles = mongoTemplate.find(query, Article.class);


lt(<)查询访问量小于10的文章

query = Query.query(Criteria.where("visitCount").lt(10));
articles = mongoTemplate.find(query, Article.class);


范围查询，大于5小于10

query = Query.query(Criteria.where("visitCount").gt(5).lt(10));
articles = mongoTemplate.find(query, Article.class);


模糊查询，author中包含a的数据

query = Query.query(Criteria.where("author").regex("a"));
articles = mongoTemplate.find(query, Article.class);


数组查询，查询tags里数量为3的数据

query = Query.query(Criteria.where("tags").size(3));
articles = mongoTemplate.find(query, Article.class);


or查询，查询author=jason的或者visitCount=0的数据

query = Query.query(Criteria.where("").orOperator(
Criteria.where("author").is("jason"),
Criteria.where("visitCount").is(0)));
articles = mongoTemplate.find(query, Article.class);


源码下载：https://github.com/yinjihuan/cxytiandi

欢迎加入我的知识星球，一起交流技术，免费学习猿天地的课程（http://cxytiandi.com/course）

微信扫码加入猿天地知识星球
猿天地