自定义条件查询测试

    //自定义条件查询测试
    @Test
    public void testFindAllByExample() {
        //分页参数
        int page = 0;//从0开始
        int size = 10;
        /*
        //分页参数
        if (page <= 0) {
            page = 1;
        }
        if (size <= 0) {
            size = 10;
        }
        //构造分页查询方法
        page = page - 1;
        */
        Pageable pageable = PageRequest.of(page, size);

        //条件值对象
        CmsPage cmsPage = new CmsPage();
        //要查询5a751fab6abb5044e0d19ea1站点的页面
//        cmsPage.setSiteId("5a751fab6abb5044e0d19ea1");
        //设置模板id条件
//        cmsPage.setTemplateId("5ad9a24d68db5239b8fef199");
        //设置页面别名
        cmsPage.setPageAliase("轮播");
        //条件匹配器
        /*ExampleMatcher exampleMatcher = ExampleMatcher.matching();
        exampleMatcher = exampleMatcher.withMatcher("pageAliase", ExampleMatcher.GenericPropertyMatchers.contains());
//        exampleMatcher = exampleMatcher.withMatcher("templateId", ExampleMatcher.GenericPropertyMatchers.contains());
        */
        ExampleMatcher exampleMatcher = ExampleMatcher.matching()
                .withMatcher("pageAliase", ExampleMatcher.GenericPropertyMatchers.contains())
                .withMatcher("templateId", ExampleMatcher.GenericPropertyMatchers.contains());
                                                     //ExampleMatcher.GenericPropertyMatchers.contains() 包含关键字(模糊匹配)
                                                     //ExampleMatcher.GenericPropertyMatchers.startsWith() 前缀匹配
                                                     //ExampleMatcher.GenericPropertyMatchers.exact() 处理状态精确匹配（默认）

        //定义条件对象Example
        Example<CmsPage> example = Example.of(cmsPage, exampleMatcher);
        Page<CmsPage> all = cmsPageRepository.findAll(example, pageable);
        List<CmsPage> content1 = all.getContent();//数据列表
        long totalElements = all.getTotalElements();//数据总记录数

        List<CmsPage> content = all.getContent();
        System.out.println(content);
    }