adf 自定义重复查询例子

需求：某字段保存前，需查询数据库中是否有重复记录。

页面代码：

<af:inputText value="#{row.bindings.ResCode.inputValue}"
                                label="#{bindings.OsmResourceTree1.hints.ResCode.label}"
                                columns="#{bindings.OsmResourceTree1.hints.ResCode.displayWidth}"
                                id="it1" autoSubmit="true"
                                validator="#{pageFlowScope.OsmResourceTree.validateResCode}"
                    <f:validator binding="#{row.bindings.ResCode.validator}"/>
                  </af:inputText>

Backing Bean代码：

  public void validateResCode(FacesContext facesContext,
                              UIComponent uIComponent, Object object) {
    // Add event code here...
    String id = this.getELExpressionValue("#{row.bindings.Id.inputValue}").toString();
    String code = object == null ? "" : object.toString();
        
    if(!code.equalsIgnoreCase("")){
      String whereClause = " id != '"+id+"' and Res_Code = '"+code+"' ";

      //以下为查询重复的项目特有方法，需根据项目实际情况修改。

      Object result = PMSUtils.getAttributeByWhereClause(whereClause, "AMOsmResourceDataControl", "OsmResource_RVO1","ResName");
      if(result!=null && !result.toString().equalsIgnoreCase("")){
            throw new ValidatorException(
                      new FacesMessage( FacesMessage.SEVERITY_ERROR,
                                       "资源编码已存在,同编码资源名称为:“"+result.toString()+"”,请修改后保存！",null));
      }
    }
  }