如何把（对话框——列表多选）选择后的值传到数据库中

lwcompany · 发表于 2017-2-18 15:13:05

jishuang 发表于 2017-2-16 10:24
Caused by: java.sql.SQLException: You can't specify target table 'GU_JTSKDWS_POWER' for update in FR ...

System.out.println("111111111111");
System.out.println(fDWMC);//永大电梯
System.out.println(fDWBH);//01001
System.out.println(fYHBH);//skj
System.out.println(fYHMC);//孙总
if((fDWMC!=null )&&(!fDWMC.equals(""))){
String fullDCondition = "%"+fDWMC +"%";
String rang ="select jstkdwspower from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '" + fullDCondition+"'";
if((fDWMC!=null )&&(!fDWMC.equals(""))){
String fullDCondition = "%"+fDWMC +"%";
String rang ="select jstkdwspower from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '" + fullDCondition+"'";//去旧（重复）标记
String delSql = "delete from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '"+fullDCondition+"'";
KSQL.executeUpdate(delSql, null, jtzjrbbModel, null);
// 插入新标记
String insertSql ="insert into GU_JTSKDWS_POWER jstkdwspower (guid(),0,jstkdwspower.fDWBH,jstkdwspower.fDWMC,jstkdwspower.fYHBH,jstkdwspower.fYHMC)";
Map<String, Object> param = new HashMap<String, Object>();
KSQL.executeUpdate(insertSql, param, jtzjrbbModel, null);

lwcompany · 发表于 2017-2-18 15:14:06

System.out.println(fDWMC);
System.out.println(fDWBH);
System.out.println(fYHBH);
System.out.println(fYHMC);
if((fDWMC!=null )&&(!fDWMC.equals(""))){
String fullDCondition = "%"+fDWMC +"%";
String rang ="select jstkdwspower from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '" + fullDCondition+"'";
//去旧（重复）标记
String delSql = "delete from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '"+fullDCondition+"'";
KSQL.executeUpdate(delSql, null, jtzjrbbModel, null);
// 插入新标记
String insertSql ="insert into GU_JTSKDWS_POWER jstkdwspower (guid(),0,jstkdwspower.fDWBH,jstkdwspower.fDWMC,jstkdwspower.fYHBH,jstkdwspower.fYHMC)";
Map<String, Object> param = new HashMap<String, Object>();
KSQL.executeUpdate(insertSql, param, jtzjrbbModel, null);
改了之后，出现
aused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, kdwspower (guid^^(),0,jstkdwspow中未找到需要的元素, 位置47期望是)
at com.justep.exception.KSQLException.create(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
at com.justep.system.ksql.parser.InsertParser.insertRelations(Unknown Source)
at com.justep.system.ksql.parser.InsertParser.start(Unknown Source)
at com.justep.system.ksql.parser.InsertParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 33 more

jishuang · 发表于 2017-2-20 09:55:04

KSQL的语法不正确

lwcompany · 发表于 2017-2-21 08:09:03

ublic static void updataSkdwPower(String fDWBH,String fDWMC,String fYHBH,String fYHMC,String fQY){
System.out.println("111111111111");
System.out.println(fDWMC);
System.out.println(fDWBH);
System.out.println(fYHBH);
System.out.println(fYHMC);
String version ="1";
JSONObject json = new JSONObject();
json.put("fDWBH", fDWBH);
if((fDWMC!=null )&&(!fDWMC.equals(""))){
String fullDCondition = "%"+fDWMC +"%";
String rang ="select jstkdwspower from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '" + fullDCondition+"'";
//去旧（重复）标记
/*String delSql = "delete from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC in ("+rang+")";
KSQL.executeUpdate(delSql, null, jtzjrbbModel, null);
// 插入新标记
String insertSql ="insert into GU_JTSKDWS_POWER jstkdwspower(jstkdwspower.fDWBH,jstkdwspower.fDWMC,jstkdwspower.fYHBH,jstkdwspower.fYHMC)"+
"(select jstkdwspower.* from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC in ("+rang+"))";
Map<String, Object> param = new HashMap<String, Object>();
KSQL.executeUpdate(insertSql, param, jtzjrbbModel, null);*/
//去旧（重复）标记
String delSql = "delete from GU_JTSKDWS_POWER jstkdwspower where jstkdwspower.fDWMC like '"+fullDCondition+"'";
KSQL.executeUpdate(delSql, null, jtzjrbbModel, null);
// 插入新标记
String insertSql ="insert into GU_JTSKDWS_POWER jstkdwspower(jstkdwspower,jstkdwspower.version,jstkdwspower.fDWBH,jstkdwspower.fDWMC,jstkdwspower.fYHBH,jstkdwspower.fYHMC)"+
"values(guid(),'0','"+fDWBH+"','"+fDWMC+"','"+fYHBH+"','"+fYHMC+"')";
Map<String, Object> param = new HashMap<String, Object>();
KSQL.executeUpdate(insertSql, param, jtzjrbbModel, null);
}

}

后台可以输出结果了：
111111111111
永大电梯
01001
skj
孙总
111111111111
永大电梯
01001
zyh
周宇红
但数据库中存储还是最后一个人数据
且前台管理员显示的是孙总数据
不明白前后台如何修改才行！！！

jishuang · 发表于 2017-2-21 10:41:13

把返回的多条数据的结果放到list中，然后action中定义list参数，遍历list中的数据执行ksql

action给list参数传参参考/UI2/demo/actions/process/invokeAction/mainActivity.w

lwcompany · 发表于 2017-2-22 15:41:10

请求远程好吗，急

jishuang · 发表于 2017-2-22 17:00:20

放到list中也不对?

lwcompany · 发表于 2017-2-22 22:32:52

本帖最后由 lwcompany 于 2017-2-22 22:35 编辑


      public static void updataSkdwPower(String fDWBH,String fDWMC,List<?> fYHBH,List<?> fYHMC,String fQY){
            System.out.println("111111111111");
            System.out.println(fDWMC);
            System.out.println(fDWBH);
            System.out.println(fYHBH);
            System.out.println(fYHMC);
            String  fYHBH1 =""+ Transform.toString(fYHBH);
            for(String i:fYHBH1)//提示:只能通过 java.lang.Iterable 的数组或实例进行迭代*******
{  //想把参数fYHBH若干个值  输出
                     System.out.println(i);
            }
提示:只能通过 java.lang.Iterable 的数组或实例进行迭代

jishuang · 发表于 2017-2-23 10:40:29

list迭代就是java标准的，不会可以到网上找案例

lwcompany · 发表于 2017-2-23 14:41:29

动作"/guojinerp/jtzjrbb/process/zjrbb/jcxx/dwtree/updataSkdwPower@Action"的参数"fYHMC"的数据类型"String"与定义的类型"List"不匹配

		自动登录	找回密码
密码			注册

[结贴] 如何把（对话框——列表多选）选择后的值传到数据库中