spring jpa @Query 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> findByNameIsNot(String name);