From 03b45d454497bbc2250b5d9daa12de72e01e27e1 Mon Sep 17 00:00:00 2001 From: D:/workspace/chenjingjing/git/gx_tieta/gx_tieta/.gitignore <chenjingjing@LAPTOP-E51P2139> Date: 星期四, 10 一月 2019 16:02:56 +0800 Subject: [PATCH] 修改 --- gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java | 11 +++++++++-- 1 files changed, 9 insertions(+), 2 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java index f52488e..5679f3e 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java +++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java @@ -47,9 +47,9 @@ if(list!=null&&list.size()>0){ for (int i = 0; i < list.size(); i++) { Fbs9100_sysparam fs=list.get(i); - String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime" + String sql="REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime" + ",MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart) " - + " values("+fs.getDev_id()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime() + + " values("+fs.getDev_id()+","+fs.getOp_cmd()+",'"+fs.getIPADDR()+"','"+fs.getSubIPADDR()+"','"+fs.getNetGateADDR()+"',"+fs.getGroupVolRange()+","+fs.getGroupVolSorce()+","+fs.getCurrentRange()+","+fs.getCurrentTyte()+","+fs.getMonomerOrder()+","+fs.getBackLightTime() +",'"+fs.getMACADDR()+"',"+fs.getLoaderCount()+","+fs.getDtCardCount()+","+fs.getPowerBreakChargeCurr()+","+fs.getMajorBattGroupNum()+","+fs.getPOF_BG_Boost_Cnt()+","+fs.getPOF_BG_Boost_VolStop()+","+fs.getPOF_BG_Boost_VolStart()+")"; sql_str.add(sql); { @@ -71,6 +71,13 @@ boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id()}); return bl; } + //鏌ヨ绯荤粺鍙傛暟鍓�(濡傛灉娌℃湁榛樿鏁版嵁瑕佺敤REPLACE 娣诲姞涓�绗旀暟鎹�)鍚屾椂鍙戦�佸懡浠� + public boolean replacePL(Object obj){ + Fbs9100_sysparam sys=(Fbs9100_sysparam) obj; + String sql=" REPLACE into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)"; + boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id(),sys.getOp_cmd()}); + return bl; + } public boolean del(Object obj) { // TODO Auto-generated method stub return false; -- Gitblit v1.9.1