MongoRepository学习-regex
在MongoRepository中使用Regex,
Keyword | Sample | Logical result |
---|---|---|
GreaterThan |
findByAgeGreaterThan(int age) |
{"age" : {"$gt" : age}} |
LessThan |
findByAgeLessThan(int age) |
{"age" : {"$lt" : age}} |
Between |
findByAgeBetween(int from, int to) |
{"age" : {"$gt" : from, "$lt" : to}} |
IsNotNull , NotNull |
findByFirstnameNotNull() |
{"age" : {"$ne" : null}} |
IsNull , Null |
findByFirstnameNull() |
{"age" : null} |
Like |
findByFirstnameLike(String name) |
{"age" : age} ( age as regex) |
Regex |
findByFirstnameRegex(String firstname) |
{"firstname" : {"$regex" : firstname }} |
(No keyword) |
findByFirstname(String name) |
{"age" : name} |
Not |
findByFirstnameNot(String name) |
{"age" : {"$ne" : name}} |
Near |
findByLocationNear(Point point) |
{"location" : {"$near" : [x,y]}} |
Within |
findByLocationWithin(Circle circle) |
{"location" : {"$within" : {"$center" : [ [x, y], distance]}}} |
Within |
findByLocationWithin(Box box) |
{"location" : {"$within" : {"$box" : [ [x1, y1], x2, y2]}}}True |
IsTrue , True |
findByActiveIsTrue() |
{"active" : true} |
IsFalse , False |
findByActiveIsFalse() |
{"active" : false} |
Exists |
findByLocationExists(boolean exists) |
{"location" : {"$exists" : exists }} |
官方文档:http://docs.spring.io/spring-data/mongodb/docs/1.2.0.RELEASE/reference/html/mongo.repositories.html
具体例子:http://source.lishman.com/project/609#card/3432/file/19027