| | |
|---|
| | | import java.sql.ResultSet;
|
|---|
| | | import java.sql.SQLException;
|
|---|
| | | import java.util.ArrayList;
|
|---|
| | | import java.util.Date;
|
|---|
| | | import java.util.List;
|
|---|
| | | import com.fgkj.dao.BaseDAO;
|
|---|
| | | import com.fgkj.dao.CallBack;
|
|---|
| | |
|---|
| | | //实时监测界面根据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,dev_commcount,dev_errcommcount from db_ram_db.tb_fbs9100_state where dev_id=? limit 1";
|
|---|
| | | String sql="select dev_id,dev_version,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) {
|
|---|
| | |
|---|
| | | }else{
|
|---|
| | | ContactorState="开关闭合";
|
|---|
| | | }
|
|---|
| | | fstate.setDev_version(rs.getString("dev_version"));
|
|---|
| | | fstate.setRecord_datetime(rs.getString("record_datetime"));
|
|---|
| | | fstate.setDev_testgroupnum(rs.getInt("dev_testgroupnum")); //被测电池组号
|
|---|
| | | fstate.setDev_alarmstate(rs.getInt("dev_alarmstate"));
|
|---|
| | |
|---|
| | | fstate.setBatt_online_state(rs.getInt("batt_online_state"));
|
|---|
| | | fstate.setDev_commcount(rs.getInt("dev_commcount"));
|
|---|
| | | fstate.setDev_errcommcount(rs.getInt("dev_errcommcount"));
|
|---|
| | | fstate.setNote(DAOHelper.sdf.format(new Date()));
|
|---|
| | | list.add(fstate);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
