BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Data_History_GW.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Inf.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -10,6 +10,10 @@ 1.新增动环相关配置库表 db_circle.tb_circle_inf db_circle.tb_sub_inf 2.表'db_pwrdev_inf.tb_pwrdev_inf' 新增字段 `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新] 3.数据库'db_pwrdev_data_history_gw'中所有的数据表新增字段用于国网的负载电流实时记录 `load_curr` float NOT NULL DEFAULT '0' COMMENT '负载电流', V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_History_GW.java
@@ -1,5 +1,6 @@ package com.database_util; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Date; @@ -14,10 +15,60 @@ createDB_Pwrdev_Data_History_GW(pool); repairHistoryTableColumn(pool); System.out.println(" db_pwrdev_data_history_gw init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } private static void repairHistoryTableColumn(MysqlConnPool pool) { String sql_str_sel = "SELECT TABLE_NAME as tname FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'db_pwrdev_data_history_gw'"; ResultSet res = null; ResultSet res1 = null; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { System.out.println(sql_str_sel); res = sql.sqlMysqlTotalQuery(sql_str_sel); while(res.next()) { String tname = res.getString("tname"); //System.err.println(tname); if(tname.contains("tb_pwrdev_historydata_gw_")) { //添加acIn1_currB try { res1 = null; res1 = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_data_history_gw'" + " AND table_name='" + tname + "'" + " AND column_name='load_curr'"); if(false == res1.next()) { System.out.println("'" + tname + "' 添加负载电流 'load_curr'"); sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.DB_PWRDEV_DATA_HISTORY_GW + "." + tname + " ADD COLUMN `load_curr` float NOT NULL DEFAULT '0' COMMENT '负载电流';"); } } catch (Exception e) { e.printStackTrace(); } finally { if(null != res1) { res1.close(); } } } } } catch (SQLException e) { e.printStackTrace(); } finally { try { if(null != res) { res.close(); } } catch (SQLException e) { e.printStackTrace(); } sql.close_con(); } } /** * 创建 db_pwrdev_data_history_gw 数据库 * @param pool @@ -33,4 +84,10 @@ sql.close_con(); } } public static void main(String[] args) { MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 100); repairHistoryTableColumn(pool); } } BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -89,6 +89,7 @@ " `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]'," + " `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]'," + " `swtich_num` int(32) NOT NULL DEFAULT '65535' COMMENT '开关路数'," + " `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]'," + " PRIMARY KEY (`num`)," + " KEY `index_station_id` (`StationId`)," + " KEY `index_powerdev_id` (`PowerDeviceId`)," + @@ -246,6 +247,17 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `swtich_num` int(32) NOT NULL DEFAULT '4095' COMMENT '开关路数';"); } res = null; //添加字段update_load_curr_en ----- 是否更新核容的负载电流[0-不更新 1-更新] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrdev_inf'" + " AND column_name='update_load_curr_en'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table + " ADD COLUMN `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]';"); } } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -1303,7 +1303,7 @@ public void sqlMysqlTotalExecute(String sql_str) throws SQLException { Statement sql = mysql_con.createStatement(); sql.setQueryTimeout(5*60); sql.setQueryTimeout(10*60); sql.execute(sql_str); } @@ -1365,7 +1365,7 @@ try { Statement sql = mysql_con.createStatement(); sql.setQueryTimeout(5*60); sql.setQueryTimeout(10*60); String query = sql_str; res = sql.executeQuery(query); } BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -10,6 +10,10 @@ 1.新增动环相关配置库表 db_circle.tb_circle_inf db_circle.tb_sub_inf 2.表'db_pwrdev_inf.tb_pwrdev_inf' 新增字段 `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新] 3.数据库'db_pwrdev_data_history_gw'中所有的数据表新增字段用于国网的负载电流实时记录 `load_curr` float NOT NULL DEFAULT '0' COMMENT '负载电流', V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效
