From e808f9e89ad6bd5d252e1aad42daa676b481b0ca Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期五, 10 五月 2024 15:59:02 +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 | 44 ++++++++++++++++++++++++++++++++++++++------
1 files changed, 38 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 4da549e..1d984a4 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
@@ -11,7 +11,9 @@
import org.springframework.stereotype.Component;
import com.example.springboot.entity.Queue;
+import com.example.springboot.entity.north_frame_buffer1_frames;
import com.example.springboot.entity.north_glass_buffer1;
+import com.example.springboot.service.North_Glass_Buffer1Service.north_glass_buffer1Comparator;
@Component
public class JdbcConnections {
@@ -414,6 +416,36 @@
}
+ // 鏍规嵁閾濇id鏌ヨ閾濇淇℃伅
+ public north_frame_buffer1_frames SelectFrameBarcode(String frameBarcode) throws SQLException {
+ try {
+ Connection conn = getConn();
+ north_frame_buffer1_frames frame=new north_frame_buffer1_frames();
+ String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";
+ ps = conn.prepareStatement(sql1);
+ ps.setString(1, frameBarcode);
+ ResultSet rs = ps.executeQuery();
+ while (rs.next()) {
+ frame.setId(rs.getInt("id"));
+ frame.setlistnumber(rs.getString("listnumber"));
+ frame.setordernumber(rs.getString("ordernumber"));
+ frame.setboxnumber(rs.getString("boxnumber"));
+ frame.setbarcode(rs.getString("barcode"));
+ frame.setframelength(rs.getDouble("framelength"));
+ frame.setframeheight(rs.getDouble("frameheight"));
+ frame.setframelengthmm(rs.getDouble("framelength_mm"));
+ frame.setframeheightmm(rs.getDouble("frameheight_mm"));
+ frame.setflip(rs.getInt("flip"));
+ }
+ conn.close();
+ return frame;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+ }
+
/**
* 1. 鍔犺浇椹卞姩
* 2. 鑾峰彇杩炴帴 conn
@@ -434,12 +466,12 @@
public static Connection getConn() throws SQLException {
try {
Connection conn = null;
- // conn =
- // DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8",
- // "root", "beibo.123/");
- conn = DriverManager.getConnection(
- "jdbc:mysql://192.168.102.9:3306/production?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false",
- "northglass", "n0rthgla55");
+ conn =
+ DriverManager.getConnection("jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&characterEncoding=utf-8",
+ "root", "beibo.123/");
+ // conn = DriverManager.getConnection(
+ // "jdbc:mysql://192.168.102.9:3306/production?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false",
+ // "northglass", "n0rthgla55");
return conn;
} catch (Exception e) {
// TODO: handle exception
--
Gitblit v1.8.0