| | |
|---|
| | | sql.sqlMysqlExecute(sql_str01); |
|---|
| | | } |
|---|
| | | sql.sqlMysqlExecute(sql_str02); |
|---|
| | | //添加err_count |
|---|
| | | String sql_str1 = " SELECT * FROM information_schema.columns " |
|---|
| | | + " WHERE table_schema= 'web_site' " |
|---|
| | | + " AND table_name='tb_resset_station' " |
|---|
| | | + " AND column_name='err_count'"; |
|---|
| | | res = sql.sqlMysqlQuery(sql_str1); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Resset_Station_Table |
|---|
| | | + " ADD COLUMN `err_count` int(11) NOT NULL DEFAULT '3' COMMENT '发送命令错误计数[后台默认3次]'"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | res = sql.sqlMysqlQuery(" SELECT DISTINCT(StationId) FROM " + Sql_Mysql.BattInf_Table + |
|---|
| | | " WHERE StationId NOT IN (" + |
|---|
| | | " SELECT stationid " + |
|---|
