单独使用`@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`作为返回类型！