package com.northglass.repository;
|
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.DropFrame;
|
import com.northglass.entity.DropFrame2;
|
|
public interface DropFrameDao2 extends JpaRepository<DropFrame2, Long>{
|
|
@Query("select t from DropFrame2 t where t.groups=?1")
|
public List<DropFrame2> findBystop(Long groups);
|
|
@Query("select t from DropFrame2 t where t.groups=?3 and t.stops=?1 and t.noodles<>?2")
|
public DropFrame2 findnoodles(int stops,String noodles,Long groups);
|
|
@Query("select t from DropFrame2 t where t.groups=?3 and t.stops<>?1 and t.noodles<>?2")
|
public DropFrame2 findnoodles2(int stops,String noodles,Long groups);
|
|
@Query("select t from DropFrame2 t where t.groups=?1")
|
public List<DropFrame2> findBygroupsfalg(Long groups);
|
}
|