SpringData - MongoTemplate的基本使用方法

SpringData - MongoTemplate的基本使用方法

描述	语法
一个条件(等)	queryByName(String name)
二个条件(且)	queryByNameAndAge(String name, Integer age)
二个条件(或)	queryByNameOrAge(String name, Integer age)
2数之间(不包含2数)	queryByAgeBetween(Integer min, Integer max) =={ "age" : { "$gt" : 13, "$lt" : 30}}
<	queryByAgeLessThan(Integer age)
<=	queryByAgeLessThanEqual(Integer age)
>	queryByAgeGreaterThan(Integer age);
>=	queryByAgeGreaterThanEqual(Integer age);
After = >	queryByAgeGreaterThan(Integer age);
Beftore = <	queryByAgeLessThan(Integer age)
判断空	findByNameIsNull
判断不为空	findByNameIsNotNull
like	findByNameLike
NotLike	findByNameNotLike
StartingWith	findByNameStartingWith
EndingWith	findByNameEndingWith
Containing	findByNameContaining
查询排序	findByIdOrderByName[Desc Asc]
not	findByNameNot
In	findByIdIn
Notin	findByIdNotIn
True	findByStatusTrue
False	findByStatusFalse
查询字段并排序	findByIshotOrderBySequence
IgnoreCase(忽略大小写)	queryByNameIgnoreCase
QueryCriteria	Query query = new Query(); Criteria criteria = Criteria.where("name").is("will"); mongoTemplate.find(query, User.class);
Query增加	query.skip(3); query.limit(3); Sort id = Sort.by(Sort.Direction.DESC, "id"); query.with(id);
Criteria条件	Criteria criteria = new Criteria(); Criteria criteria1 = criteria.orOperator( Criteria.where("name").is("dafei"), Criteria.where("age").lt(30) ); query.addCriteria(criteria1);
正则 模糊查询	Query query = new Query(); String pattern = String.format("^da"); Criteria criteria = new Criteria(); String zz = String.format("^fei"); Criteria criteria1 = criteria.andOperator( Criteria.where("name").regex(pattern, "m"), Criteria.where("age").lt(30) ); query.addCriteria(criteria1);