Package org.jdbf.engine.sql

Examples of org.jdbf.engine.sql.QueryResults

55
56
57
58
59
60
61
62
    selectCriteria.addSelectEqualTo("groupId",0);
    Criteria criteria = new Criteria("product");
    criteria.addSelectLessThan("OID",13);
    selectCriteria.addAndCriteria(criteria);
    selectCriteria.addOrderBy("OID",true);
    QueryResults results = database.select(repositoryViewName,selectCriteria);
    return results; 
    }
View Full Code Here
63
64
65
66
67
68
69
70
   
  public QueryResults selectAll(String repositoryViewName)
    throws QueryException,MappingException,CacheException{
   
   
    QueryResults results = database.select(repositoryViewName,null);
    return results; 
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    public static void main(String[] args) {
      try{
      SelectSample sample = new SelectSample();
      //QueryResults results = sample.selectWithCriteria("product");
      QueryResults results = sample.selectAll("product");
      sample.printQueryResults(results);
     
      }
      catch(Exception e){
        e.printStackTrace();
View Full Code Here
54
55
56
57
58
59
60
61
   
  public QueryResults selectByPrimaryKey(String repositoryViewName,PrimaryKey pk)
      throws QueryException,MappingException,CacheException{
   
     
      QueryResults results = database.selectByPrimaryKey(repositoryViewName,pk);
      return results; 
  }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
     
        CompositePrimaryKeySample sample = new CompositePrimaryKeySample();
        PrimaryKey pk = new PrimaryKey();
        pk.setValueKey("OID",new Integer(1));
        pk.setValueKey("lineId",new Integer(0));
      QueryResults results = sample.selectByPrimaryKey("orderline",pk);
      sample.printQueryResults(results);
      }
      catch(Exception e){
        e.printStackTrace();
      }
View Full Code Here
TOP

Related Classes of org.jdbf.engine.sql.QueryResults

  • CompositePrimaryKeySample
  • SelectSample
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.