From d0ed3bf68c62fc4c5177c5a91f72b141f643a12a Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期日, 18 九月 2022 18:01:47 +0800
Subject: [PATCH] 修改规则和出场日志
---
src/main/java/com/boying/dao/EnterParkDao.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/boying/dao/EnterParkDao.java b/src/main/java/com/boying/dao/EnterParkDao.java
index a046f74..447686f 100644
--- a/src/main/java/com/boying/dao/EnterParkDao.java
+++ b/src/main/java/com/boying/dao/EnterParkDao.java
@@ -7,6 +7,7 @@
import org.springframework.stereotype.Repository;
import java.util.Date;
+import java.util.List;
@Repository("enterParkDao")
public interface EnterParkDao extends BaseDao<EnterPark, Long>{
@@ -14,8 +15,8 @@
@Query(value = "select count(id) from EnterPark where createTime>:startTime and createTime<:endTime")
long count1(Date startTime, Date endTime);
- @Query(value = "from EnterPark where carNo=:carNo and id = (select max(id) from EnterPark)")
- EnterPark findByCarNo(String carNo);
+ @Query(value = "from EnterPark where carNo=:carNo order by createTime desc")
+ List<EnterPark> findByCarNo(String carNo);
@Modifying
@Query(value = "delete from EnterPark where carNo=:carNo and parkId=:parkId")
--
Gitblit v1.9.1