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);
}