Computer scienceBackendSpring BootSpring Data

Custom queries with @Query

Query string

Report a typo

Here is the Order class:

@Entity
public class Order {
    @Id
    @GeneratedValue
    private long id;
    private String status;
    private int price;

    // constructor, getters, setters
}

Let's say we have a custom @Query annotation that retrieves all the orders with a particular status and a total price greater than a specified value:

@Query("____")
List<Order> findOrdersByStatusAndPrice(int price, String status);

Which of the following query string will correctly produce the order list?

Select one option from the list

SELECT o FROM Order o WHERE o.status = ?1 AND o.price > ?2

SELECT o FROM Order o WHERE o.status = ?2 AND o.price > ?1

SELECT o FROM Order o WHERE o.status = :status OR o.price > :price

SELECT o FROM Order o WHERE o.status = :status AND o.price = :price

___

Create a free account to access the full topic