Spring Data MongoDB 模糊查询+精确查询

最新推荐文章于 2024-12-03 18:12:42 发布

YHJ

最新推荐文章于 2024-12-03 18:12:42 发布

阅读量1.4k

点赞数 1

文章标签： jpa

原文链接：https://blog.csdn.net/u010721764/article/details/90444094

版权

mongodb技术专栏收录该内容

23 篇文章 4 订阅

订阅专栏

实体类Person
@Document
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Person {

@Id
private String id;
private String name;
private String nickName;
}

StudentRepository
public interface PersonRepository extends MongoRepository<Person, String> {

}

按照姓名精确查询，按照昵称模糊查询
private Page<Student> query(Pageable pageable){
Student student = new Student();
student.setName("张三");
student.setNickName("xx");
Example<ChargeEmployeeRead> example = Example.of(student, generateStringContainingAndNullIgnoreMatcher());
return studentRepository.findAll(example, pageable);
}

private ExampleMatcher generateStringContainingAndNullIgnoreMatcher() {
return ExampleMatcher.matching()
.withMatcher("name", match->match.exact()) // 姓名精确查询
.withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING) // 其他为模糊查询
.withIgnoreNullValues();
}

对于pageable参数，只要正确传参，Spring MVC会自动组装，Controller方法只需要申明pageable参数即可，传参格式：?page=0&size=10&sort=id,asc