Package hendrey.orm

Examples of hendrey.orm.Query

196
197
198
199
200
201
202
203
204
205
206
  }

  public int count(Contact filter)
  {
    dbSess.clear();
    Query q = dict.getQuery("byResemblance");
    ShadesORMDictionary.filterCandidate.resembles(filter, orm.getColumnSet("nonKeyFields"));
    Connection con = null;
    try
    {
      return dbSess.count(con = dataSource.getConnection(), q);
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
    }
  }

  public List<String> getUniqueLastNames()
  {
    Query q = dict.getQuery("selectDistinctLastnameOnly");
    RecordSet rs;
    Connection con = null;
    try
    {
      rs = dbSess.executeQuery(con = dataSource.getConnection(), q);
View Full Code Here
56
57
58
59
60
61
62
63
64
    defineQueryforDistinctLastname(orm);
  }

  private static void defineQueryforDistinctLastname(ORMapping orm)
  {
    Query q = QueryFactory.newImmutableQuery("SELECT DISTINCT LASTNAME AS \"CONTACT.LASTNAME\" FROM CONTACT");
    q.candidate(orm).setFetchColumns(new String[] { "LASTNAME" });
    dict.defineQuery("selectDistinctLastnameOnly", q);
  }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
    dict.defineQuery("selectDistinctLastnameOnly", q);
  }

  private static void defineQueryByResemblanceWithFilter(ORMapping orm)
  {
    Query q = QueryFactory.newQuery(dict);
    filterCandidate = q.candidate(orm, "CONTACT");
    q.clause("ORDER BY").append("${order} ${direction} LIMIT ${count} OFFSET ${first}");
    dict.defineQuery("byOrderedResemblance", q);
  }
View Full Code Here
71
72
73
74
75
76
77
78
79
    dict.defineQuery("byOrderedResemblance", q);
  }

  private static void defineQueryByResemblance(ORMapping orm)
  {
    Query q = QueryFactory.newQuery(dict);
    q.candidate(orm, "CONTACT");
    dict.defineQuery("byResemblance", q);
  }
View Full Code Here
78
79
80
81
82
83
84
85
86
    dict.defineQuery("byResemblance", q);
  }

  private static void defineQueryById(ORMapping orm)
  {
    Query q = QueryFactory.newQuery(dict);
    q.candidate(orm).where("ID=${id}", new String[] { });
    dict.defineQuery("byId", q);
  }
View Full Code Here
TOP

Related Classes of hendrey.orm.Query

  • wicket.contrib.phonebook.ShadesContactDao
  • wicket.contrib.phonebook.ShadesORMDictionary
    • 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.