From 253879d0d562db0290a67160d30d3f15e8e7bf09 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期二, 15 一月 2019 17:12:32 +0800
Subject: [PATCH] 修改
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 48 ++++++++++++++++++++++++++++++++++--------------
1 files changed, 34 insertions(+), 14 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..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
@@ -25,8 +25,13 @@
// 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=" REPLACE into db_ram_db.tb_bts_gprs_state(AT_cmd,dev_id) values('"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"',?)";
+ //System.out.println(sql);
+ boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getDev_id()});
+ return bl;
}
public boolean del(Object obj) {
@@ -41,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,record_datetime,scq_val" +
+ 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) {
@@ -57,8 +62,9 @@
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.setBts_task_inf(rs.getString("bts_task_inf"));
g.setStationName(rs.getString("stationName"));
g.setFBSDeviceName(rs.getString("fBSDeviceName"));
list.add(g);
@@ -73,22 +79,25 @@
return list;
}
//绯荤粺鍙傛暟鍛戒护鎿嶄綔璁惧鏃剁殑cmd鍜宎ck鏍￠獙
- public boolean sendCmdToFBS9100Dev(int cmd,int dev_id)
+ public Bts_gprs_state sendCmdToFBS9100Dev(int cmd,int dev_id)
{
int m_cmd = cmd;
int m_cmd_ack = cmd;
+ Bts_gprs_state gprs=new Bts_gprs_state();
+ gprs.setOp_cmd(0);
switch(m_cmd) {
case FBS9100_ComBase.CMD_ReadGPRSCSQ: m_cmd_ack = FBS9100_ComBase.CMD_ReadGPRSCSQAck; break;
- default: return false;
+ default: return gprs;
}
- boolean res_exe = false;
+ //boolean res_exe = false;
+ String ack_inf="";
String sql = "UPDATE db_ram_db.tb_bts_gprs_state SET "
+ " op_cmd=? "
+ " WHERE dev_id=? ";
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{m_cmd,dev_id});
if(true == bl)
{
- sql = "SELECT op_cmd FROM db_ram_db.tb_bts_gprs_state "+
+ sql = "SELECT op_cmd,ack_inf FROM db_ram_db.tb_bts_gprs_state "+
" WHERE dev_id="+dev_id;
Connection conn=DBUtil.getConn();
PreparedStatement ps = null;
@@ -101,8 +110,10 @@
if(rs.next())
{
if(rs.getInt("op_cmd") == m_cmd_ack)
- {
- res_exe = true;
+ {
+ gprs.setAck_inf(rs.getString("ack_inf"));
+ gprs.setOp_cmd(m_cmd_ack);
+ //res_exe = true;
break;
}
}
@@ -120,11 +131,20 @@
}
DBUtil.close(rs, ps, conn);
}
- return res_exe;
+ return gprs;
}
public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
}
-
+ 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(910000001);
+ gprs.setAT_cmd("CSQ");
+ /* boolean bl=bimpl.update(gprs);
+ System.out.println(bl);*/
+ List list=bimpl.serchByCondition(gprs);
+ System.out.println(list);
+}
}
--
Gitblit v1.9.1