使用wenhao完成SpringDataJpa高级查询

1.导包

<dependency>
    <groupId>com.github.wenhao</groupId>
    <artifactId>jpa-spec</artifactId>
    <version>3.1.1</version>
    <!-- 把所有的依賴都去掉 -->
    <exclusions>
        <exclusion>
            <groupId>*</groupId>
            <artifactId>*</artifactId>
        </exclusion>
    </exclusions>
</dependency>

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-lang3</artifactId>
    <version>3.5</version>
</dependency>

2.代码实现

public Specification createSpecification(){
    // StringUtils.isNotBlank判断字段是否为null或者空字符串
    Specification<Employee> spec = Specifications.<Employee>and()

            // 以下就是自定义查询条件    isNotBlank表示不为空、不为空字符串
            .like(StringUtils.isNotBlank(username),"username", "%"+username+"%")
            .like(StringUtils.isNotBlank(email),"email","%"+email+"%")
            .gt(age!=null,"age",age)
            .build();
    return spec;
}

转载于:https://my.oschina.net/u/4107179/blog/3030087