[Spring Boot] JPA @Query

기본 select를 제외하고 실제 쿼리문으로 쿼리를 하려고한다.

@Query(value = "SELECT * FROM MEMBER mem WHERE mem.age = (:age) AND mem.office = (:office)", nativeQuery = true)
public List<member> selectByAgeOffice(@Param(value = "age")int age, @Param(value = "office")String office);
 

memberRepository.java에 추가

@GetMapping("select")
public List<member> selectByAgeOffice() {
    return memberrepo.selectByAgeOffice(60,"London");
}
 

APIController.java에 추가

 

참고 : https://www.baeldung.com/spring-data-jpa-query

---

jpa org.springframework.beans.factory.UnsatisfiedDependencyException

@Query를 사용하여 쿼리문을 작성한 뒤 해당 에러가 발생했다.

오류 내용을 읽어보니 쿼리문 구문 문법 오류였다

@Query(value = "SELECT * FROM MEMBER mem WHERE mem.age = (:office) AND mem.office = (:office)",nativeQuery = true)

오타...