From b98276a7ff8af761f333fe0899efe18f9a4b9ce7 Mon Sep 17 00:00:00 2001 From: LiJun <LiJun@192.168.10.10> Date: 星期四, 18 十月 2018 16:50:19 +0800 Subject: [PATCH] 机房状态记录查询页面中的详情中的查询 --- gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java | 25 +++++++++++++++++++++---- 1 files changed, 21 insertions(+), 4 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java index a4e2842..a689c13 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java @@ -9,6 +9,8 @@ import java.util.Date; import java.util.List; +import sun.security.krb5.internal.PAEncTSEnc; + import com.fgkj.actions.ActionUtil; import com.fgkj.dao.AlarmDaoFactory; import com.fgkj.dao.BaseDAO; @@ -295,7 +297,7 @@ Connection conn=DBUtil.getConn(); String numberSql=" SELECT FOUND_ROWS() number"; String sql="select SQL_CALC_FOUND_ROWS distinct station_id,dev_id,station_event_type,record_datetime,station_event_trig ,tb_battinf.StationName,tb_battinf.StationName1,tb_battinf.StationName2,tb_battinf.StationName3 " + - " from tb_bts_station_event,db_battinf.tb_battinf " + + " from db_alarm.tb_bts_station_event,db_battinf.tb_battinf " + " where tb_bts_station_event.dev_id=tb_battinf.FBSDeviceId " + " and dev_id=? " + " and record_datetime>=? and record_datetime<=? "; @@ -309,9 +311,11 @@ } //鎺掑簭 String orderSql=" order by station_id,station_event_type,record_datetime,station_event_trig asc " ; + sql+=orderSql; //鍒嗛〉 String limitSql=" limit ?,? "; - List<Bts_station_event> list=DAOHelper.executeQuery(sql, conn, new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),bevent.getStation_event_type(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() { + sql+=limitSql; + List<Bts_station_event> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),bevent.getStation_event_type(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() { public List getResults(ResultSet rs) { List list=new ArrayList(); @@ -324,6 +328,8 @@ b.setStation_event_type(rs.getInt("station_event_type")); b.setStation_event_trig(rs.getInt("station_event_trig")); b.setStationName(rs.getString("stationName")); + Page p=new Page(); + b.setPage(p); list.add(b); } } catch (SQLException e) { @@ -378,11 +384,22 @@ bmd.setPage(p); bmd.setBinf(binf); bmd.setUinf(uinf); - List<Bts_station_event> list=bimpl.serchByCondition(binf); + /* List<Bts_station_event> list=bimpl.serchByCondition(binf); System.out.println(list.size()); for (Bts_station_event b : list) { System.out.println(b.getNote()+" "+b.getDev_id()+" "+b.getStation_event_type_poff()+" "+b.getStation_event_type_xuhang()+" "+b.getStation_event_type_fadian()+" "+b.getStation_event_type_diaozhan()+" "+b.getStation_event_type_dooropen()+" "+b.getStation_event_type_tempup()+" "+b.getStation_event_type_templow()+" "+b.getStation_event_type_dampup()+" "+b.getStation_event_type_damplow()+" "+b.getStationName()); - } + }*/ + Bts_station_event b=new Bts_station_event(); + b.setDev_id(910000001); + b.setRecord_datetime(ActionUtil.getSimpDate(date1)); + b.setRecord_datetime_end(ActionUtil.getSimpDate(date2)); + b.setStation_event_type(0); + Page page=new Page(); + page.setPageCurr(1); + page.setPageSize(10); + b.setPage(page); + List list=bimpl.serchByInfo(b); + System.out.println(list.size()); } } -- Gitblit v1.9.1