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/dto/App_bts_comm_task.java | 12 ++++++------ gx_tieta/src/com/fgkj/dao/impl/App_bts_comm_taskImpl.java | 23 ++++++++++++++++++++--- 2 files changed, 26 insertions(+), 9 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; diff --git a/gx_tieta/src/com/fgkj/dto/App_bts_comm_task.java b/gx_tieta/src/com/fgkj/dto/App_bts_comm_task.java index 0ef987f..70d3385 100644 --- a/gx_tieta/src/com/fgkj/dto/App_bts_comm_task.java +++ b/gx_tieta/src/com/fgkj/dto/App_bts_comm_task.java @@ -16,7 +16,7 @@ private int battgroup_index3; private int battgroup_id4; private int battgroup_index4; - private Date connect_time; + private Date connet_time; private Date dev_comm_runtime; private int break_type;//break_type 锛�0锛屾垚鍔熻繛鎺ワ紱1锛屾壘涓嶅埌瀵瑰簲dev_id锛�2锛岄�氫俊寮傚父鏂紑 private String stationName; @@ -98,11 +98,11 @@ public void setBattgroup_index4(int battgroup_index4) { this.battgroup_index4 = battgroup_index4; } - public Date getConnect_time() { - return connect_time; + public Date getConnet_time() { + return connet_time; } - public void setConnect_time(Date connect_time) { - this.connect_time = connect_time; + public void setConnet_time(Date connet_time) { + this.connet_time = connet_time; } public Date getDev_comm_runtime() { return dev_comm_runtime; @@ -167,7 +167,7 @@ + ", battgroup_index2=" + battgroup_index2 + ", battgroup_id3=" + battgroup_id3 + ", battgroup_index3=" + battgroup_index3 + ", battgroup_id4=" + battgroup_id4 + ", battgroup_index4=" - + battgroup_index4 + ", connect_time=" + connect_time + + battgroup_index4 + ", connect_time=" + connet_time + ", dev_comm_runtime=" + dev_comm_runtime + ", break_type=" + break_type + ", stationName=" + stationName + ", stationName1=" + stationName1 + ", stationName2=" -- Gitblit v1.9.1