From 541baafd2a19008fadb19c9f621fed43907501e9 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq,com>
Date: 星期四, 27 八月 2020 15:40:05 +0800
Subject: [PATCH] 负载修改
---
src/com/data/PowerArk_Task_SQL.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/src/com/data/PowerArk_Task_SQL.java b/src/com/data/PowerArk_Task_SQL.java
index bd514a7..421a7e3 100644
--- a/src/com/data/PowerArk_Task_SQL.java
+++ b/src/com/data/PowerArk_Task_SQL.java
@@ -27,6 +27,8 @@
createTb_Dynamicload_inf(pool);
+ initTb_Dynamicload_inf(pool);
+
createTb_Dynamicload_Button_Rt(pool);
createTb_Dynamicload_State_rt(pool);
@@ -62,7 +64,7 @@
" dev_ip varchar(126) NOT NULL DEFAULT '' COMMENT '设备ip'," +
" note varchar(255) NOT NULL DEFAULT ''," +
" PRIMARY KEY (num)," +
- " KEY dev_id_key (dev_id)" +
+ " UNIQUE KEY dev_id_key (dev_id)" +
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
try {
@@ -74,6 +76,22 @@
}
}
/**
+ * 初始化负载信息表
+ * @param pool
+ */
+ public static void initTb_Dynamicload_inf(MysqlConnPool pool) {
+ String sql_str= " replace INTO " + Sql_Mysql.Tb_Dynamicload_inf + "(dev_id,dev_name,dev_type,FZ_button_num,dev_ip) VALUES(1001,1,1,10,'127.0.0.1'),(1002,2,1,11,'127.0.0.1'),(1003,3,1,10,'127.0.0.1'),(1004,4,1,10,'127.0.0.1')";
+
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+ /**
* 创建按钮实时信息
* @param pool
*/
--
Gitblit v1.9.1