1、案例一： Sql語句拼接

    # Sql語句拼接
    StringBuffer sql = new StringBuffer();
    sql.append(" update t_rpt_Template set");
    sql.append(" FVersionStatus= ?,");
    sql.append(" FPublishedStatus= ?");
    sql.append(" where fnumber = ?");
    sql.append(" and ftemplateType = ?");
    sql.append(" and fid <> ?");
    List params = new ArrayList();
    params.add(new Integer(2));
    params.add(new Integer(2));
    params.add(templateInfo.getNumber());
    params.add(Integer.valueOf(templateInfo.getTemplateType().getValue()));
    params.add(templateInfo.getId().toString());
    DbUtil.execute(ctx, sql.toString(), params.toArray());

**2、案例二： TemplateControllerBeanEx 擴(kuò)展類中 **

SelectorItemCollection sic = new SelectorItemCollection();
sic.add(new SelectorItemInfo("startdate"));
sic.add(new SelectorItemInfo("lastupdatetime"));
sic.add(new SelectorItemInfo("lastupdateuser.id"));
sic.add(new SelectorItemInfo("lastupdateuser.number"));    
sic.add(new SelectorItemInfo("isgroup"));
TemplateInfo template = getTemplateInfo(ctx, pkid, sic);

---未完待續(xù)