jpa自定义更新语句

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import javax.transaction.Transactional;
import java.util.Date;

public interface TemplateDao extends CrudRepository<Template, String>, JpaSpecificationExecutor<Template> {
    @Modifying
    @Transactional
    @Query(value = "update sms_template set template_status=:status,reason=:reason,modifier=:modifier,modified_date=:modifiedDate where id=:id", nativeQuery = true)
    int updateTemplateStatusById(@Param("status") String status, @Param("reason") String reason, @Param("modifier") String modifier, @Param("modifiedDate") Date modifiedDate, @Param("id") String id);
}

@Transactional//事务的注解
@Modifying//增删改必须有这个注解