QueryDSL

https://querydsl.github.io/

Admin

QueryDSL is a unified query framework for Java that enables compact, safe, and type-safe queries...

Tokens:392

Snippets:8

Trust Score:9.7

Update:5 months ago

Show doc for...

Tokens:

Raw

### Order Query Results

Source: https://querydsl.github.io

Selects persons and orders them by last name in ascending order, then by first name in descending order.

```java
List<Person> persons = queryFactory.selectFrom(person)
  .orderBy(person.lastName.asc(), 
           person.firstName.desc())
  .fetch();
```

--------------------------------

### Tuple Projection Query

Source: https://querydsl.github.io

Selects the last name, first name, and year of birth for each person.

```java
List<Tuple> tuples = queryFactory.select(
    person.lastName, person.firstName, person.yearOfBirth)
  .from(person)
  .fetch();
```

--------------------------------

### Basic Person Query

Source: https://querydsl.github.io

Selects persons from the database where the first name is 'John' and the last name is 'Doe'.

```java
List<Person> persons = queryFactory.selectFrom(person)
  .where(
    person.firstName.eq("John"),
    person.lastName.eq("Doe"))
  .fetch();
```

--------------------------------

### Subquery for Person Size

Source: https://querydsl.github.io

Selects persons where the size of their children list equals the maximum size of children lists from all parents.

```java
List<Person> persons = queryFactory.selectFrom(person)
  .where(person.children.size().eq(
    JPAExpressions.select(parent.children.size().max())
                  .from(parent)))
  .fetch();
```

Tokens:

Raw