Hackforge Academy

Explanation

Update query in JPA requires @Modifying and @Transactional annotations.

Code:

@Modifying
@Transactional
@Query("UPDATE User u SET u.name = :name
 WHERE u.id = :id")
void updateName(@Param("id") Long id, 
@Param("name") String name);

Explanation

Delete query removes records from the database using JPQL.

Code:

@Modifying
@Transactional
@Query("DELETE FROM User u WHERE u.id = :id")
void deleteUser(@Param("id") Long id);

Explanation

Sorting can be done using ORDER BY in JPQL query.

Code:

@Query("SELECT u FROM User u ORDER BY u.name ASC")
List<User> getUsersSorted();

Explanation

LIKE operator is used for searching records with partial matching.

Code:

@Query("SELECT u FROM User u WHERE u.name LIKE %:keyword%")
List<User> searchUsers(@Param("keyword") String keyword);