理片笼测试修改

wu

2023-11-30 dc31792dc1b8ad1658e49ba8fce9a1be924e6fbb

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

@@ -11,6 +11,7 @@
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
public class JdbcConnections {
@@ -69,12 +70,41 @@
      //  conn.close();
         return north_glass_buffer1s;
    }
   //根据玻璃id，订单id，铝框id查询客户玻璃信息
   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  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 barcode=? or ordernumber=? or FrameBarcode=?";
        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);