| BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -110,6 +110,50 @@ * db_ram_db.tb_ess3100_pcs_state */ createTb_ess3100_pcs_state(pool, recreate); //创建山西储能设备实时信息表 createTB_Batt_Gtstate_Table(pool,recreate); } /** * 创建山西储能设备实时状态表 * @param pool * @param recreate */ private static void createTB_Batt_Gtstate_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Batt_Gtstate_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Batt_Gtstate_Table + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + " `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT '电池组ID'," + " `record_timed` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '记录时间'," + " `battState` int(11) NOT NULL DEFAULT '0' COMMENT '电池状态[1充电；2放电；3开路；4故障]'," + " `sumVol` float NOT NULL DEFAULT '0' COMMENT '总电压'," + " `battCurr` float NOT NULL DEFAULT '0' COMMENT '电池组电流'," + " `battSoc` int(11) NOT NULL DEFAULT '0' COMMENT '电池组Soc'," + " `battSoh` int(11) NOT NULL DEFAULT '0' COMMENT '电池组Soh'," + " `maxCharCurr` float NOT NULL DEFAULT '0' COMMENT '最大充电电流'," + " `maxDiscCurr` float NOT NULL DEFAULT '0' COMMENT '最大放电电流'," + " `diState` int(11) NOT NULL DEFAULT '0' COMMENT 'DI״̬'," + " `doState` int(11) NOT NULL DEFAULT '0' COMMENT 'DO״̬'," + " `battAlm0` int(11) NOT NULL DEFAULT '0' COMMENT '电池组告警'," + " `battAlm1` int(11) NOT NULL DEFAULT '0' COMMENT '电池组告警1'," + " `battfault0` int(11) NOT NULL DEFAULT '0' COMMENT '电池组故障0'," + " `battfault1` int(11) NOT NULL DEFAULT '0' COMMENT '电池组故障1'," + " PRIMARY KEY (`num`)," + " UNIQUE KEY `index_battgroupid` (`BattGroupId`) USING BTREE" + ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); ResultSet res = null; 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_ess3100_pcs_state(MysqlConnPool pool, boolean recreate) { BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -68,26 +68,28 @@ createTb_Weather_City2_Table(pool, recreate); //创建消峰填谷计划统计表 createTB_3D_STATION_Table(pool, recreate); createTB_3D_STATION_Table(pool, recreate); //创建3D机房信息表 } private static void createTB_3D_STATION_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_3D_STATION_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_3D_STATION_Table + " (" + " `id` int(11) NOT NULL AUTO_INCREMENT," + " `deviceId` int(11) DEFAULT NULL," + " `battGroupId` int(11) DEFAULT NULL," + " `stationName` varchar(255) DEFAULT NULL," + " `battGroupName` varchar(255) DEFAULT NULL," + " `pictureName` varchar(255) DEFAULT NULL," + " `pictureUrl` varchar(255) DEFAULT NULL," + " `positionX` double DEFAULT NULL," + " `positionY` double DEFAULT NULL," + " `length` double DEFAULT NULL," + " `width` double DEFAULT NULL," + " PRIMARY KEY (`id`) USING BTREE" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"; " `deviceId` int(11) DEFAULT NULL," + " `battGroupId` int(11) DEFAULT NULL," + " `stationName` varchar(255) DEFAULT NULL," + " `battGroupName` varchar(255) DEFAULT NULL," + " `pictureName` varchar(255) DEFAULT NULL," + " `pictureUrl` varchar(255) DEFAULT NULL," + " `positionX` double DEFAULT NULL," + " `positionY` double DEFAULT NULL," + " `length` double DEFAULT NULL," + " `width` double DEFAULT NULL," + " PRIMARY KEY (`id`) USING BTREE" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); ResultSet res = null; try { @@ -104,7 +106,7 @@ res = sql.sqlMysqlQuery(sql_str03); if(false == res.next()) { sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.TB_3D_STATION_Table + " ADD COLUMN `stationName` varchar(255) DEFAULT NULL;"); + " ADD COLUMN `stationName` varchar(255) DEFAULT NULL;"); } //添加battGroupName @@ -131,6 +133,13 @@ } 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/sql/Sql_Mysql.java
@@ -157,7 +157,7 @@ public static final String Tb_li9130_setparam_plan = DB_RamDB + ".`tb_li9130_setparam_plan`"; public static final String Tb_ess3100_sysstate = DB_RamDB + ".`tb_ess3100_sysstate`"; public static final String Tb_ess3100_pcs_state = DB_RamDB + ".`tb_ess3100_pcs_state`"; public static final String TB_Batt_Gtstate_Table = DB_RamDB +".`tb_batt_gtstate`"; //山西储能设备实时信息表 /**************************** db_user数据库 ***************************************************/ @@ -220,6 +220,7 @@ public static final String Peak_Statistics_Table = WEB_Site +".`tb_peak_statistics`"; //消峰填谷电价统计表 public static final String Weather_City2_Table = WEB_Site +".`tb_weather_city2`"; //天气表 public static final String TB_3D_STATION_Table = WEB_Site +".`tb_3d_station`";
@@ -436,4 +436,6 @@ `stationName` varchar(255) DEFAULT NULL, `battGroupName` varchar(255) DEFAULT NULL, `pictureUrl` varchar(255) DEFAULT NULL, V2.22 edit at date 2022-04-24 1.默认创建`db_ram_db`.`tb_batt_gtstate`----山西储能设备信息表 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -28,7 +28,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 2.21; public final static float m_VersionNum = (float) 2.22; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
