# jpa-lambda-query

**Repository Path**: huang_jianwu/jpa-lambda-query

## Basic Information

- **Project Name**: jpa-lambda-query
- **Description**: 基于spring-jpa的Lambda查询方式，能够实现通过Lambda进行条件查询，关联属性加载，关联属性的子查询
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 27
- **Created**: 2019-09-03
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# jpa-lambda-query
[![](https://jitpack.io/v/xuejike/jpa-lambda-query.svg)](https://jitpack.io/#xuejike/jpa-lambda-query)


#### 介绍
基于spring-jpa的Lambda查询方式，能够实现通过Lambda进行条件查询，关联属性加载，关联属性的子查询

#### 安装教程

1. 使用Spring-starter进行安装
```groovy
repositories {

    maven { url 'https://jitpack.io' }

}


com.github.xuejike.jpa-lambda-query:jpa-lambda-starter:0.1.2


```
2. 手动安装
2.1. 引入依赖

```groovy
com.github.xuejike.jpa-lambda-query:jpa-lambda-core:0.1.2
```
2.2. 初始化
```java
        JpaQuerys.setEntityManager(entityManager);

```


#### 使用说明

1. 简单的查询语句
```java
        //正常查询
        JpaLambdaQuery<User> userQuery = JpaQuerys.lambda(User.class);
        List<User> list = userQuery.eq(User::getUsername, "111")
                .gt(User::getCreateTime, LocalDateTime.now())
                .list();
```
2. 嵌套的Or And查询语句
```java
 List<User> list1 = JpaQuerys.lambda(User.class)
                .eq(User::getUsername, "123")
                .orEq(User::getUsername, "456")
                .or(or->or.eq(User::getUsername,"lll").eq(User::getPwd,"456"))
                .list();
```
3. 分页查询
```java
     Page<User> userPage = JpaQuerys
                .lambda(User.class, entityManager)
                .pageList(new Page(1, 10));
```

4. 加载关联数据
```java
        List<User> list1 = JpaQuerys.lambda(User.class)
                .eq(User::getUsername, "123")
                .loadJoin(User::getDept).list();
```
5. 使用关联属性进行关联查询
```java
        List<User> list2 = JpaQuerys.lambda(User.class)
                .subQuery(User::getDept, lambda -> lambda.eq(Dept::getId, 1)).list();
```