Passing parameters

Report a typo

Here is our Car class:

@Entity
public class Car {
    @Id
    @GeneratedValue
    private long id;
    private int releaseYear;
    private String color;
    private String model;
    private String company;
    private int minPrice;

    // constructor, getters, setters
}

Which of the following methods, declared at CarRepository, are correct?

public interface CarRepository extends CrudRepository<Car, Long> {
 
    @Query("SELECT c FROM Car c WHERE c.model = ?1")
    Car findByModel(String model);

    @Query("SELECT c FROM Car c WHERE c.model = ?1 AND c.releaseYear = ?2")
    Car findByYear(int year);
    
    @Query("SELECT c FROM Car c WHERE c.company = :company")
    Car findByCompany(@Param("company_name") String company);

    @Query("SELECT c FROM Car c WHERE c.color = :color")
    Car findByColor(String color);

    @Query("SELECT c FROM Car c WHERE c.minPrice = :min_price")
    Car findByPrice(int minPrice);
}
Select one or more options from the list
___

Create a free account to access the full topic