From 9769cff3310322065483cffc9fd29096d0256fa4 Mon Sep 17 00:00:00 2001
From: CJJ <Administrator@USER-20180117QL>
Date: 星期三, 19 十二月 2018 17:27:42 +0800
Subject: [PATCH] 修改提交新建初始值，验证ID是否重复，重复重建。
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 44 ++++++++++++++++++++++++++++++++------------
1 files changed, 32 insertions(+), 12 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 c1e16eb..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,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) {
@@ -59,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);
@@ -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