修改电气管理PLC通讯逻辑

wuyouming666

2023-11-30 8dfb37b10ffb2fcb41c85b3fa266d1ef2874aebc

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

@@ -5,10 +5,13 @@
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.stereotype.Component;

import com.example.springboot.entity.Glass;
import com.example.springboot.entity.north_glass_buffer1;
@Component
public class JdbcConnections {
    /**
@@ -24,19 +27,85 @@
   private static PreparedStatement ps = null;
   private static ResultSet rs = null;
   
   public  Glass selectGlass(int glassid) throws SQLException {
   public  north_glass_buffer1 selectGlass(int glassid) throws SQLException {
        conn = getConn();
        Glass glass=new Glass();
        String sql = "select orderid from glass where glassid=?";
        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.setOrderId(rs.getString("orderid"));
         glass.setordernumber(rs.getString("ordernumber"));
         }
       conn.close();
         return glass;
    }

   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;
    }

   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=?";
         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;
    }
	
   /**
    * 1. 加载驱动
    * 2. 获取连接   conn