programmatic view object example

gistfile1.txt

public class UserTrVOImpl extends ViewObjectImpl {
    /**
     * This is the default constructor (do not remove).
     */
    public UserTrVOImpl() {
    }
    private int resultSize=0;
    protected Iterator<User> userIterator;
    private boolean inExecuteEmptyRowSet = false;

      @Override
      public void executeEmptyRowSet() {
          try {
              inExecuteEmptyRowSet = true;
              super.executeEmptyRowSet();
          }
          finally {
              inExecuteEmptyRowSet = false;
          }
          
      }  
    protected void create() {
       getViewDef().setQuery(null);
        getViewDef().setSelectClause(null);
        setQuery(null);
        setManageRowsByKey(true);
    }

    /**
     * This method is overridden to retrieve the filtered data and populate the query collection
     * @param qc
     * @param params
     * @param numUserParams
     */
    protected void executeQueryForCollection(Object qc, Object[] params,
                                             int numUserParams) {
        if(!inExecuteEmptyRowSet){
        List<User> searchedUsers = fetchDataForCriteria(getbUserId());
        if (searchedUsers != null) {
            setUserIterator(searchedUsers.iterator());
            setUserDataForCollection(qc, searchedUsers);
            resultSize=searchedUsers.size();
        }
        else{
            resultSize=0;
            }
        }
        super.executeQueryForCollection(qc, params, numUserParams);
    }

    /**
     * hasNextForCollection - overridden for custom java data source support.
     */
    protected boolean hasNextForCollection(Object qc) {
        if ((getUserIterator() != null) && (getUserIterator().hasNext())) {
            return true;
        } else {
            setFetchCompleteForCollection(qc, true);
            return false;
        }
    }

    @Override
    public long getQueryHitCount(ViewRowSetImpl viewRowSetImpl) {
//        if(resultSize!=0)
//        {
//            return resultSize;
//        }
//        else{
            return viewRowSetImpl.getRowCount();
//            }

    }

    /**
     * createRowFromResultSet - overridden for custom java data source support.
     */
    protected ViewRowImpl createRowFromResultSet(Object qc,
                                                 ResultSet resultSet) {

      
        if (getUserIterator() != null && getUserIterator().hasNext()) {
            ViewRowImpl row = createNewRowForCollection(qc);
            User userObj = getUserIterator().next();
            populateAttributeForRow(row, 0, userObj.getDisplayName());
            if (userObj.getMobiles() != null && !userObj.getMobiles().isEmpty()) {
                populateAttributeForRow(row, 1, userObj.getMobiles().get(0));
            }
            if (userObj.getEmails() != null && !userObj.getEmails().isEmpty()) {
                populateAttributeForRow(row, 2, userObj.getEmails().get(0));
            }
            Address add = userObj.getAddress();
            populateAttributeForRow(row, 4,
                                    DateUtilities.parseAndGetDate(userObj.getBeginDate(),
                                                                  null));
            populateAttributeForRow(row, 5,
                                    DateUtilities.parseAndGetDate(userObj.getBeginLockDate(),
                                                                  null));
            populateAttributeForRow(row, 6, userObj.getDayMask());
            populateAttributeForRow(row, 7, userObj.getDescription());
            populateAttributeForRow(row, 8, userObj.getEmployeeType());
            populateAttributeForRow(row, 9,
                                    DateUtilities.parseAndGetDate(userObj.getEndDate(),
                                                                  null));
            populateAttributeForRow(row,10,userObj.isLocked());
            populateAttributeForRow(row, 11, userObj.getUserId());
            populateAttributeForRow(row, 12, userObj.getPassword());
            populateAttributeForRow(row, 13, userObj.getOu());
            populateAttributeForRow(row, 14, userObj.getPwPolicy());
            populateAttributeForRow(row, 15, userObj.getTitle());
            populateAttributeForRow(row, 16, userObj.getSn());
            populateAttributeForRow(row, 17, userObj.getCn());
            if (add != null) {
                if(add.getAddresses()!=null&&!add.getAddresses().isEmpty()){
                populateAttributeForRow(row, 3,add.getAddresses().get(0) );
                }
                populateAttributeForRow(row, 18, add.getDepartmentNumber());
                populateAttributeForRow(row, 19, add.getRoomNumber());
                populateAttributeForRow(row, 20, add.getBuilding());
                populateAttributeForRow(row, 21, add.getCity());
                populateAttributeForRow(row, 22, add.getState());
                populateAttributeForRow(row, 23, add.getCountry());
                populateAttributeForRow(row, 24, add.getPostOfficeBox());
                populateAttributeForRow(row, 25, add.getPostalCode());
            }
            //TODO flex fields retrieval and stuff
            populateAttributeForRow(row, 26, userObj.getProperty("Flex1"));
            populateAttributeForRow(row, 27, userObj.getProperty("Flex2"));
            populateAttributeForRow(row, 28, userObj.getProperty("Flex3"));
            populateAttributeForRow(row, 29, userObj.getProperty("Flex4"));
            populateAttributeForRow(row, 30, userObj.getProperty("Flex5"));
            populateAttributeForRow(row, 31, userObj.getProperty("Flex6"));
            populateAttributeForRow(row, 32, userObj.getProperty("Flex7"));
            populateAttributeForRow(row, 33, userObj.getProperty("Flex8"));
            populateAttributeForRow(row, 34,
                                    DateUtilities.parseAndGetDate(userObj.getEndLockDate(),
                                                                  null));
            populateAttributeForRow(row, 35, userObj.getBeginTime());
            populateAttributeForRow(row, 36, userObj.getEndTime());
            if (userObj.getPhones() != null && !userObj.getPhones().isEmpty()) {
                populateAttributeForRow(row, 37, userObj.getPhones().get(0));
            }
            
            populateAttributeForRow(row, 38, userObj.getPassword());
            populateAttributeForRow(row, row.getAttributeIndexOf("Dn"), userObj.getDn());
       return row;
           
        }

        return null;

    }

    /**
     * Fetches the list of users matchin the bind parameter
     * @param params
     * @return
     */
    private List<User> fetchDataForCriteria(String userId) {
        List<User> users = null;
        LDAPOperations ops = new LDAPOperations();
        if (userId != null) {
         users = ops.searchUsers(userId);
            if (users == null || users.isEmpty()) {
                throw new JboException("User not Found");
            }
            return users;
        } else {
            return null;
        }


    }

    public void setUserIterator(Iterator<User> userIterator) {
        this.userIterator = userIterator;
    }

    public Iterator<User> getUserIterator() {
        return userIterator;
    }

    /**
     * Returns the bind variable value for bUserId.
     * @return bind variable value for bUserId
     */
    public String getbUserId() {
        return (String)getNamedWhereClauseParam("bUserId");
    }

    /**
     * Sets <code>value</code> for bind variable bUserId.
     * @param value value to bind as bUserId
     */
    public void setbUserId(String value) {
        setNamedWhereClauseParam("bUserId", value);
    }


}

I am not getting the value of Binding variable. Can you explain, how did you create it?