| | |
|---|
| | | // TODO Auto-generated method stub
|
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | //根据省市区机房名称查询(uid放在num中)
|
|---|
| | | //根据设备id查询(uid放在num中)
|
|---|
| | | public List serchByCondition(Object obj) {
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | Page page=binf.getPage();
|
|---|
| | | Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql=" SELECT FOUND_ROWS() number";
|
|---|
| | | String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,thread_id,battgroup_cnt,battgroup_id1,battgroup_index1,battgroup_id2,battgroup_index2,battgroup_id3,battgroup_index3,battgroup_id4,battgroup_index4,connet_time,dev_comm_runtime,break_type " +
|
|---|
| | | String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,thread_id,dev_mcu_uid,battgroup_cnt,battgroup_id1,battgroup_index1,battgroup_id2,battgroup_index2,battgroup_id3,battgroup_index3,battgroup_id4,battgroup_index4,connet_time,dev_comm_runtime,break_type " +
|
|---|
| | | " ,stationName,stationName1,stationName2,stationName3,stationName5,StationId " +
|
|---|
| | | " from db_app_sys.tb_app_bts_comm_task " +
|
|---|
| | | " left outer join db_battinf.tb_battinf on db_app_sys.tb_app_bts_comm_task.dev_id=db_battinf.tb_battinf.fBSDeviceId " +
|
|---|
| | |
|---|
| | | atask.setDev_id(rs.getInt("dev_id"));
|
|---|
| | | atask.setThread_id(rs.getInt("thread_id"));
|
|---|
| | | atask.setBattgroup_cnt(rs.getInt("battgroup_cnt"));
|
|---|
| | | atask.setDev_mcu_uid(rs.getString("dev_mcu_uid"));
|
|---|
| | | atask.setBattgroup_id1(rs.getInt("battgroup_id1"));
|
|---|
| | | atask.setBattgroup_index1(rs.getInt("battgroup_index1"));
|
|---|
| | | atask.setBattgroup_id2(rs.getInt("battgroup_id2"));
|
|---|
