From 2fe250ece8de95b3f70172fe5b45793ab6a3084a Mon Sep 17 00:00:00 2001
From: D:/workspace/chenjingjing/git/gx_tieta/gx_tieta/.gitignore <chenjingjing@LAPTOP-E51P2139>
Date: 星期五, 18 一月 2019 17:30:50 +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