From d662962200bbf6bd150b079e6d25c67ff49ad9a2 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.30>
Date: 星期三, 05 十二月 2018 17:07:56 +0800
Subject: [PATCH] App_bts_comm_task修改
---
gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java | 23 ++++++++++++++++++++---
1 files changed, 20 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java b/gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java
index eca5a0d..b2ddd4b 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java
@@ -14,6 +14,7 @@
import com.fgkj.dto.App_bts_comm_task;
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Page;
+import com.fgkj.dto.User_inf;
import com.mysql.fabric.xmlrpc.base.Array;
public class App_bts_comm_taskImpl implements BaseDAO,CallBack{
@@ -48,7 +49,7 @@
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,connect_time,dev_comm_runtime,break_type " +
+ 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 " +
" ,stationName,stationName1,stationName2,stationName3,stationName5,StationId " +
" from db_app_sys.tb_app_bts_comm_task,db_battinf.tb_battinf " +
" where db_app_sys.tb_app_bts_comm_task.dev_id=db_battinf.tb_battinf.fBSDeviceId " +
@@ -79,7 +80,7 @@
atask.setBattgroup_index3(rs.getInt("battgroup_index3"));
atask.setBattgroup_id4(rs.getInt("battgroup_id4"));
atask.setBattgroup_index4(rs.getInt("battgroup_index4"));
- atask.setConnect_time(rs.getTimestamp("connect_time"));
+ atask.setConnet_time(rs.getTimestamp("connet_time"));
atask.setDev_comm_runtime(rs.getTimestamp("dev_comm_runtime"));
atask.setBreak_type(rs.getInt("break_type"));
atask.setStationId(rs.getString("stationId"));
@@ -106,7 +107,23 @@
}
return list;
}
-
+ public static void main(String[] args) {
+ App_bts_comm_taskImpl aimpl=new App_bts_comm_taskImpl();
+ BattInf binf=new BattInf();
+ binf.setNum(1002);
+ binf.setStationName1("");
+ binf.setStationName2("");
+ binf.setStationName3("");
+ binf.setStationName5("");
+ binf.setStationId("");
+ binf.setBattGroupNum(62);
+ Page p=new Page();
+ p.setPageCurr(1);
+ p.setPageSize(10);
+ binf.setPage(p);
+ List list=aimpl.serchByCondition(binf);
+ System.out.println(list.size());
+ }
public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
--
Gitblit v1.9.1