[Spring Data JPA] 3-2. JPA Query Methods (3)

7. Other Methods

Custom Implementation

예제) Criteria API

public interface UserRepository extends JpaRepository<User, Long>, CustomUserRepository {
    // 기본 JPA 쿼리 메서드
}

public class CustomUserRepositoryImpl implements CustomUserRepository {

    @PersistenceContext
    private EntityManager entityManager;

    @Override
    public List<User> findUsersCustomMethod(String criteria) {
        String query = "SELECT u FROM User u WHERE u.criteria = :criteria";
        return entityManager.createQuery(query, User.class)
                            .setParameter("criteria", criteria)
                            .getResultList();
    }
}

 

Stored Procedure

예제) @StoredProcedure

public interface UserRepository extends JpaRepository<User, Long> {
  
  @Procedure(name = "FIND_USERS_BY_STATUS")
  List<User> findUsersByStatus(@Param("status") String status);
}

 

출처

• Spring Data JPA - JPA Query Methods