From 954fc81fa128640249f8b4ba0c2cba6bd5ed4e87 Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期三, 28 十一月 2018 14:37:33 +0800
Subject: [PATCH] 修改后台内容
---
gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java
index ef9d9dc..1b23589 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_battparamImpl.java
@@ -49,7 +49,7 @@
//鏍规嵁璁惧id鏌ヨ鐢垫睜鍙傛暟淇℃伅
public List serchByCondition(Object obj) {
Fbs9100_battparam bparam=(Fbs9100_battparam) obj;
- String sql=" select distinct num,dev_ip,dev_id,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType " +
+ String sql=" select distinct dev_id, dev_ip,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType " +
" ,db_battinf.tb_battinf.DeviceName,StationName,StationName1,StationName2,StationName3,StationName5,StationId " +
" from db_ram_db.tb_fbs9100_battparam,db_battinf.tb_battinf " +
" where dev_id=? and db_ram_db.tb_fbs9100_battparam.dev_id=db_battinf.tb_battinf.fbsdeviceid" +
@@ -61,7 +61,6 @@
try {
while(rs.next()){
Fbs9100_battparam b=new Fbs9100_battparam();
- b.setNum(rs.getInt("num"));
b.setDev_ip(rs.getString("dev_ip"));
b.setDev_id(rs.getInt("dev_id"));
b.setOp_cmd(rs.getInt("op_cmd"));
@@ -106,7 +105,7 @@
}
String sql_end = "";
boolean res_exe = false;
- String sql = "UPDATE db_ram_db.db_ram_db.tb_fbs9100_battparam SET "
+ String sql = "UPDATE db_ram_db.tb_fbs9100_battparam SET "
+ " op_cmd=? " + sql_end
+ " WHERE dev_id=? ";
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{m_cmd,dev_id});
--
Gitblit v1.9.1