From cfc2855d2fe063e26947bad7277a1091efbb3bbb Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期四, 28 十一月 2024 02:16:21 +0800
Subject: [PATCH] 协议地址更新，手动页面更新
---
springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java
index ff9ce1b..913c7a4 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/QueueMapper.java
@@ -23,6 +23,9 @@
@Select("SELECT * FROM queue where state<2 order by time desc limit 1")
Queue selectLastQueue2();
+
+ @Select("SELECT * FROM queue where state=1 order by time desc limit 1")
+ Queue selectLastQueue3();
@Select("SELECT * FROM queue where state<=0")
List<Queue> selectErrorQueues();
@@ -44,7 +47,8 @@
@Delete("delete from queue where state<=0")
void DeleteErrorQueue();
-
+ @Delete("delete from queue where state<2")
+ void DeletefromQueue();
@Delete("delete from queue where state<1")
void DeleteQueue();
@Insert("INSERT into queue (flowcard,glassId,mateid,glasstype,glasswidth,glassheight,thickness,state,time) VALUES (#{flowcard},#{glassId},#{mateid},#{glasstype},#{glasswidth},#{glassheight},#{thickness},1,NOW())")
--
Gitblit v1.8.0