2.表'db_pwrdev_data_rt.tb_pwrdev_acdcdata'新增字段 `m17_out_vol` float NOT N...

DELL

2024-09-25 36deaf5ab0fc4390aba3a9407ff82984a0feee11

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java

@@ -589,6 +589,42 @@
            sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table 

                  + " ADD COLUMN `m16_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器16输出电压';");

         }

         //添加m17_out_vol

         res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

               + " WHERE table_schema='db_pwrdev_data_rt'"

               + " AND table_name='tb_pwrdev_acdcdata'"

               + " AND column_name='m17_out_vol'");

         if(false == res.next()) {

            sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table 
                  + " ADD COLUMN `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器17输出电压';");

         }

         //添加m18_out_vol

         res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

               + " WHERE table_schema='db_pwrdev_data_rt'"

               + " AND table_name='tb_pwrdev_acdcdata'"

               + " AND column_name='m18_out_vol'");

         if(false == res.next()) {

            sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table 
                  + " ADD COLUMN `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器18输出电压';");

         }

         //添加m19_out_vol

         res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

               + " WHERE table_schema='db_pwrdev_data_rt'"

               + " AND table_name='tb_pwrdev_acdcdata'"

               + " AND column_name='m19_out_vol'");

         if(false == res.next()) {

            sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table 
                  + " ADD COLUMN `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器19输出电压';");

         }

         //添加m20_out_vol

         res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

               + " WHERE table_schema='db_pwrdev_data_rt'"

               + " AND table_name='tb_pwrdev_acdcdata'"

               + " AND column_name='m20_out_vol'");

         if(false == res.next()) {

            sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table 
                  + " ADD COLUMN `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器20输出电压';");

         }

         

         //添加is_acb1_over_currA

         res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"