BattMonitor_DB_Builder/bin/com/database_util/DB_Alarm.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/SqlsUtils.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,6 +1,11 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.77 edit at date 2023-06-09 1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table + " CHANGE alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';"); V1.76 edit at date 2023-05-31 1.修复'db_user.tb_user_log'表新增2列无法添加,运行时默认删除30天之前的操作日志 2.表 'db_batt_testdata.tb_batttestdata_inf'新增字段 BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -419,13 +419,13 @@ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Alarm_Relation_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Alarm_Relation_Table + " (" + " `id` bigint(19) NOT NULL AUTO_INCREMENT," + " `alm_id` varchar(15) DEFAULT NULL COMMENT '告警id'," + " `alm_name` varchar(15) DEFAULT NULL COMMENT '告警名称'," + " `alm_id` varchar(255) DEFAULT NULL COMMENT '告警id'," + " `alm_name` varchar(255) DEFAULT NULL COMMENT '告警名称'," + " `alm_type` int(5) NOT NULL DEFAULT '0' COMMENT '告警来源：0电源，1设备，2电池'," + " `alm_ponit` varchar(15) DEFAULT '' COMMENT '告警点'," + " `alm_point` varchar(255) DEFAULT '' COMMENT '告警点'," + " `highorlow` int(5) DEFAULT '0' COMMENT '高低告警0默认1低2高'," + " PRIMARY KEY (`id`)" + ") ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='告警对应关系';"; ") ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COMMENT='告警对应关系';"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); ResultSet res = null; try { @@ -434,9 +434,28 @@ } sql.sqlMysqlExecute(sql_str02); //添加指定的highorlow列 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_alarm'" + " AND table_name='tb_alarm_relation'" + " AND column_name='alm_ponit'"); if(res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table + " CHANGE alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';"); } } catch (SQLException e) { e.printStackTrace(); } finally { if(null != res) { try { res.close(); } catch (SQLException e) { e.printStackTrace(); } } sql.close_con(); } } BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -468,7 +468,7 @@ System.out.println("insert id = "+SqlsUtils.sqlstb_page_param.get(i)); } } System.out.println("db_app_sys.tb_page_param ids:"+ids); //System.out.println("db_app_sys.tb_page_param ids:"+ids); }else{ StringBuffer sql_str_bf = new StringBuffer("INSERT INTO " + Sql_Mysql.Page_Param_Table + " (`id`, `param`, `status`, `categoryId`,`paramEnUs`) VALUES"); BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
@@ -38,6 +38,13 @@ * db_app_sys.tb_menu的默认insert语句 */ static ArrayList<String> sqlstb_tb_menu; /** * db_app_sys.tb_alarm_relation 的默认insert语句 */ static ArrayList<String> sqlstb_tb_alarm_relation; static {
@@ -1,6 +1,11 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.77 edit at date 2023-06-09 1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table + " CHANGE alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';"); V1.76 edit at date 2023-05-31 1.修复'db_user.tb_user_log'表新增2列无法添加,运行时默认删除30天之前的操作日志 2.表 'db_batt_testdata.tb_batttestdata_inf'新增字段 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.76; public final static float m_VersionNum = (float) 1.77; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
