From c541e23b13fbd0c9a22ef325f2f9aff56329ff25 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期一, 06 五月 2024 08:19:33 +0800
Subject: [PATCH] 修改数据库连接
---
springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java | 183 ++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 160 insertions(+), 23 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..01bc770 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
@@ -19,22 +18,22 @@
* 鏁版嵁搴撹繛鎺ュ弬鏁�
* driver,url,username,password
*/
- private static final String DRIVER = "com.mysql.jdbc.Driver";
+ private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/canadames";
private static final String USERNAME = "root";
private static final String PASSWORD = "beibo.123/";
- private static Connection conn = null;
+ private static Connection conns = null;
private static PreparedStatement ps = null;
- private static ResultSet rs = null;
+ private static ResultSet rss = null;
public north_glass_buffer1 selectGlass(int glassid) throws SQLException {
- conn = getConn();
+ Connection conn = getConn();
north_glass_buffer1 glass=new north_glass_buffer1();
String sql = "select ordernumber from north_glass_buffer1 where glassid=?";
ps = conn.prepareStatement(sql);
ps.setInt(1, glassid);
- rs= ps.executeQuery();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
glass.setordernumber(rs.getString("ordernumber"));
}
@@ -43,14 +42,14 @@
}
public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid,String orderid,String frameid) throws SQLException {
- conn = getConn();
+ Connection conn = getConn();
north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
ps = conn.prepareStatement(sql);
ps.setString(1, glassid);
ps.setString(2, orderid);
ps.setString(3, frameid);
- rs= ps.executeQuery();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
north_glass_buffer1s.setId(rs.getInt("Id"));
north_glass_buffer1s.setordernumber(rs.getString("ordernumber"));
@@ -67,19 +66,107 @@
north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));
north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));
}
- // conn.close();
+ conn.close();
return north_glass_buffer1s;
}
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdout(String glassid,String orderid,String frameid) throws SQLException {
+ Connection conn = getConn();
+ north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
+ String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
+ ps = conn.prepareStatement(sql);
+ ps.setString(1, glassid);
+ ps.setString(2, orderid);
+ ps.setString(3, frameid);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ 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"));
+ }
+ conn.close();
+ return north_glass_buffer1s;
+ }
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdouts(String glassid,String orderid,String frameid) throws SQLException {
+ Connection conn = getConn();
+ north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
+ String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
+ ps = conn.prepareStatement(sql);
+ ps.setString(1, glassid);
+ ps.setString(2, orderid);
+ ps.setString(3, frameid);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ 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"));
+ }
+ conn.close();
+ return north_glass_buffer1s;
+ }
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdplchold(String glassid,String orderid,String frameid) throws SQLException {
+ Connection conn = getConn();
+ north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
+ String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
+ ps = conn.prepareStatement(sql);
+ ps.setString(1, glassid);
+ ps.setString(2, orderid);
+ ps.setString(3, frameid);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ 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"));
+ }
+ conn.close();
+ return north_glass_buffer1s;
+ }
+
//鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅
public Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid,String orderid,String frameid) throws SQLException {
- conn = getConn();
+ Connection conn = getConn();
Queue queue=new Queue();
String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";
ps = conn.prepareStatement(sql);
ps.setString(1, glassid);
ps.setString(2, orderid);
ps.setString(3, frameid);
- rs= ps.executeQuery();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
queue.setid(rs.getInt("Id"));
queue.setorderId(rs.getString("ordernumber"));
@@ -96,7 +183,7 @@
// queue.setdatecreated(rs.getString("datecreated"));
// queue.setFrameBarcode(rs.getString("FrameBarcode"));
}
- // conn.close();
+ conn.close();
return queue;
}
@@ -104,7 +191,7 @@
//鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅
public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid,String orderid,String frameid) throws SQLException {
- conn = getConn();
+ Connection 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 position(? in barcode) and position(? in ordernumber) and position(? in FrameBarcode)";
@@ -112,7 +199,7 @@
ps.setString(1, glassid);
ps.setString(2, orderid);
ps.setString(3, frameid);
- rs= ps.executeQuery();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
@@ -135,19 +222,19 @@
glass.add(north_glass_buffer1s);
}
- // conn.close();
+ conn.close();
return glass;
}
//鏍规嵁閾濇id鏌ヨ瀹㈡埛鐜荤拑淇℃伅
public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIdss(String frameid) throws SQLException {
- conn = getConn();
+ Connection 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();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();
@@ -170,26 +257,73 @@
glass.add(north_glass_buffer1s);
}
- // conn.close();
+ conn.close();
return glass;
}
- //鏍规嵁閾濇id鏌ヨ鏄惁缈昏浆
+ //鏍规嵁閾濇id鏌ヨl閾濇鏄惁缈昏浆
public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
- conn = getConn();
+ Connection conn = getConn();
// north_glass_buffer1 glass=new north_glass_buffer1();
String flip="";
String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";
ps = conn.prepareStatement(sql1);
ps.setString(1, frameBarcode);
- rs= ps.executeQuery();
+ ResultSet rs= ps.executeQuery();
while (rs.next()) {
flip=rs.getString("Flip");
}
- // conn.close();
+ conn.close();
return flip;
}
+ //鏍规嵁閾濇id鏌ヨ鏄惁閾濇鎽嗘斁
+ public String SelectPositionByFrameBarcode(String frameBarcode) throws SQLException {
+ Connection 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);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ position=rs.getString("flip");
+ }
+ conn.close();
+ return position;
+ }
+
+ //鏍规嵁閾濇id鏌ヨ閾濇瀹�
+ public String SelectFrameLengthByFrameBarcode(String frameBarcode) throws SQLException {
+ Connection 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);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ position=rs.getString("framelength");
+ }
+ conn.close();
+ return position;
+ }
+
+ //鏍规嵁閾濇id鏌ヨ閾濇楂�
+ public String SelectFrameHeightByFrameBarcode(String frameBarcode) throws SQLException {
+ Connection 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);
+ ResultSet rs= ps.executeQuery();
+ while (rs.next()) {
+ position=rs.getString("frameheight");
+ }
+ conn.close();
+ return position;
+ }
/**
* 1. 鍔犺浇椹卞姩
@@ -210,7 +344,8 @@
*/
public static Connection getConn() throws SQLException {
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://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");
return conn;
}
@@ -222,6 +357,8 @@
}
}
+
+
}
--
Gitblit v1.8.0