From 79fc28047fe73a2500fb5cf6cfbf8b80f09d2cf0 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.26>
Date: 星期四, 18 十月 2018 17:31:58 +0800
Subject: [PATCH] 详情不加分页
---
gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java | 19 +++++++++++--------
1 files changed, 11 insertions(+), 8 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 a689c13..ae2e4de 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
@@ -294,9 +294,10 @@
public List serchByInfo(Object obj) {
Bts_station_event bevent=(Bts_station_event) obj;
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 " +
+ //Connection conn=DBUtil.getConn();
+ //String numberSql=" SELECT FOUND_ROWS() number";
+ //SQL_CALC_FOUND_ROWS
+ String sql="select 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 db_alarm.tb_bts_station_event,db_battinf.tb_battinf " +
" where tb_bts_station_event.dev_id=tb_battinf.FBSDeviceId " +
" and dev_id=? " +
@@ -313,9 +314,11 @@
String orderSql=" order by station_id,station_event_type,record_datetime,station_event_trig asc " ;
sql+=orderSql;
//鍒嗛〉
- String limitSql=" limit ?,? ";
- 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() {
+ //String limitSql=" limit ?,? ";
+ //sql+=limitSql;
+ //,(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()
+ //executeQueryLimit
+ List<Bts_station_event> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),bevent.getStation_event_type()}, new CallBack() {
public List getResults(ResultSet rs) {
List list=new ArrayList();
@@ -339,12 +342,12 @@
return list;
}
});
- //鍘绘帀limit鏉′欢鍚庣殑鎬绘暟
+ /*//鍘绘帀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 {
--
Gitblit v1.9.1