hdw
2018-12-28 c673a0b9ffe1f1239f596dfd88c0a76c735b3d43
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});