潘钊 / bsth_control · Files

package com.bsth.repository;

import com.bsth.entity.CarDevice;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

/**
 * Created by xu on 16/6/15.
 */
@Repository
public interface CarDeviceRepository extends BaseRepository<CarDevice, Long> {
	@Query(value="select s from CarDevice s where s.newDeviceNo=?1 and s.qyrq<=?2 ")
	List<CarDevice> findCarDevice(String device,Date date );
}