From 592720573d6b194bbac25b25b6c619376cb9c0a4 Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期四, 13 十二月 2018 13:38:34 +0800
Subject: [PATCH] 修改电池查询面板中正则的验证
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_gprs_stateImpl.java | 23 +++++++++++++++++------
1 files changed, 17 insertions(+), 6 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 34228ba..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
@@ -28,8 +28,9 @@
//缁檊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=? where dev_id=? ";
- boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{gprs.getAT_cmd(),gprs.getDev_id()});
+ 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;
}
@@ -45,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) {
@@ -63,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);
@@ -135,5 +137,14 @@
// 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