| BattMonitor_DB_Builder/bin/com/database_util/DB_Circle.class | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_Circle.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/bin/com/database_util/DB_Circle.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -6,6 +6,11 @@ GRANT ALL PRIVILEGES ON *.* TO 'whyc'@'localhost'; FLUSH PRIVILEGES; V2.08 edit at date 2024-10-05 1.新增动环相关配置库表 db_circle.tb_circle_inf db_circle.tb_sub_inf V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('57', '用户密码时效', '-1', '15',''); BattMonitor_DB_Builder/src/com/database_util/DB_Circle.java
New file @@ -0,0 +1,122 @@ package com.database_util; import java.sql.SQLException; import java.util.Date; import com.base.Com; import com.sql.MysqlConnPool; import com.sql.Sql_Mysql; public class DB_Circle { public static void init(MysqlConnPool pool, boolean recreate) { System.out.println(" db_circle init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); createDB_Circle(pool); createCircle_Inf_Table(pool, recreate); createSub_Inf_Table(pool, recreate); System.out.println(" db_circle init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } /** * 创建 db_circle 数据库 * @param pool */ public static void createDB_Circle(MysqlConnPool pool) { Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_CIRCLE); } catch (SQLException e) { e.printStackTrace(); } finally { sql.close_con(); } } /** * 创建 tb_circle_inf 表 * @param pool * @param recreate */ public static void createCircle_Inf_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Circle_Inf_Table; String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Circle_Inf_Table + " (" + " `num` int(11) NOT NULL AUTO_INCREMENT," + " `station_id` varchar(20) NOT NULL DEFAULT '0'," + " `station_name` varchar(100) NOT NULL DEFAULT ' '," + " `station_name1` varchar(100) NOT NULL DEFAULT ' '," + " `station_name2` varchar(100) NOT NULL DEFAULT ' '," + " `station_name3` varchar(100) NOT NULL DEFAULT ' '," + " `station_name4` varchar(100) NOT NULL DEFAULT ' '," + " `station_name5` varchar(100) NOT NULL DEFAULT ' '," + " `station_name6` varchar(100) DEFAULT ' '," + " `station_name7` varchar(100) DEFAULT ' '," + " `station_name8` varchar(100) DEFAULT ' '," + " `station_name9` varchar(100) DEFAULT ' '," + " `station_ip` varchar(20) NOT NULL DEFAULT '0'," + " `device_id` varchar(20) DEFAULT '0'," + " `device_name` varchar(100) DEFAULT '0'," + " `circle_product_date` date NOT NULL DEFAULT '2006-07-06'," + " `circle_inuse_date` date NOT NULL DEFAULT '2006-07-06'," + " `device_type` int(11) DEFAULT '1' COMMENT '资产类别:1 动环，2设备仪器'," + " `device_product` varchar(100) DEFAULT '华为' COMMENT '品牌/厂家'," + " `device_model` varchar(100) DEFAULT '220kl_9108' COMMENT '型号/规格'," + " `device_address` varchar(100) DEFAULT '机房电源房' COMMENT '所在位置'," + " `device_state` int(11) DEFAULT '1' COMMENT '正常'," + " `sub_count` int(11) DEFAULT '0' COMMENT '子件数量'," + " `property_name` varchar(100) DEFAULT '交、直流配电柜'," + " PRIMARY KEY (`num`)," + " KEY `index_station_id` (`station_id`)," + " KEY `index_powerdev_id` (`device_id`)," + " KEY `index_station_name` (`station_name`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8;"; 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(); } } /** * 创建 tb_sub_inf 表 * @param pool * @param recreate */ public static void createSub_Inf_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Sub_Inf_Table; String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Sub_Inf_Table + " (" + " `sub_id` int(11) NOT NULL AUTO_INCREMENT," + " `device_id` varchar(20) NOT NULL DEFAULT '0'," + " `sub_name` varchar(100) DEFAULT '0'," + " `sub_inuse_date` date NOT NULL DEFAULT '2006-07-06'," + " `sub_type` int(11) DEFAULT '1' COMMENT '子件类别'," + " `sub_device_type` int(11) DEFAULT '1' COMMENT '所属类别'," + " `sub_model` varchar(100) DEFAULT '220kl_9108' COMMENT '型号/规格'," + " `sub_property_name` varchar(100) DEFAULT '交、直流配电柜'," + " PRIMARY KEY (`sub_id`)" + ") ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;"; 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(); } } } BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -44,6 +44,7 @@ final public static String DB_IED_SCOUT = "`db_ied_scout`"; //UPS历史实时数据库 final public static String DB_NJ_MEASUREMENT = "`db_nj_measurement`"; //南京首页属性信息配置表 final public static String DB_CIRCLE = "`db_circle`"; //动环数据库 //--------------------------------------------------------------------------------------------// public final static String TB_HardDevSmsState = "tb_hard_dev_sms_state"; //--------------------------------------------------------------------------------------------// @@ -400,6 +401,10 @@ public final static String Njhome_Config_Table = DB_NJ_MEASUREMENT + ".tb_njhome_config"; //首页属性信息配置表 public final static String Njhome_Station_Table = DB_NJ_MEASUREMENT + ".tb_njhome_station"; //首页机房信息配置表 /***************************** db_circle 数据库 **********************************/ public final static String Circle_Inf_Table = DB_CIRCLE + ".tb_circle_inf"; public final static String Sub_Inf_Table = DB_CIRCLE + ".tb_sub_inf"; //--------------------------------------------------------------------------------------------// //--------------------------------------------------------------------------------------------// public Connection mysql_con; BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -6,6 +6,11 @@ GRANT ALL PRIVILEGES ON *.* TO 'whyc'@'localhost'; FLUSH PRIVILEGES; V2.08 edit at date 2024-10-05 1.新增动环相关配置库表 db_circle.tb_circle_inf db_circle.tb_sub_inf V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('57', '用户密码时效', '-1', '15',''); BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -10,6 +10,7 @@ import com.database_util.DB_App_Sys; import com.database_util.DB_Batt_History; import com.database_util.DB_Batt_Testdata; import com.database_util.DB_Circle; import com.database_util.DB_Dev_History; import com.database_util.DB_Dev_TestParam; import com.database_util.DB_Fbo_testdata; @@ -37,7 +38,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 2.07; public final static float m_VersionNum = (float) 2.08; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/ @@ -195,6 +196,8 @@ DB_Ied_Scout.init(GB_MysqlConnPool, recreate_tb); DB_Nj_Measurement.init(GB_MysqlConnPool, recreate_tb); DB_Circle.init(GB_MysqlConnPool, recreate_tb); //设置重启告警线程
