@query spring boot code example

Example 1: jpql spring boot

@Query("SELECT u FROM User u WHERE u.status = :status and u.name = :name")User findUserByStatusAndNameNamedParams(  @Param("status") Integer status,   @Param("name") String name);

Example 2: findbyname in jpa

List<User> findByBirthDateAfter(ZonedDateTime birthDate);List<User> findByBirthDateBefore(ZonedDateTime birthDate);