From d489aed2de688a18d6aaf76ae3630b24d56c8ee4 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.27>
Date: 星期二, 06 十一月 2018 16:06:01 +0800
Subject: [PATCH] gprs使用REPLACE
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 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 1614904..7e36c70 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
@@ -28,8 +28,8 @@
//缁檊prs鍙戦�佹寚浠�
public boolean update(Object obj) {
Bts_gprs_state gprs=(Bts_gprs_state) obj;
- String sql=" update db_ram_db.tb_bts_gprs_state set AT_cmd='"+FBS9100_ComBase.CSQ+gprs.getAT_cmd()+"' where dev_id=? ";
- //System.out.println(sql);
+ 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;
}
@@ -136,5 +136,12 @@
// 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(910000577);
+ gprs.setAT_cmd("CSQ");
+ boolean bl=bimpl.update(gprs);
+ System.out.println(bl);
+}
}
--
Gitblit v1.9.1