SpingData JPA之ExampleMatcher实例查询

最新推荐文章于 2024-10-14 11:10:01 发布

原创最新推荐文章于 2024-10-14 11:10:01 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

Spring相关专栏收录该内容

34 篇文章

订阅专栏

本文详细介绍了如何使用Java ORM框架进行数据库操作，包括通过Spring框架整合ORM框架，实现数据库查询、更新等操作。文中提供了具体的代码示例，展示了如何设置查询条件、分页查询以及数据转换的过程。

List<TableColumnGetResVO> list = new ArrayList<>();
        TableColumns tableColumnsQuery = new TableColumns();
        if(StringUtils.isNotBlank(reqVO.getTableName())){
            tableColumnsQuery.setTableName(reqVO.getTableName());
        }
        ExampleMatcher example = ExampleMatcher.matchingAll();
        List<TableColumns> tableColumnsList = tableColumnsRepository.findAll(Example.of(tableColumnsQuery, example));

        if(CollectionUtil.isNotEmpty(tableColumnsList)){
            for(TableColumns tableColumns : tableColumnsList){
                TableColumnGetResVO tableColumnGetResVO = new TableColumnGetResVO();
                BeanUtils.copyProperties(tableColumns, tableColumnGetResVO);
                list.add(tableColumnGetResVO);
            }
        }
        return list;

Pageable pageable = PageRequest.of(reqVO.getPageNo(), reqVO.getPageSize());

        Factory factoryQuery = new Factory();
        factoryQuery.setCode(reqVO.getCode());
        factoryQuery.setContact(reqVO.getContact());
        factoryQuery.setName(reqVO.getName());


        ExampleMatcher example = ExampleMatcher.matching()
                .withMatcher("code", ExampleMatcher.GenericPropertyMatchers.contains())
                .withMatcher("contact", ExampleMatcher.GenericPropertyMatchers.contains())
                .withMatcher("name", ExampleMatcher.GenericPropertyMatchers.contains());
        Page<Factory> factoryPage = factoryRepository.findAll(Example.of(factoryQuery, example),pageable);

        List<Factory> factoryList = factoryPage.getContent();

        List<FactoryGetResVO> factoryGetResVOList = new ArrayList<>();
        factoryList.forEach(factory -> {
            FactoryGetResVO factoryGetResVO = new FactoryGetResVO();
            BeanUtils.copyProperties(factory, factoryGetResVO);
            factoryGetResVOList.add(factoryGetResVO);
        });
        FactoryGetPageResVO factoryGetPageResVO = FactoryGetPageResVO.builder()
                .list(factoryGetResVOList).build();
        factoryGetPageResVO.setPageNo(factoryPage.getNumber());
        factoryGetPageResVO.setPageSize(factoryPage.getSize());
        factoryGetPageResVO.setTotalCount(factoryPage.getTotalPages());
        return factoryGetPageResVO;