# jpa-query-wrapper

**Repository Path**: xiaofanger/jpa-query-wrapper

## Basic Information

- **Project Name**: jpa-query-wrapper
- **Description**: spring data jpa的LambdaQueryWrapper 实现，可以和写MP一样写JPA代码了
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 11
- **Created**: 2021-09-25
- **Last Updated**: 2022-05-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# jpa-query-wrapper

#### 介绍
spring data jpa的LambdaQueryWrapper 实现，使用方法和mybatis plus保持一致，减少了mybatis plus开发者转向JPA的学习成本，仅仅实现了80%的功能，欢迎大家一起开发

#### MAVEN
```xml
<dependency>
  <groupId>com.fhs-opensource</groupId>
  <artifactId>jpa-query-wrapper</artifactId>
  <version>1.0.0</version>
</dependency>
```

#### 如何使用
1、DAO 继承JpaSpecificationExecutor

``` java
@Repository
public interface SchoolRepository extends JpaRepository<School, String>, JpaSpecificationExecutor<School> {

}
```
2、调用dao的findAll

``` java
@Autowired
    private SchoolRepository schoolRepository;

    @Test
    public void test(){
        System.out.println(schoolRepository.findAll(new LambdaQueryWrapper<School>().or(wrapper->{
            wrapper.eq(School::getId,1);//id为1 or id 为2 都被查出来
            wrapper.eq(School::getId,2);
        }).like(School::getSchoolName,"一") //名称like 一的
                .orderByAsc(School::getId).build()));//排序
    }
```
#### 支持的方法
 EQ, LIKE, NE, GE, GT, LE, LT, IN, BETWEEN, NOTIN,ISNULL,NOTNULL，Order by，OR
#### 联系我们
QQ群 976278956