| | |
| | | //实时监测界面根据dev_alarmstate状态判断接触器状态
|
| | | public List serchContactorState(Object obj) {
|
| | | Fbs9100_state fs=(Fbs9100_state) obj;
|
| | | String sql="select dev_id,dev_alarmstate,dev_workstate,record_datetime,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type,batt_online_state from db_ram_db.tb_fbs9100_state where dev_id=? limit 1";
|
| | | String sql="select dev_id,dev_alarmstate,dev_workstate,record_datetime,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type,batt_online_state,dev_commcount,dev_errcommcount from db_ram_db.tb_fbs9100_state where dev_id=? limit 1";
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{fs.getDev_id()},new CallBack() {
|
| | |
|
| | | public List getResults(ResultSet rs) {
|
| | |
| | | fstate.setDev_last_captest_stop_type(rs.getInt("dev_last_captest_stop_type"));
|
| | | fstate.setDev_temp(rs.getFloat("dev_temp"));
|
| | | fstate.setBatt_online_state(rs.getInt("batt_online_state"));
|
| | | fstate.setDev_commcount(rs.getInt("dev_commcount"));
|
| | | fstate.setDev_errcommcount(rs.getInt("dev_errcommcount"));
|
| | | list.add(fstate);
|
| | | }
|
| | | } catch (SQLException e) {
|