Elite Club Search Feature
Explore how to implement a case insensitive search feature in a Spring Boot application. Understand the use of the @Query annotation with JPAQL, the addition of repository and service methods, and how to verify results through console output to enhance your database integration skills.
In the previous chapter, we learned how to build queries and fetch data from DB using various techniques.
In this chapter, we are going to utilize our knowledge and implement a search feature.
To implement our feature we will use the @Query annotation technique. There are two reasons for that:
- As per our requirements, the search should be case insensitive. The Named Method approach does not have a mechanism to distinguish between lower and upper case column values, thus we cannot use this approach.
- Named Query and
@Queryannotations are similar but, I personally prefer@Queryannotation because it it is the midpoint between the other two approaches. Moreover, the visibility of the query in the repository on the top of the method gives us easy navigation and debuggability.
Feature implementation
To implement our feature, we are required to perform the ...