| | |
| | | list.add(uchart.getChart_dev_alarm());
|
| | | list.add(uchart.getChart_pre_charge());
|
| | | list.add(uchart.getChart_online_charge());
|
| | | 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) values(?,?,?,?,?,?,?,?,?,?,?)";
|
| | | list.add(uchart.getChart_poff());
|
| | | list.add(uchart.getChart_install());
|
| | | 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;
|
| | | }
|
| | |
| | | list.add(uchart.getChart_online_charge());
|
| | | sql+=online_chargeSql;
|
| | | }
|
| | | //Chart_poff图片
|
| | | String poffSql=" Chart_poff=? ";
|
| | | if(uchart.getChart_poff()!=null&&uchart.getChart_poff().length()>0){
|
| | | if(list.size()>0){
|
| | | sql+=",";
|
| | | }
|
| | | list.add(uchart.getChart_poff());
|
| | | sql+=poffSql;
|
| | | }
|
| | | //Chart_install图片
|
| | | String installSql=" Chart_install=? ";
|
| | | if(uchart.getChart_install()!=null&&uchart.getChart_install().length()>0){
|
| | | if(list.size()>0){
|
| | | sql+=",";
|
| | | }
|
| | | 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=?";
|
| | | 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;
|
| | | }
|