/** * Specifies methods used to obtain and modify person related information * which is stored in the database. * @author Petri Kainulainen */ public interface PersonRepository extends JpaRepository<Person, Long> { /** * Finds a person by using the last name as a search criteria. * @param lastName * @return A list of persons whose last name is an exact match with the given last name. * If no persons is found, this method returns an empty list. */ @Query("SELECT p FROM Person p WHERE LOWER(p.lastName) = LOWER(:lastName)") public List<Person> find(@Param("lastName") String lastName); }
@Query("update HsAlbum album set album.albumName = :#{hsAlbum.albumName} ,album.description = :#{hsAlbum.description } ") public int update(HsAlbum hsAlbum);