Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

wu

2023-11-30 0ece3ba8c92df0438af52b8de6b9225d8ada4103

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

@@ -136,6 +136,23 @@
         return glass;
    }
   
	
   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;
   }
	
   /**
    * 1. 加载驱动
    * 2. 获取连接   conn
@@ -168,4 +185,5 @@
   }



}