新增数据库连接文件，逻辑优化

wu

2023-09-12 67b0ccf9e6a77767bd5b0823bc80bee474f49f9b

 springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java

@@ -1,38 +1,82 @@
package com.example.springboot.component;

import java.sql.SQLException;
import java.util.List;

import javax.websocket.Session;
import org.springframework.beans.factory.annotation.Autowired;

import com.example.springboot.service.JdbcConnections;
import com.example.springboot.service.SpianService;
import com.example.springboot.entity.Glass;
import com.example.springboot.mapper.AlarmMapper;

import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;

public class PlcHold extends Thread {

  private AlarmMapper alarmMapper;

  @Autowired
  private JdbcConnections jdbcConnections;

  private SpianService spianService;


  @Override
  public void run() {
    
    while (this != null) {
      try {

        Thread.sleep(500);
      } catch (InterruptedException e) {
        // TODO Auto-generated catch block
        //\\ TODO Auto-generated catch block
        e.printStackTrace();
      }
      List<Boolean> bitlist = S7control.getinstance().ReadBits("DB2.0.0", 100);

      List<Short> paramlist = S7control.getinstance().ReadWord("DB100.6", 1);
      spianService = WebSocketServer.applicationContext.getBean(SpianService.class);
      
      //判断进片请求 
      List<Short> datas1List=S7control.getinstance().ReadWord("DB106.24", 1);
      jdbcConnections = WebSocketServer.applicationContext.getBean(JdbcConnections.class);
      try {
          Glass glass=jdbcConnections.selectGlass(112);
          //System.out.println(glass.getOrderId());
        } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
    
      //判断进片请求 
       List<Short> datas1List=S7control.getinstance().ReadWord("DB106.24", 1);
       List<Short> datas1ListState=S7control.getinstance().ReadWord("DB106.8", 1);
      if(datas1List!=null &&datas1ListState!=null){
          //获取prc进片请求数据
       boolean exist = datas1List.contains((short)1); 
       //获取进片车状态
       boolean exist1 = datas1ListState.contains((short)0); 
      //进片请求为1时
       if(exist=true){
        //当进片车空闲时
        if(exist1=true){
        //获取进片id
        List<Short> datas1ListID=S7control.getinstance().ReadWord("DB106.26", 13);
        //获取玻璃id    
        for(Short list1:datas1ListID){

            spianService.selectAll((short)list1);
        }
      }

     
        
        
        //System.out.println(exist);
      }
    }
            
          

      
      // 查询数据库
      // 推送到前端

    }
  }
  
}