jpa Specification使用

最新推荐文章于 2024-08-24 09:22:22 发布

莹未来

最新推荐文章于 2024-08-24 09:22:22 发布

阅读量8.6k

点赞数

分类专栏： SPRING

本文链接：https://blog.csdn.net/jiyingying_up/article/details/76910361

版权

SPRING 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

spring jpa Specification 使用

本文只是做个笔记，备忘

 public Page<Message> list(BootPage bootPage,MessageQuery messageQuery){

        Pageable pageable = new PageRequest(bootPage.getOffset() / bootPage.getLimit(), bootPage.getLimit(),bootPage.getOrder());

        Specification<Message> spec1 = (root, query, cb) -> {

            Path<Long> tPath = root.get("target");

            /*Target is ALL*/
            cb.equal(tPath, Message.Target.ALL);

            return null;
        };

        Specification<Message> spec2 = (root, query, cb) -> {

            Path<Long> tPath = root.get("target");
            Path<String> vPath = root.get("value");

            /*or , Target is SCHOOL and value like ou */
            cb.equal(tPath, Message.Target.SCHOOL);
            cb.like(vPath, "%"+messageQuery.getOu().trim()+"%");

            return null;
        };

        Specification<Message> spec3 = (root, query, cb) -> {

            Path<Long> tPath = root.get("target");
            Path<String> vPath = root.get("value");

            /*Target is PERSONAL and value like uid*/
            cb.equal(tPath,Message.Target.PERSONAL);
            cb.like(vPath,"%"+messageQuery.getUid()+"%");

            return null;
        };

        Specification spec = Specifications.where(spec1).or(spec2).or(spec3);

        return repository.findAll(spec,pageable);
    }