| | |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table |
|---|
| | | + " ADD COLUMN `batt_alm_state` int(11) NOT NULL DEFAULT '0' COMMENT '电池组告警状态'"); |
|---|
| | | } |
|---|
| | | //新增字段'vbus_vol' --母线电压 |
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" |
|---|
| | | + " WHERE table_schema='db_ram_db'" |
|---|
| | | + " AND table_name='tb_batt_rtstate'" |
|---|
| | | + " AND column_name='vbus_vol'"); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table |
|---|
| | | + " ADD COLUMN `vbus_vol` float NOT NULL DEFAULT '0' COMMENT '母线电压'"); |
|---|
| | | } |
|---|
| | | } catch (SQLException e) { |
|---|
| | | e.printStackTrace(); |
|---|
| | | } finally { |
|---|
