From 0417fafe757f09bfb166b1dd1d9f096e966a30d8 Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期六, 11 五月 2024 09:38:43 +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 | 34 +++++++++++++++++++++++++++++++++-
1 files changed, 33 insertions(+), 1 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..47ff2b3 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
@@ -435,7 +467,7 @@
try {
Connection conn = null;
// conn =
- // DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8",
+ // 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",
--
Gitblit v1.8.0