|
楼主 |
发表于 2016-4-27 10:20:36
|
显示全部楼层
已解决,请结贴
在执行删除前重建table来删除就可以了。
Iterator<Row> it = table.iterator();
while (it.hasNext()){
Row r = it.next();
Object v = r.getValue("fHM");
Object i = r.getValue("fZS");
v.toString();
int zs = Integer.parseInt(String.valueOf(i));
String bselecthm = "select SC_HMB.* from SC_HMB SC_HMB ";
String bfilterhm = "where SC_HMB.fZBID = '" + xzid + "' ";
String bksqlhm = bselecthm + bfilterhm ;
Table tablehm = KSQL.select(bksqlhm,null,"/sc/sc/data",null);
tablehm.getMetaData().setKeyColumn("fHM");
tablehm.deleteRows(v);
tablehm.save("/sc/sc/data"); } |
|