| | |
| | | import com.gkhy.fourierSpecialGasMonitor.entity.DeviceExceptionLog; |
| | | import org.springframework.data.jpa.repository.JpaRepository; |
| | | import org.springframework.data.jpa.repository.JpaSpecificationExecutor; |
| | | import org.springframework.data.jpa.repository.Query; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Repository |
| | | public interface DeviceExceptionLogRepository extends JpaRepository<DeviceExceptionLog,Long>, JpaSpecificationExecutor<DeviceExceptionLog> { |
| | | |
| | | @Query(value="SELECT * FROM device_exception_log a ORDER BY a.time DESC LIMIT 1",nativeQuery= true) |
| | | DeviceExceptionLog getLastLog(); |
| | | } |