From 4a60ea62eb4fe31b21ff6a2a32d8d0d9ba065b29 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.26>
Date: 星期四, 18 十月 2018 16:05:53 +0800
Subject: [PATCH] 详情
---
gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java | 18 +++++++++++++++---
gx_tieta/src/com/fgkj/dto/Bts_station_event.java | 10 +++++++++-
2 files changed, 24 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 852b89b..06eae27 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
@@ -1,5 +1,6 @@
package com.fgkj.dao.impl;
+import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
@@ -13,6 +14,7 @@
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
+import com.fgkj.dao.LimitNumberFactory;
import com.fgkj.db.DBUtil;
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Batt_Maint_Dealarm;
@@ -289,13 +291,17 @@
//鏈烘埧浜嬩欢缁熻(璇︽儏)
public List serchByInfo(Object obj) {
Bts_station_event bevent=(Bts_station_event) obj;
- String sql="select station_id,dev_id,station_event_type,record_datetime,station_event_trig ,tb_battinf.StationName,tb_battinf.StationName1,tb_battinf.StationName2,tb_battinf.StationName3 " +
+ Page p=bevent.getPage();
+ 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 " +
" where tb_bts_station_event.dev_id=tb_battinf.FBSDeviceId " +
" and dev_id=? " +
" and record_datetime>=? and record_datetime<=? " +
- " order by station_id,station_event_type,record_datetime,station_event_trig asc ";
- List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end()}, new CallBack() {
+ " order by station_id,station_event_type,record_datetime,station_event_trig asc " +
+ " limit ?,? ";
+ List<Bts_station_event> list=DAOHelper.executeQuery(sql, conn, new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() {
public List getResults(ResultSet rs) {
List list=new ArrayList();
@@ -317,6 +323,12 @@
return list;
}
});
+ //鍘绘帀limit鏉′欢鍚庣殑鎬绘暟
+ int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
+ //System.out.println("number: "+number);
+ if(list!=null&&list.size()>0){
+ list.get(list.size()-1).getPage().setPageAll(number);
+ }
return list;
}
public static void main(String[] args) throws ParseException {
diff --git a/gx_tieta/src/com/fgkj/dto/Bts_station_event.java b/gx_tieta/src/com/fgkj/dto/Bts_station_event.java
index 419cbd8..e94b4cb 100644
--- a/gx_tieta/src/com/fgkj/dto/Bts_station_event.java
+++ b/gx_tieta/src/com/fgkj/dto/Bts_station_event.java
@@ -26,6 +26,8 @@
public int station_event_type_templow; //鍩虹珯娓╁害涓嬮檺
public int station_event_type_dampup; //鍩虹珯婀垮害涓婇檺
public int station_event_type_damplow; //鍩虹珯婀垮害涓嬮檺
+
+ public Page page;
public int getNum() {
return num;
@@ -136,6 +138,12 @@
public void setStationName(String stationName) {
this.stationName = stationName;
}
+ public Page getPage() {
+ return page;
+ }
+ public void setPage(Page page) {
+ this.page = page;
+ }
@Override
public String toString() {
return "Bts_station_event [num=" + num + ", station_id=" + station_id
@@ -154,7 +162,7 @@
+ station_event_type_tempup + ", station_event_type_templow="
+ station_event_type_templow + ", station_event_type_dampup="
+ station_event_type_dampup + ", station_event_type_damplow="
- + station_event_type_damplow + "]";
+ + station_event_type_damplow + ", page=" + page + "]";
}
--
Gitblit v1.9.1