package com.gkhy.labRiskManage.domain.experiment.repository.jpa; import com.gkhy.labRiskManage.domain.experiment.entity.ExperimentAndStuff; import org.springframework.data.domain.Pageable; 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; import java.util.List; /** * 实验与耗材 */ @Repository public interface ExperimentAndStuffRepository extends JpaRepository { @Modifying @Query(value = "update experiment_and_stuff set delete_status = 1 where experiment_id = :experimentId",nativeQuery = true) int deleteByExperimentId(@Param("experimentId") Long experimentId); }