批量读取系统参数

81041

2019-01-11 fa00382db413a8489d07983b66f0869305b51a9a

 gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java

@@ -55,7 +55,8 @@
      list.add(uchart.getChart_online_charge());

      list.add(uchart.getChart_poff());

      list.add(uchart.getChart_install());

      String sql="insert into web_site.tb_user_Chart(chart_name,chart_file,Chart_logo,Chart_normal,Chart_behind,Chart_warn,Chart_timeout,Chart_nuclear_cap,Chart_dev_alarm,Chart_pre_charge,Chart_online_charge,Chart_poff,Chart_install) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";

      list.add(uchart.getChart_xuhang());

      String sql="insert into web_site.tb_user_Chart(chart_name,chart_file,Chart_logo,Chart_normal,Chart_behind,Chart_warn,Chart_timeout,Chart_nuclear_cap,Chart_dev_alarm,Chart_pre_charge,Chart_online_charge,Chart_poff,Chart_install,Chart_xuhang) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

      boolean bl=DAOHelper.executeUpdatePicture(DBUtil.getConn(), sql, list);

      return bl;

   }

@@ -163,11 +164,19 @@
         list.add(uchart.getChart_install());

         sql+=installSql;

      }

      //Chart_xuhang图片

      String xuhangSql=" Chart_xuhang=? ";

      if(uchart.getChart_xuhang()!=null&&uchart.getChart_xuhang().length()>0){

         if(list.size()>0){

            sql+=",";

         }

         list.add(uchart.getChart_xuhang());

         sql+=xuhangSql;

      }

      //endSql

      String endSql=" where chart_file=? ";

      list.add(uchart.getChart_file());

      sql+=endSql;

      //System.out.println(list.size()+"  "+sql);

      boolean bl=DAOHelper.executeUpdatePicture(DBUtil.getConn(), sql, list);

      return bl;

   }