From 3e14a623345669722d42cae5914d4ade70fc5c9e Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期三, 27 三月 2024 15:12:01 +0800
Subject: [PATCH] V1.97 edit at date 2024-03-27 1.新增数据表 'web_site.tb_resset_station' CREATE TABLE `tb_resset_station` ( `num` int(11) NOT NULL AUTO_INCREMENT, `stationid` varchar(255) NOT NULL DEFAULT '0' COMMENT '机房id', `last_start_time` datetime NOT NULL DEFAULT '2024-01-01 00:00:00' COMMENT '上次启动时间', `time_interval` float NOT NULL DEFAULT '720' COMMENT '启动时间间隔', `enable` int(11) NOT NULL DEFAULT '1' COMMENT '是否生效:1生效', PRIMARY KEY (`num`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='机房内阻测试计划信息表';
---
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 7c6b14f..e3b08e3 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
@@ -102,6 +102,8 @@
createFbs9100_SetParam_Temp_Table(pool, recreate); //本年度二次核容放电参数
createFault_Upload_Application_Table(pool, recreate); //故障隐患上传表,用于故障隐患考核
+
+ createTb_Resset_Station_Table(pool, recreate); //创建内阻测试计划表
System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -178,6 +180,36 @@
}
}
+ /**
+ * 创建机房内阻测试计划信息表
+ * @param pool
+ * @param recreate
+ */
+ private static void createTb_Resset_Station_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Resset_Station_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Resset_Station_Table+ " (" +
+ " `num` int(11) NOT NULL AUTO_INCREMENT," +
+ " `stationid` varchar(255) NOT NULL DEFAULT '0' COMMENT '机房id'," +
+ " `last_start_time` datetime NOT NULL DEFAULT '2024-01-01 00:00:00' COMMENT '上次启动时间'," +
+ " `time_interval` float NOT NULL DEFAULT '720' COMMENT '启动时间间隔'," +
+ " `enable` int(11) NOT NULL DEFAULT '1' COMMENT '是否生效:1生效'," +
+ " PRIMARY KEY (`num`) USING BTREE" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机房内阻测试计划信息表';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+
+
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
private static void createTB_Map_Outline_Table(MysqlConnPool pool, boolean recreate) {
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Map_Outline_Table;
--
Gitblit v1.9.1