package com.boying.dao;
|
|
import com.boying.common.BaseDao;
|
import com.boying.entity.Street;
|
import com.boying.entity.StreetReRoad;
|
import com.boying.entity.User;
|
import org.springframework.data.jpa.repository.Query;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
@Repository("streetDao")
|
public interface StreetDao extends BaseDao<Street, Long>{
|
|
@Query(value = "select b from Street a,StreetReRoad b where a.id=b.roadId and b.roadId=:id order by a.code asc")
|
List<StreetReRoad> findById2(Long id);
|
|
@Query(value = "select a from Street a,StreetReRoad b where a.id=b.roadId and b.streetId=:id order by a.code asc")
|
List<Street> findById3(Long id);
|
}
|