spring data custom query

Ahmed El Sabagh answered on October 4, 2022 Popularity 9/10 Helpfulness 4/10

answer spring data custom query

spring data custom query

Comment

// JPQL
@Query("SELECT u FROM User u WHERE u.status = 1")
Collection<User> findAllActiveUsers();

// Native
@Query(
  value = "SELECT * FROM USERS u WHERE u.status = 1", 
  nativeQuery = true)
Collection<User> findAllActiveUsersNative();


// JPQL Pagination
@Query(value = "SELECT u FROM User u ORDER BY id")
Page<User> findAllUsersWithPagination(Pageable pageable);

// Native Pagination
@Query(value = "SELECT u FROM User u ORDER BY id")
Page<User> findAllUsersWithPagination(Pageable pageable);

@Query(
  value = "SELECT * FROM Users ORDER BY id", 
  countQuery = "SELECT count(*) FROM Users", 
  nativeQuery = true)
Page<User> findAllUsersWithPagination(Pageable pageable);

Popularity 9/10 Helpfulness 4/10 Language java

Source: Grepper

Tags: java spring-data

Link to this answer
Share Copy Link

Contributed on Oct 04 2022

Ahmed El Sabagh

0 Answers Avg Quality 2/10

spring data custom query

Contents

More Related Answers

spring data custom query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.