主界面添加玻璃id，设备状态等显示

ZengTao

2024-01-16 def4c65d0ed71a48374c8614fcc74820ce2b6d84

 springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java

@@ -95,7 +95,7 @@
         // queue.setdatecreated(rs.getString("datecreated"));
         // queue.setFrameBarcode(rs.getString("FrameBarcode"));
         }
      //  conn.close();
       conn.close();
         return queue;
    }

@@ -134,7 +134,7 @@
         glass.add(north_glass_buffer1s);
         
         }
      //  conn.close();
       conn.close();
         return glass;
    }

@@ -169,7 +169,7 @@
         glass.add(north_glass_buffer1s);
         
         }
      //  conn.close();
       conn.close();
         return glass;
    }

@@ -186,7 +186,7 @@
         flip=rs.getString("Flip");
         
         }
      //  conn.close();
       conn.close();
         return flip;
   }
   //根据铝框id查询是否铝框摆放
@@ -201,7 +201,39 @@
         while (rs.next()) {
         position=rs.getString("position");
         }
      //  conn.close();
       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;
    }