From 7dfc5501decb84bce7fe0563956eae705844a2f2 Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期五, 17 五月 2024 08:52:52 +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 | 639 ++++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 444 insertions(+), 195 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 6ebdcc0..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,221 +11,474 @@
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 {
- /**
+ /**
* 鏁版嵁搴撹繛鎺ュ弬鏁�
* 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;
-
- public north_glass_buffer1 selectGlass(int glassid) throws SQLException {
- 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();
- while (rs.next()) {
- glass.setordernumber(rs.getString("ordernumber"));
- }
- conn.close();
- return glass;
- }
+ private static ResultSet rss = null;
- public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid,String orderid,String frameid) throws SQLException {
- 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();
- 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();
- 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();
- while (rs.next()) {
- queue.setid(rs.getInt("Id"));
- queue.setorderId(rs.getString("ordernumber"));
- queue.setlistId(rs.getString("listnumber"));
- queue.setboxId(rs.getString("boxnumber"));
- queue.setglassId(rs.getString("barcode"));
- queue.setglasswidthmm(rs.getDouble("glasslength"));
- queue.setglassheightmm(rs.getDouble("glassheight"));
- queue.setglasswidth(rs.getDouble("glasslength_mm"));
- queue.setglassheight(rs.getDouble("glassheight_mm"));
- // queue.setitemtype(rs.getString("itemtype"));
- // queue.setslotnumber(rs.getString("slotnumber"));
- // queue.setdatemodified(rs.getString("datemodified"));
- // queue.setdatecreated(rs.getString("datecreated"));
- // queue.setFrameBarcode(rs.getString("FrameBarcode"));
- }
- // conn.close();
- return queue;
- }
+ public north_glass_buffer1 selectGlass(int glassid) throws SQLException {
+ try {
+ 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);
+ ResultSet rs = ps.executeQuery();
+ while (rs.next()) {
+ glass.setordernumber(rs.getString("ordernumber"));
+ }
+ conn.close();
+ return glass;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
-
-
- //鏍规嵁鐜荤拑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();
- 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)";
- ps = conn.prepareStatement(sql);
- ps.setString(1, glassid);
- ps.setString(2, orderid);
- ps.setString(3, 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鏌ヨ瀹㈡埛鐜荤拑淇℃伅
- 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();
- 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();
- while (rs.next()) {
- flip=rs.getString("Flip");
-
- }
- // conn.close();
- return flip;
}
- //鏍规嵁閾濇id鏌ヨ鏄惁閾濇鎽嗘斁
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid, String orderid, String frameid)
+ throws SQLException {
+
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdout(String glassid, String orderid, String frameid)
+ throws SQLException {
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdouts(String glassid, String orderid, String frameid)
+ throws SQLException {
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ public north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameIdplchold(String glassid, String orderid, String frameid)
+ throws SQLException {
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅
+ public Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid, String orderid, String frameid)
+ throws SQLException {
+ try {
+ 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);
+ ResultSet rs = ps.executeQuery();
+ while (rs.next()) {
+ queue.setid(rs.getInt("Id"));
+ queue.setorderId(rs.getString("ordernumber"));
+ queue.setlistId(rs.getString("listnumber"));
+ queue.setboxId(rs.getString("boxnumber"));
+ queue.setglassId(rs.getString("barcode"));
+ queue.setglasswidthmm(rs.getDouble("glasslength"));
+ queue.setglassheightmm(rs.getDouble("glassheight"));
+ queue.setglasswidth(rs.getDouble("glasslength_mm"));
+ queue.setglassheight(rs.getDouble("glassheight_mm"));
+ // queue.setitemtype(rs.getString("itemtype"));
+ // queue.setslotnumber(rs.getString("slotnumber"));
+ // queue.setdatemodified(rs.getString("datemodified"));
+ // queue.setdatecreated(rs.getString("datecreated"));
+ // queue.setFrameBarcode(rs.getString("FrameBarcode"));
+ }
+ conn.close();
+ return queue;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁鐜荤拑id锛岃鍗昳d锛岄摑妗唅d鏌ヨ瀹㈡埛鐜荤拑淇℃伅
+ public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid, String orderid, String frameid)
+ throws SQLException {
+ try {
+ 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)";
+ 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_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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇id鏌ヨ瀹㈡埛鐜荤拑淇℃伅
+ public List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIdss(String frameid) throws SQLException {
+ try {
+ 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);
+ ResultSet 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇id鏌ヨl閾濇鏄惁缈昏浆
+ public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
+ try {
+ 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);
+ ResultSet rs = ps.executeQuery();
+ while (rs.next()) {
+ flip = rs.getString("Flip");
+
+ }
+ conn.close();
+ return flip;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇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;
- }
-
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇id鏌ヨ閾濇瀹�
+ public String SelectFrameLengthByFrameBarcode(String frameBarcode) throws SQLException {
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇id鏌ヨ閾濇楂�
+ public String SelectFrameHeightByFrameBarcode(String frameBarcode) throws SQLException {
+ try {
+ 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;
+ } catch (Exception e) {
+ // TODO: handle exception
+ e.printStackTrace();
+ return null;
+ }
+
+ }
+
+ // 鏍规嵁閾濇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
+ * 2. 鑾峰彇杩炴帴 conn
* 3. 鍒涘缓璇彞 ps
* 4. 鎵ц璇彞 rs
* 5. 澶勭悊缁撴灉
* 6. 鍥炴敹璧勬簮
*
* 瀹炵幇CRUD
- * 鏇存柊锛�
- * 1澧炲姞
- * 2鍒犻櫎
- * 3淇敼
- * 鏌ヨ锛�
- * 1. 鏌ヤ竴涓紝涓�涓璞�
- * 2. 鏌ヤ竴缁勶紝鍋氭垚涓�涓璞″垪琛紝鏌ュ叏閮�
+ * 鏇存柊锛�
+ * 1澧炲姞
+ * 2鍒犻櫎
+ * 3淇敼
+ * 鏌ヨ锛�
+ * 1. 鏌ヤ竴涓紝涓�涓璞�
+ * 2. 鏌ヤ竴缁勶紝鍋氭垚涓�涓璞″垪琛紝鏌ュ叏閮�
*/
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/");
- return conn;
+ try {
+ Connection conn = null;
+ // 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
+ e.printStackTrace();
+ return null;
+ }
+
}
static {
@@ -235,9 +488,5 @@
e.printStackTrace();
}
}
-
-
-
-
}
--
Gitblit v1.8.0