單獨使用`@Query`注解只是查詢，如涉及到修改、刪除則需要再加上`@Modifying`注解。 ```java public interface UserRepository extends JpaRepository<User, Integer>, JpaSpecificationExecutor<User> { @Transactional @Modifying @Query("update User u set u.password = ?2 where u.username = ?1") int updatePasswordByUsername(String username, String password); @Transactional @Modifying @Query("delete from User where username = ?1") void deleteByUsername(String username); } ``` >[info]更新與刪除只能使用`void`或`int/Integer`作為返回類型！