jpa-Example 单表模糊查询

guoyiguang2

已于 2023-02-10 11:17:50 修改

阅读量900

点赞数

分类专栏： jpa 文章标签： java servlet 开发语言 Powered by 金山文档

于 2023-02-03 11:58:45 首次发布

本文链接：https://blog.csdn.net/qq_38807606/article/details/128864023

版权

jpa 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

 
        AreaEntity areaEntityExample = new  AreaEntity();

        // 设置parentId 的精确匹配 
        areaEntityExample.setParentId(req.getParentId());
        areaEntityExample.setDelFlag(false);


        // 模糊查询
        //实例化对象
        ExampleMatcher matching = ExampleMatcher.matching();
        if(StringUtils.isNotBlank(req.getVagueName())){
            //设置搜索的字段 模糊匹配 (name 是 类属性，而不是 表字段，比如 可以用 fullName 而不是 full_name)
            matching = matching.withMatcher("name",ExampleMatcher.GenericPropertyMatchers.contains());
            // 接收前端 传过来的值
            apsHSysAreaEntityExample.setName(req.getVagueName());
        }

        Example<ApsHSysAreaEntity> example = Example.of(apsHSysAreaEntityExample,matching);


        List<ApsHSysAreaEntity> sonListFromDb = repository.findAll(example);

2. 不用框架的 findAll

JPAQueryFactory queryFactory = SpringUtil.getBean(JPAQueryFactory.class);

        String numberOrShortName = req.getQuery().getNumberOrShortName();
        // QApsHCustomerManageEntity
        //查询排产数据
        JPAQuery<ApsHCustomerManageResp> query = queryFactory.select(Projections.fields(ApsHCustomerManageResp.class,
                customerEntity.uid,
                customerEntity.address,
                customerEntity.cityId,
                customerEntity.city,
                customerEntity.country,
                customerEntity.countryId,
                customerEntity.province,
                customerEntity.provinceId,
                customerEntity.discount,
                customerEntity.fax,
                customerEntity.fullName,
                customerEntity.shortName,
                customerEntity.mailbox,
                customerEntity.number,
                customerEntity.priority,
                customerEntity.operationType,
                customerEntity.postalCode,
                customerEntity.transportationDuration,
                customerEntity.status,
                customerEntity.tel,
                customerEntity.remark,
                customerEntity.website
        )).from(customerEntity).where(customerEntity.delFlag.eq(false)

                .and(customerEntity.number.like("%" + numberOrShortName + "%").or(customerEntity.fullName.like("%" + numberOrShortName + "%")))




        );

  List<ApsHCustomerManageResp> data = query.orderBy(customerEntity.creationDate.desc())
                // 前端从 1 页开始传
                .offset((req.getPageNo() - 1) * req.getPageSize())
                .limit(req.getPageSize())
                .fetch();
        log.info("客户列表的参数 {}", numberOrShortName);