package com.gkhy.labRiskManage.domain.experiment.repository.jpa; import com.gkhy.labRiskManage.domain.experiment.entity.ExperimentAndEmergency; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Modifying; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; /** * @email 1603559716@qq.com * @author: zf * @date: 2023/4/24 * @time: 10:40 */ @Repository public interface ExperimentAndEmergencyRepository extends JpaRepository { @Modifying @Query(value = "update experiment_and_emergency set delete_status = 1 where experiment_id = :experimentId",nativeQuery = true) int deleteByExperimentId(@Param("experimentId") Long experimentId); }