From a58b8b33bc5cf64f083d1e0a6d32a17d2749fcd1 Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期五, 23 二月 2024 11:24:28 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes
---
springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 54 insertions(+), 6 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 365deaa..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,7 +95,7 @@
// queue.setdatecreated(rs.getString("datecreated"));
// queue.setFrameBarcode(rs.getString("FrameBarcode"));
}
- // conn.close();
+ conn.close();
return queue;
}
@@ -135,7 +134,7 @@
glass.add(north_glass_buffer1s);
}
- // conn.close();
+ conn.close();
return glass;
}
@@ -170,11 +169,11 @@
glass.add(north_glass_buffer1s);
}
- // conn.close();
+ conn.close();
return glass;
}
- //鏍规嵁閾濇id鏌ヨ鏄惁缈昏浆
+ //鏍规嵁閾濇id鏌ヨl閾濇鏄惁缈昏浆
public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
conn = getConn();
// north_glass_buffer1 glass=new north_glass_buffer1();
@@ -187,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. 鍔犺浇椹卞姩
@@ -222,6 +268,8 @@
}
}
+
+
}
--
Gitblit v1.8.0