Computer scienceBackendSpring BootSpring Data

Custom queries with @Query

Query string with pagination

Report a typo

Here is a model class that describes the Movie entity:

@Entity
public class Movie {
    @Id
    @GeneratedValue
    private long id;
    private String name;
    private String country;
    private String director;
    private int realiseYear;

    // constructor, getters, setters
}

We have declared a method getPage to get a certain page of movies by a specific director:

public interface MovieRepository extends CrudRepository<Movie, Long> {
 
    @Query("____")
    Page<Movie> getPageByDirector(@Param("filmDirector")String director, Pageable page);
}

Which of the following query strings is/are correct for this method?

Select one or more options from the list

SELECT m FROM Movie m ORDER BY :filmDirector

SELECT * FROM movies WHERE director = :filmDirector

SELECT m FROM Movie m WHERE m.director = :filmDirector LIMIT :page OFFSET :page

SELECT m FROM Movie m WHERE m.director = :filmDirector

SELECT m FROM Movie m WHERE m.director = :director

___

Create a free account to access the full topic