查询 where .. in ..
/**
* 设置学生基本信息表的注册状态,以及注册时间
* @param zt
* @param idArr
* @date 2017-11-16
*/
public void sync(String zt, String[] idArr) {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String date = ZT_TWO.equals(zt) ? df.format(new Date()) : "";
XsxxglXsjbxxViewImpl xsVo =
(XsxxglXsjbxxViewImpl)ADFUtils.findIterator("XsxxglXsjbxxView1Iterator").getViewObject();
ViewCriteria vc = xsVo.createViewCriteria();
vc.setName("xsvc");
ViewCriteriaRow vcr = vc.createViewCriteriaRow();
ViewCriteriaItem item = vcr.ensureCriteriaItem("Xsid");
item.setOperator(JboCompOper.OPER_IN);
for (int i = 0; i < idArr.length; i++) {
item.setValue(i, idArr[i]);
}
vc.addElement(vcr);
xsVo.applyViewCriteria(vc);
xsVo.setRangeSize(-1);
xsVo.executeQuery();
Row[] xsArr = xsVo.getAllRowsInRange();
xsVo.removeViewCriteria("xsvc");
xsVo.reset();
for (Row xsRow : xsArr) {
xsRow.setAttribute("Zczt", zt);
xsRow.setAttribute("Zcsj", date);
}
}
2.在绑定层绑定其它模块的VO迭代器(需要导JAR包)进行查询。
/**
* Container's getter for XtglBmgzmbView1.
* @return XtglBmgzmbView1
*/
public XtglBmgzmbViewImpl getXtglBmgzmbView1() {
return (XtglBmgzmbViewImpl)findViewObject("XtglBmgzmbView1");
}
public Boolean isJgh() {
XtglBmgzmbViewImpl bmgzVo = getXtglBmgzmbView1();
bmgzVo.setWhereClause("Bmgzbh=:p_bh");
bmgzVo.defineNamedWhereClauseParam("p_bh", null, null);
bmgzVo.setNamedWhereClauseParam("p_bh", "003");
bmgzVo.executeQuery();
Row row = bmgzVo.first();
bmgzVo.removeNamedWhereClauseParam("p_bh"); //清空
String sfqy = (String)row.getAttribute("Sfqy");
return "1".equals(sfqy);
}