From 79f33da4df32fc139c3855a8ecca6545723e0815 Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期二, 19 九月 2023 08:08:17 +0800
Subject: [PATCH] 删除不需要的代码,玻璃信息放入其他数据库 方便测试显示数据库连接的信息

---
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java |   71 ++++++++++++++++++++++-------------
 1 files changed, 44 insertions(+), 27 deletions(-)

diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
index c6ce249..2ea5797 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
@@ -2,34 +2,36 @@
 
 import cn.hutool.json.JSONObject;
 
+import java.util.ArrayList;
 import java.util.List;
 
-import org.springframework.context.ConfigurableApplicationContext;
+import org.apache.ibatis.javassist.tools.framedump;
 
 import com.example.springboot.entity.StorageCage;
 import com.example.springboot.entity.alarmmg;
 import com.example.springboot.mapper.HomeMapper;
+import com.example.springboot.service.JdbcConnections;
 
 public class Plchome extends Thread {
 
     private HomeMapper homeMapper;
-
+    private JdbcConnections dbserve;
     @Override
     public void run() {
         while (this != null) {
             try {
-                Thread.sleep(10000);
+                Thread.sleep(1000);
             } catch (InterruptedException e) {
                 e.printStackTrace();
             }
-
             JSONObject jsonObject = new JSONObject();
-            
+
+            // 娉ㄥ叆mapper
             homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
             // 绗煎瓙浣跨敤鎯呭喌
             List<StorageCage> tableData = homeMapper.selectAll();
             jsonObject.append("tableData", tableData);
-            //鏍肩悊鐗囩鏍煎瓙鐘舵��
+            // 鏍肩悊鐗囩鏍煎瓙鐘舵��
             List<StorageCage> cagelist1 = homeMapper.selectRack1();
             List<StorageCage> cagelist2 = homeMapper.selectRack2();
             List<StorageCage> cagelist3 = homeMapper.selectRack3();
@@ -38,35 +40,50 @@
             jsonObject.append("cagelist2", cagelist2);
             jsonObject.append("cagelist3", cagelist3);
             jsonObject.append("cagelist4", cagelist4);
-            //杩涘嚭鐗囦换鍔�
-            List<StorageCage> tasklist1=homeMapper.selectinout(2);
-            List<StorageCage> tasklist2=homeMapper.selectinout(3);
+            // 杩涘嚭鐗囦换鍔�
+            List<StorageCage> tasklist1 = homeMapper.selectinout(2);
+            List<StorageCage> tasklist2 = homeMapper.selectinout(3);
             jsonObject.append("tasklist1", tasklist1);
             jsonObject.append("tasklist2", tasklist2);
-            //鏌ヨ鎶ヨ淇℃伅
-            List<alarmmg> alarmmg=homeMapper.SelectAlarmmgInfo();
+            // 鏌ヨ鎶ヨ淇℃伅
+            List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo();
             jsonObject.append("alarmmg", alarmmg);
-            //璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃�
-            // List<String> addressList = new ArrayList<>();
-            // addressList.add("DB100.DBW0");
-            // addressList.add("DB100.DBW2");
-            // List<Short> paramlist = S7control.getinstance().ReadWord(addressList);
-            // jsonObject.append("params", paramlist);
+            // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒
+            List<String> addressList = new ArrayList<String>();
+            addressList.add("DB106.12");
+            addressList.add("DB106.0");
+            List<Short> paramlist= S7control.getinstance().ReadWord(addressList);
 
-            jsonObject.append("params", new short[] { 30, 40, });
+            // List<Short> paramlists = new ArrayList<Short>();
+            // short para1 = 11111;
+            // short para2 = 32000;
+            // paramlists.add(para1);
+            // paramlists.add(para2);
+            // System.out.println(paramlists);
+
+            if(paramlist!=null){
+            jsonObject.append("params", paramlist);
+            }
+           List<Short> inglassInfo=  S7control.getinstance().ReadWord("DB106.24",1);
+           if(inglassInfo!=null){
+            if(inglassInfo.size()>0)
+            jsonObject.append("loadglassheight", inglassInfo.get(0)*70);
+            }
+               dbserve = WebSocketServer.applicationContext.getBean(JdbcConnections.class);
+               boolean dbconnected=false;
+               try {
+                dbserve.getConn();
+                 dbconnected=true;
+               } catch (Exception e) {
+                // TODO: handle exception
+                 dbconnected=false;
+               }
+            jsonObject.append("dbconnected",  dbconnected);
+            // jsonObject.append("params", new short[] { 30, 40, });
             WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");
-
             if (sendwServer != null) {
                 sendwServer.sendMessage(jsonObject.toString());
             }
-
-            // JSONObject jsonObject = new JSONObject();
-            // jsonObject.append("params", new short[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
-            // 11, });
-            // WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");
-            // if (sendwServer != null) {
-            // sendwServer.sendMessage(jsonObject.toString());
-            // }
 
         }
     }

--
Gitblit v1.8.0