From c1cc2f63c90baadbd55689693e76404a9e6ed12e Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期四, 20 十二月 2018 14:21:56 +0800
Subject: [PATCH] 修改
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 17 ++++++++++-------
1 files changed, 10 insertions(+), 7 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 7e36c70..bfbab03 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
@@ -29,7 +29,7 @@
public boolean update(Object obj) {
Bts_gprs_state gprs=(Bts_gprs_state) obj;
String sql=" REPLACE into db_ram_db.tb_bts_gprs_state(AT_cmd,dev_id) values('"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"',?)";
- System.out.println(sql);
+ //System.out.println(sql);
boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getDev_id()});
return bl;
}
@@ -46,12 +46,12 @@
//鏍规嵁璁惧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,AT_cmd,ack_inf" +
+ String sql=" select distinct db_ram_db.tb_bts_gprs_state.num,dev_id,op_cmd,AT_cmd,ack_inf,bts_task_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 " +
- " and dev_id=? " +
- " order by record_datetime desc";
+ " and dev_id=? " ;
+ //System.err.println(sql);
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{gprs.getDev_id()}, new CallBack() {
public List getResults(ResultSet rs) {
@@ -64,6 +64,7 @@
g.setOp_cmd(rs.getInt("op_cmd"));
g.setAT_cmd(rs.getString("aT_cmd"));
g.setAck_inf(rs.getString("ack_inf"));
+ g.setBts_task_inf(rs.getString("bts_task_inf"));
g.setStationName(rs.getString("stationName"));
g.setFBSDeviceName(rs.getString("fBSDeviceName"));
list.add(g);
@@ -139,9 +140,11 @@
public static void main(String[] args) {
Bts_gprs_stateImpl bimpl=new Bts_gprs_stateImpl();
Bts_gprs_state gprs=new Bts_gprs_state();
- gprs.setDev_id(910000577);
+ gprs.setDev_id(910000001);
gprs.setAT_cmd("CSQ");
- boolean bl=bimpl.update(gprs);
- System.out.println(bl);
+ /* boolean bl=bimpl.update(gprs);
+ System.out.println(bl);*/
+ List list=bimpl.serchByCondition(gprs);
+ System.out.println(list);
}
}
--
Gitblit v1.9.1