From a11b122fc37975cf8d9bb1bd8efd4f4de078264d Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.27>
Date: 星期二, 06 十一月 2018 10:44:49 +0800
Subject: [PATCH] 获取gprs信号和查询
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java
index 76ba829..57dee4c 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java
@@ -25,8 +25,12 @@
// TODO Auto-generated method stub
return false;
}
+ //缁檊prs鍙戦�佹寚浠�
public boolean update(Object obj) {
- return false;
+ Bts_gprs_state gprs=(Bts_gprs_state) obj;
+ String sql=" update db_ram_db.tb_bts_gprs_state set AT_cmd=? where dev_id=? ";
+ boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getAT_cmd(),gprs.getDev_id()});
+ return bl;
}
public boolean del(Object obj) {
@@ -41,7 +45,7 @@
//鏍规嵁璁惧id璇诲彇鐨勮澶囪繛鎺ョ殑gprs妯″潡鐨勪俊鍙峰��
public List serchByCondition(Object obj) {
Bts_gprs_state gprs=(Bts_gprs_state) obj;
- String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,record_datetime,scq_val" +
+ String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf" +
" ,stationName,FBSDeviceName " +
" from db_ram_db.tb_bts_gprs_state,db_battinf.tb_battinf " +
" where db_ram_db.tb_bts_gprs_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
@@ -57,8 +61,8 @@
g.setNum(rs.getInt("num"));
g.setDev_id(rs.getInt("dev_id"));
g.setOp_cmd(rs.getInt("op_cmd"));
- g.setRecord_datetime(rs.getTimestamp("record_datetime"));
- g.setScq_val(rs.getString("scq_val"));
+ g.setAT_cmd(rs.getString("aT_cmd"));
+ g.setAck_inf(rs.getString("ack_inf"));
g.setStationName(rs.getString("stationName"));
g.setFBSDeviceName(rs.getString("fBSDeviceName"));
list.add(g);
--
Gitblit v1.9.1