package com.gkhy.labRiskManage.domain.experiment.repository.jpa; import com.gkhy.labRiskManage.domain.experiment.entity.ExperimentAndSite; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Modifying; import org.springframework.data.jpa.repository.Query; import org.springframework.stereotype.Repository; import java.util.List; /** * @email 1603559716@qq.com * @author: zf * @date: 2023/3/20 * @time: 16:18 */ @Repository public interface ExperimentAndSiteRepository extends JpaRepository { @Modifying @Query(value = "update experiment_and_site set delete_status = 1 where experiment_id = :experimentId",nativeQuery = true) int deleteByExperimentId(Long experimentId); @Query(value = "select * from experiment_and_site where delete_status = 0 and experiment_id = :id",nativeQuery = true) List getByExperimentId(Long id); }