V1.98 edit at date 2024-04-08 1.表'db_pwrdev_inf.tb_pwrapp_acdcinf'新增字段 `...

DELL

2024-04-08 9867b6134a7e4026e6105c9e70ba7be46c22864b

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -4849,17 +4849,82 @@
            "  `outputVolt2` float NOT NULL DEFAULT '0' COMMENT '输出电压2'," + 
            "  `outputVolt3` float NOT NULL DEFAULT '0' COMMENT '输出电压3'," + 
            "  `outputVolt4` float NOT NULL DEFAULT '0' COMMENT '输出电压4'," + 
            "  `mode_state` int(11) NOT NULL DEFAULT '0' COMMENT '模块总状态'," + 
            "  `drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '干接点通信状态(0xAAAA-正常  0xBBBB-异常)'," + 
            "  `k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k1检测状态(0xAAAA-正常  0xBBBB-异常)'," + 
            "  `k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k2检测状态(0xAAAA-正常  0xBBBB-异常)'," + 
            "  `urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '急停状态(0xAAAA-未触发  0xBBBB-触发)'," + 
            "  `bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '旁路状态（0xAAAA-未接入  0xBBBB-接入旁路）'," + 
            "  `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开  1-闭合）'," + 
            "  PRIMARY KEY (`num`)," + 
            "  UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" + 
            ") ENGINE=InnoDB 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);   
         
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='mode_state'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                          + " ADD COLUMN `mode_state` int(11) NOT NULL DEFAULT '0' COMMENT '模块总状态';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='drynode_commst'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                          + " ADD COLUMN `drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '干接点通信状态(0xAAAA-正常  0xBBBB-异常)';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='k1_check_st'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                  + " ADD COLUMN `k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k1检测状态(0xAAAA-正常  0xBBBB-异常)';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='k2_check_st'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                  + " ADD COLUMN `k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k2检测状态(0xAAAA-正常  0xBBBB-异常)';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='urgentswitch_st'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                  + " ADD COLUMN `urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '急停状态(0xAAAA-未触发  0xBBBB-触发)';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='bypassswitch_st'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                  + " ADD COLUMN `bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '旁路状态（0xAAAA-未接入  0xBBBB-接入旁路）';");
         }
         res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
               + " WHERE table_schema='db_ram_db'"
               + " AND table_name='tb_fbs9100s_stemnode_state'"
               + " AND column_name='k1_st'");
         if(false == res.next()) {
            sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table 
                  + " ADD COLUMN `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开  1-闭合）';");
         }
			
			
      } catch (SQLException e) {
         e.printStackTrace();
      } finally {