Package org.odbms

Examples of org.odbms.Query.constrain()

42
43
44
45
46
47
48
49
50
51
52
    System.out.println("-----------------------------------------");

    // 2. query with Iterator
    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, searchFor);
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "live");
    q2.constrain("DYEAR", OP.RANGE, 2000, 2002);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "BLUES");
    discs = q2.execute();

    Iterator<Disc> iter = discs.iterator();
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    // 2. query with Iterator
    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, searchFor);
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "live");
    q2.constrain("DYEAR", OP.RANGE, 2000, 2002);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "BLUES");
    discs = q2.execute();

    Iterator<Disc> iter = discs.iterator();
    while (iter.hasNext()) {
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    // 2. query with Iterator
    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, searchFor);
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "live");
    q2.constrain("DYEAR", OP.RANGE, 2000, 2002);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "BLUES");
    discs = q2.execute();

    Iterator<Disc> iter = discs.iterator();
    while (iter.hasNext()) {
      Disc disc = iter.next();
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
   * @param searchFor
   */
  public void testSorted()
  {
    Query q1 = db.query(Disc.class);
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "the");
    q1.constrain("DYEAR", OP.RANGE, 2000, 2009);

    q1.sortBy("DTITLE");
    q1.sortBy("DGENRE");
    q1.sortByDescending("DYEAR");
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
   */
  public void testSorted()
  {
    Query q1 = db.query(Disc.class);
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "the");
    q1.constrain("DYEAR", OP.RANGE, 2000, 2009);

    q1.sortBy("DTITLE");
    q1.sortBy("DGENRE");
    q1.sortByDescending("DYEAR");

View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.