ChangeDelDetailRepository.java

package common.repository;

import common.model.ChangeDelDetail;
import common.model.ChangeDelInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface ChangeDelDetailRepository extends JpaRepository<ChangeDelDetail, Long> {


    @Query(value = "select * from change_del_detail where parent_id = ?1 order by creat_time desc ",nativeQuery = true)
    List<ChangeDelDetail> findByPid(String pid);
}