Examples of org.jdbf.engine.criteria.Criteria

org.jdbf.engine.criteria.Criteria
Criteria represents the condition that can be added to WHERE keyword in sql statement.
To add a criteria, you must invoke addXXX where XXX is the condition i.e. addSelectGreaterThan(propertyName,value) add "propertyName > value" to sql statement.
To add nested condition you must invoke your method addXXX and then you invoke addOrCriteria or addAndCriteria.
@author Giovanni Martone
@version $Revision: 1.8 $
last changed by $Author: gmartone $

    public Criteria createClauseOnPk(String repositoryName,RepositoryView view,
                       PrimaryKey primaryKey) {


        PrimaryKeyMap pk = view.getBeanDescriptor().getPrimaryKeyMap();
        ArrayList keys = (ArrayList) pk.getPrimaryKey();
        Criteria criteria = new Criteria(repositoryName);


        for (int i = 0; i < keys.size(); i++) {


            Criteria internal = null;
            if (i > 0)
                internal = new Criteria(repositoryName);


            ItemDescriptor item = (ItemDescriptor) keys.get(i);
            Object value = primaryKey.getValueKey(item.getPropertyName());
            String columnName = item.getPropertyName();


            if (i == 0)
                criteria.addSelectEqualTo(columnName, value);
            else
                internal.addSelectEqualTo(columnName, value);


            if (i > 0)
                criteria.addAndCriteria(internal);
        }
        return criteria;

View Full Code Here

   */
    protected Criteria createClauseOnPk(String repositoryName,RepositoryView view){
    
    PrimaryKeyMap pk = view.getBeanDescriptor().getPrimaryKeyMap();      
    ArrayList keys = (ArrayList)pk.getPrimaryKey();  
    Criteria criteria = new Criteria(repositoryName);
  
    for(int i = 0; i < keys.size(); i++){
    
      Criteria internal = null;
      if(i > 0)
        internal = new Criteria(repositoryName);        
      
      ItemDescriptor item = (ItemDescriptor)keys.get(i);
      
      String columnName = item.getPropertyName();
    
      if(i == 0)
        criteria.addSelectEqualTo(columnName,new Character('?'));
      else           
        internal.addSelectEqualTo(columnName,new Character('?'));
    
      if(i > 0)
        criteria.addAndCriteria(internal);                     
    }

View Full Code Here

TOP

Related Classes of org.jdbf.engine.criteria.Criteria

org.jdbf.engine.mapping.ItemDescriptor

org.jdbf.engine.repository.RepositoryView

org.jdbf.engine.sql.SelectStatement

org.jdbf.engine.sql.SQLStatement

java.util.List

java.util.ArrayList

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.