From 35fefed0792c40cb99b8d15fa5811bbb5992bff9 Mon Sep 17 00:00:00 2001 From: D:/workspace/chenjingjing/git/gx_tieta/gx_tieta/.gitignore <chenjingjing@LAPTOP-E51P2139> Date: 星期一, 21 一月 2019 10:42:24 +0800 Subject: [PATCH] 修改 --- gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java | 13 +++++++++++-- 1 files changed, 11 insertions(+), 2 deletions(-) diff --git a/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java b/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java index 7ad91cd..bf403a7 100644 --- a/gx_tieta/src/com/fgkj/dao/impl/User_ChartImpl.java +++ b/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; } -- Gitblit v1.9.1