Spring Jpa-spec插件介绍，构建复杂查询，快速上手

桃扇骨 2022-01-06 14:25 290阅读 0赞

转载自：[https://baijiahao.baidu.com/s?id=1627039521629851707&wfr=spider&for=pc][https_baijiahao.baidu.com_s_id_1627039521629851707_wfr_spider_for_pc]

1.添加Maven依赖

<dependency> 
        <groupId>com.github.wenhao</groupId> 
        <artifactId>jpa-spec</artifactId> 
        <version>3.2.4</version>
        
        <exclusions>
          <exclusion>
            <groupId>*</groupId>
            <artifactId>*</artifactId>
          </exclusion>
        </exclusions>
    </dependency>

我们创建Repository 的时候需要继承2个JpaRepository 和JpaSpecificationExecutor

![20190624235713147.png][]

![20190624235755551.png][]

Equal/NotEqual 实例

find any person nickName equals to "dog" and name equals to "Jack"/"Eric" or null value, and company is null.

![2019062423590891.png][]

In/NotIn 实例

find any person name in "Jack" or "Eric" and company not in "ThoughtWorks" or "IBM".

![7aec54e736d12f2e7b4373c62d45a3668435685a.jpeg_token_22d482e934983718abb9b7b017e0ddf0_s_8A40CD10CD304C034C4564DE000010B3][]![20190624235942280.png][]

Comparison 实例

Support any comparison class which implements Comparable interface, find any people age bigger than 18.

![2019062500000636.png][]

![8cb1cb1349540923ac0900c7f6dfa70db2de49b6.jpeg_token_e914c9cc29fb952d3820338cc524d60a_s_8071CD309B704C014CC5A1DE0000D0B3][]

Between 实例

![96dda144ad3459826bf36caa6f7347a9cbef841d.jpeg_token_afdbae36f6498b1323104680f9fd87cd_s_8271CD30DFE45C031CFDB1DA0100D0B3][]![20190625000029314.png][]

Like/NotLike 实例

find any person name like %ac% or %og%, company not like %ec%.

![eac4b74543a9822667fe60d4e905cf054b90eb96.jpeg_token_3c0770130f243a3897615486be01a3b9_s_8A70CD128FF46C035C4DE0DA000080B3][]![20190625000044216.png][]

And and Or实例

![d01373f082025aaf945faf8b9d6add60024f1a88.jpeg_token_4e2e4c6280d640d16d374cc91fab5c53_s_C2710F709BC049431CFDC5DF0000D0B3][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70][]

Join关联查询

多对一查询

![4610b912c8fcc3ce4ad4942df1c2a08cd43f2027.jpeg_token_2ee8ce9019a20a23ddb68516dab3aca3_s_8371CD32C7345C234CC5A1CE0000C0B3][]![20190625000113489.png][]

多对多查询

![94cad1c8a786c91716531d6cabba06cb3ac7579a.jpeg_token_c720f9333709b74147c9a7a4ef966e9d_s_8151CD30CFB44C030C44D0DE000080B3][]![20190625000129687.png][]

自定义查询：

多对一查询

![2e2eb9389b504fc2ca910854865a911591ef6d24.jpeg_token_2344276c69d1c3d8c6f7bbac75bc2a4c_s_8A71CD108FC449430CD585DE000080B3][]![20190625000149467.png][]

多对多查询

![cdbf6c81800a19d8d474d296587df48fa71e46bd.jpeg_token_1badf7647320dc91df62ffabcec02eef_s_0250CF308FC84C410ED5C5DE000080B3][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1][]

排序查询：

![6f061d950a7b0208acac7b42065e84d7562cc8bc.jpeg_token_b01f6497bb488b015c0270ce7deab433_s_8271CD3019C8594B5E650CDA0000D0B3][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2][]

分页查询

![5243fbf2b21193134a84593007bf7ad393238df3.jpeg_token_10fc3c035d3eac82802cad9b415ba7b5_s_8051CF301BC84C410ED509DB0000C0B1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3][]

@Test
        public void testPrint(){
            Specification<Student> grade = Specifications.<Student>and()
                    .between("grade", 1, 20)
                    .build();
            // 默认为升序排列
            Sort sort = new Sort(Sort.Direction.DESC,"grade");
            // 分页条件中加入排序
            PageRequest pageRequest = PageRequest.of(1 - 1, 10,sort);
            // 根据条件、分页、排序来查找
            Page<Student> all = studentRepository.findAll(grade, pageRequest);
            // 查找所有并排序
            List<Student> all1 = studentRepository.findAll(sort);
            // 根据条件查找，并排序
            List<Student> all2 = studentRepository.findAll(grade, sort);
            // 根据分页条件来查询
            Page<Student> all3 = studentRepository.findAll(pageRequest);
    
            List<Student> content = all.getContent();
            for (Student student : content) {
                System.out.println(student);
            }
        }

[https_baijiahao.baidu.com_s_id_1627039521629851707_wfr_spider_for_pc]: https://baijiahao.baidu.com/s?id=1627039521629851707&wfr=spider&for=pc
[20190624235713147.png]: /images/20211227/78419053bdac47c7983f95561b624f14.png
[20190624235755551.png]: /images/20211227/a99470e829144e5a907f530797f7be97.png
[2019062423590891.png]: /images/20211227/7282d78d58694908b06c2f960ef1da1a.png
[7aec54e736d12f2e7b4373c62d45a3668435685a.jpeg_token_22d482e934983718abb9b7b017e0ddf0_s_8A40CD10CD304C034C4564DE000010B3]: https://pics2.baidu.com/feed/7aec54e736d12f2e7b4373c62d45a3668435685a.jpeg?token=22d482e934983718abb9b7b017e0ddf0&s=8A40CD10CD304C034C4564DE000010B3
[20190624235942280.png]: /images/20211227/7210d5964e6e46f4b02b29eaf7f7ecdf.png
[2019062500000636.png]: /images/20211227/3282f4d015394e01ac80969315837dcf.png
[8cb1cb1349540923ac0900c7f6dfa70db2de49b6.jpeg_token_e914c9cc29fb952d3820338cc524d60a_s_8071CD309B704C014CC5A1DE0000D0B3]: /images/20211227/47377b8351fc4784a0d7089bc24cc0c4.png
[96dda144ad3459826bf36caa6f7347a9cbef841d.jpeg_token_afdbae36f6498b1323104680f9fd87cd_s_8271CD30DFE45C031CFDB1DA0100D0B3]: https://pics5.baidu.com/feed/96dda144ad3459826bf36caa6f7347a9cbef841d.jpeg?token=afdbae36f6498b1323104680f9fd87cd&s=8271CD30DFE45C031CFDB1DA0100D0B3
[20190625000029314.png]: /images/20211227/b7eae4eb2687405aa42e8282a175781e.png
[eac4b74543a9822667fe60d4e905cf054b90eb96.jpeg_token_3c0770130f243a3897615486be01a3b9_s_8A70CD128FF46C035C4DE0DA000080B3]: https://pics5.baidu.com/feed/eac4b74543a9822667fe60d4e905cf054b90eb96.jpeg?token=3c0770130f243a3897615486be01a3b9&s=8A70CD128FF46C035C4DE0DA000080B3
[20190625000044216.png]: /images/20211227/98d1aebc6d4a4f16a4550fb35469b0c0.png
[d01373f082025aaf945faf8b9d6add60024f1a88.jpeg_token_4e2e4c6280d640d16d374cc91fab5c53_s_C2710F709BC049431CFDC5DF0000D0B3]: https://pics0.baidu.com/feed/d01373f082025aaf945faf8b9d6add60024f1a88.jpeg?token=4e2e4c6280d640d16d374cc91fab5c53&s=C2710F709BC049431CFDC5DF0000D0B3
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]: /images/20211227/bf5b2ebd0b6d464d957c068a38a3db91.png
[4610b912c8fcc3ce4ad4942df1c2a08cd43f2027.jpeg_token_2ee8ce9019a20a23ddb68516dab3aca3_s_8371CD32C7345C234CC5A1CE0000C0B3]: https://pics5.baidu.com/feed/4610b912c8fcc3ce4ad4942df1c2a08cd43f2027.jpeg?token=2ee8ce9019a20a23ddb68516dab3aca3&s=8371CD32C7345C234CC5A1CE0000C0B3
[20190625000113489.png]: /images/20211227/9c9d54f16ca644488fb37942fa2bd018.png
[94cad1c8a786c91716531d6cabba06cb3ac7579a.jpeg_token_c720f9333709b74147c9a7a4ef966e9d_s_8151CD30CFB44C030C44D0DE000080B3]: https://pics2.baidu.com/feed/94cad1c8a786c91716531d6cabba06cb3ac7579a.jpeg?token=c720f9333709b74147c9a7a4ef966e9d&s=8151CD30CFB44C030C44D0DE000080B3
[20190625000129687.png]: /images/20211227/e770ca11233740329849bcd39643640b.png
[2e2eb9389b504fc2ca910854865a911591ef6d24.jpeg_token_2344276c69d1c3d8c6f7bbac75bc2a4c_s_8A71CD108FC449430CD585DE000080B3]: https://pics1.baidu.com/feed/2e2eb9389b504fc2ca910854865a911591ef6d24.jpeg?token=2344276c69d1c3d8c6f7bbac75bc2a4c&s=8A71CD108FC449430CD585DE000080B3
[20190625000149467.png]: /images/20211227/5f5b208523554654997947a76a4fb004.png
[cdbf6c81800a19d8d474d296587df48fa71e46bd.jpeg_token_1badf7647320dc91df62ffabcec02eef_s_0250CF308FC84C410ED5C5DE000080B3]: https://pics0.baidu.com/feed/cdbf6c81800a19d8d474d296587df48fa71e46bd.jpeg?token=1badf7647320dc91df62ffabcec02eef&s=0250CF308FC84C410ED5C5DE000080B3
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1]: /images/20211227/d847b680522d4257873676c0f0c4986e.png
[6f061d950a7b0208acac7b42065e84d7562cc8bc.jpeg_token_b01f6497bb488b015c0270ce7deab433_s_8271CD3019C8594B5E650CDA0000D0B3]: https://pics5.baidu.com/feed/6f061d950a7b0208acac7b42065e84d7562cc8bc.jpeg?token=b01f6497bb488b015c0270ce7deab433&s=8271CD3019C8594B5E650CDA0000D0B3
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2]: /images/20211227/ca6ec142d9e24f43a15d2691ea641129.png
[5243fbf2b21193134a84593007bf7ad393238df3.jpeg_token_10fc3c035d3eac82802cad9b415ba7b5_s_8051CF301BC84C410ED509DB0000C0B1]: https://pics7.baidu.com/feed/5243fbf2b21193134a84593007bf7ad393238df3.jpeg?token=10fc3c035d3eac82802cad9b415ba7b5&s=8051CF301BC84C410ED509DB0000C0B1
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3]: /images/20211227/8540daee48f64a4d8d92b733632d5888.png