From 482923b92a1657ba4b3610a33d11f3f364a18812 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期六, 01 八月 2020 13:52:59 +0800
Subject: [PATCH] 创建设备重启计划表
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 59e01d0..42dc5aa 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -54,6 +54,7 @@
createBattReplace_Table(pool,recreate); //创建机房电池组更换记录表
+ createDev_Restart_PlanTable(pool,recreate); //创建设备重启计划表
}
@@ -1048,6 +1049,37 @@
}
/**
+ *
+ * @param pool
+ * @param recreate
+ */
+ public static void createDev_Restart_PlanTable(MysqlConnPool pool, boolean recreate) {
+ String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_Restart_Plan_Table;
+ String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_Restart_Plan_Table + " (" +
+ " num bigint(20) NOT NULL," +
+ " dev_id int(11) NOT NULL DEFAULT '0' COMMENT '设备id'," +
+ " restart_starttime datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '重启开始时间'," +
+ " restart_cycle int(11) NOT NULL DEFAULT '1' COMMENT '重启周期'," +
+ " restart_en int(11) NOT NULL DEFAULT '0' COMMENT '重启使能 0:不启用 ；1:启用'," +
+ " note varchar(255) NOT NULL DEFAULT '' COMMENT '备用'," +
+ " PRIMARY KEY (`num`)," +
+ " UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(recreate) {
+ sql.sqlMysqlExecute(sql_str_del);
+ }
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+
+ /**
* 设置指定的线程重启[ 告警线程; ]
*/
public static void setUpThreadRestart(MysqlConnPool conn_pool) {
--
Gitblit v1.9.1