更新主界面功能

ZengTao

2023-12-04 0258088b4e7751431080a1b47e7bc2af18031bbf

 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
@@ -174,7 +173,7 @@
         return glass;
    }

   //根据铝框id查询是否翻转
   //根据铝框id查询l铝框是否翻转
   public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {
      conn = getConn();
        // north_glass_buffer1 glass=new north_glass_buffer1();
@@ -189,6 +188,21 @@
         }
      //  conn.close();
         return flip;
   }
   //根据铝框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;
   }
   
   /**
@@ -224,4 +238,6 @@





}