From ea46f28356e2acb3bc7cc69b9af3c52fab38c0b0 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期四, 18 一月 2024 16:56:47 +0800
Subject: [PATCH] 终止任务功能测试

---
 springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java |   96 +++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 91 insertions(+), 5 deletions(-)

diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java
index ebd7eeb..1688d29 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java
@@ -10,7 +10,6 @@
 
 import org.springframework.stereotype.Component;
 
-import com.example.springboot.entity.Glass;
 import com.example.springboot.entity.Queue;
 import com.example.springboot.entity.north_glass_buffer1;
 @Component
@@ -96,10 +95,13 @@
 			// queue.setdatecreated(rs.getString("datecreated"));
 			// queue.setFrameBarcode(rs.getString("FrameBarcode"));
          }
-		//  conn.close();
+		 conn.close();
          return queue;
     }
 
+	
+
+	//鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅
 	public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid,String orderid,String frameid) throws SQLException {
         conn = getConn();
         // north_glass_buffer1 glass=new north_glass_buffer1();
@@ -132,11 +134,46 @@
 			glass.add(north_glass_buffer1s);
 			
          }
-		//  conn.close();
+		 conn.close();
          return glass;
     }
 
-	
+	//鏍规嵁閾濇id鏌ヨ瀹㈡埛鐜荤拑淇℃伅
+	public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIdss(String frameid) throws SQLException {
+        conn = getConn();
+        // north_glass_buffer1 glass=new north_glass_buffer1();
+		List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>();
+        String sql = "select * from north_glass_buffer1 where FrameBarcode=?";
+         ps = conn.prepareStatement(sql);
+		 ps.setString(1, frameid);
+         rs= ps.executeQuery();
+         while (rs.next()) {
+			north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
+
+			north_glass_buffer1s.setId(rs.getInt("Id"));
+			north_glass_buffer1s.setordernumber(rs.getString("ordernumber"));
+			north_glass_buffer1s.setlistnumber(rs.getString("listnumber"));
+			north_glass_buffer1s.setboxnumber(rs.getString("boxnumber"));
+			north_glass_buffer1s.setbarcode(rs.getString("barcode"));
+			north_glass_buffer1s.setglasslength(rs.getDouble("glasslength"));
+			north_glass_buffer1s.setglassheight(rs.getDouble("glassheight"));
+			north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm"));
+			north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm"));
+			north_glass_buffer1s.setitemtype(rs.getString("itemtype"));
+			north_glass_buffer1s.setslotnumber(rs.getString("slotnumber"));
+			north_glass_buffer1s.setdatemodified(rs.getString("datemodified"));
+			north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));
+			north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));
+
+
+			glass.add(north_glass_buffer1s);
+			
+         }
+		 conn.close();
+         return glass;
+    }
+
+	//鏍规嵁閾濇id鏌ヨl閾濇鏄惁缈昏浆
 	public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
 		conn = getConn();
         // north_glass_buffer1 glass=new north_glass_buffer1();
@@ -149,9 +186,56 @@
 			flip=rs.getString("Flip");
 			
          }
-		//  conn.close();
+		 conn.close();
          return flip;
 	}
+	//鏍规嵁閾濇id鏌ヨ鏄惁閾濇鎽嗘斁
+	public String SelectPositionByFrameBarcode(String frameBarcode) throws SQLException {
+       	conn = getConn();
+        // north_glass_buffer1 glass=new north_glass_buffer1();
+		String position="";
+        String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";
+         ps = conn.prepareStatement(sql1);
+		 ps.setString(1, frameBarcode);
+         rs= ps.executeQuery();
+         while (rs.next()) {
+			position=rs.getString("position");
+         }
+		 conn.close();
+         return position;
+    }
+
+	//鏍规嵁閾濇id鏌ヨ閾濇瀹�
+	public String SelectFrameLengthByFrameBarcode(String frameBarcode) throws SQLException {
+       	conn = getConn();
+        // north_glass_buffer1 glass=new north_glass_buffer1();
+		String position="";
+        String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";
+         ps = conn.prepareStatement(sql1);
+		 ps.setString(1, frameBarcode);
+         rs= ps.executeQuery();
+         while (rs.next()) {
+			position=rs.getString("framelength");
+         }
+		 conn.close();
+         return position;
+    }
+
+	//鏍规嵁閾濇id鏌ヨ閾濇楂�
+	public String SelectFrameHeightByFrameBarcode(String frameBarcode) throws SQLException {
+       	conn = getConn();
+        // north_glass_buffer1 glass=new north_glass_buffer1();
+		String position="";
+        String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";
+         ps = conn.prepareStatement(sql1);
+		 ps.setString(1, frameBarcode);
+         rs= ps.executeQuery();
+         while (rs.next()) {
+			position=rs.getString("frameheight");
+         }
+		 conn.close();
+         return position;
+    }
 	
 	/**
 	 * 1. 鍔犺浇椹卞姩
@@ -184,6 +268,8 @@
 		}
 	}
 
+    
+
 
 
 }

--
Gitblit v1.8.0