How to compose query using the @Query annotation and HQL

Question

Can somebody help how to compose a HQL query with JPA @Query on the following line?

"get me all books which has this author and are published after year X"

Consider a simple entity without relationship - more concern on the JPA @Query and HQL combination:

@Entity public class Book{ @Id public int id; public String title, public String authorName; public String yearOfPublish; .....

}

Yet to create...You can Consider a simple one with date of year as String — user2693135
– user2693135, Commented Nov 12, 2021 at 5:38
Without the entity model I cannot tell you how the query should look like. — Simon Martinelli
– Simon Martinelli, Commented Nov 12, 2021 at 7:21
Yes. Im using Spring Data JPA Repository...Assume I defined a method: List<Book> getBooksByAuthorAnd GreaterThenYear(String authorName, String year ) — user2693135
– user2693135, Commented Nov 14, 2021 at 5:34

Simon Martinelli · Accepted Answer · 2021-11-14 08:28:31Z

The query would be:

select b from Book b where b.authorName = :authorName and yearOfPublish > :year

And as you are using Spring Data JPA you don't even need to write the Query! Simply write a method:

List<Book> findAllByAuthorNameAndYearOfPublishGreaterThan(String authorName, String yearOfPublish);

This will create the query for you.

1 Answer 1