BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Inf.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,6 +1,12 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.90 edit at date 2023-10-31 1.表'db_pwrdev_inf.tb_pwrdev_inf'新增南网电源实时界面标签配置字段 `is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含交流配电柜[1-包含，0-不包含]', `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]', `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]', V1.89 edit at date 2023-10-24 1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000) 2.'db_user.tb_user_inf'表修改'upassword'长度 varchar(200)->varchar(1000) BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -187,6 +187,50 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `model` varchar(45) DEFAULT NULL COMMENT '型号' AFTER `DeviceName`;"); } res = null; //添加字段is_ac_cabinet ----- 是否包含交流配电柜 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrdev_inf'" + " AND column_name='is_ac_cabinet'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含交流配电柜[1-包含，0-不包含]';"); } res = null; //添加字段is_ac_cabinet ----- 是否包含交流配电柜 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrdev_inf'" + " AND column_name='is_ac_cabinet'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含交流配电柜[1-包含，0-不包含]';"); } res = null; //添加字段is_dc_cabinet ----- 是否包含直流配电柜 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrdev_inf'" + " AND column_name='is_dc_cabinet'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]';"); } res = null; //添加字段is_highfreq_cabinet ----- 是否包含高频配电柜 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrdev_inf'" + " AND column_name='is_highfreq_cabinet'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]';"); } } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,6 +1,12 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.90 edit at date 2023-10-31 1.表'db_pwrdev_inf.tb_pwrdev_inf'新增南网电源实时界面标签配置字段 `is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含交流配电柜[1-包含，0-不包含]', `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]', `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]', V1.89 edit at date 2023-10-24 1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000) 2.'db_user.tb_user_inf'表修改'upassword'长度 varchar(200)->varchar(1000) BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -32,7 +32,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.89; public final static float m_VersionNum = (float) 1.90; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
