Package org.nutz.dao.util.cri

Examples of org.nutz.dao.util.cri.SimpleCriteria

77
78
79
80
81
82
83
  public static Cnd where(SqlExpression e) {
    return new Cnd(e);
  }

  public static SimpleCriteria cri() {
    return new SimpleCriteria();
  }
View Full Code Here
89
90
91
92
93
94
95
  /*------------------------------------------------------------------*/

  private SimpleCriteria cri;

  Cnd() {
    cri = new SimpleCriteria();
  }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    assertEquals("pet6", pets.get(0).getName());
  }

  @Test
  public void query_by_like_ignorecase() {
    SimpleCriteria cri = Cnd.cri();
    cri.where().andLike("name", "PeT6", true);
    List<Pet> pets = dao.query(Pet.class, cri, dao.createPager(1, 10));
    assertEquals(1, pets.size());
    assertEquals("pet6", pets.get(0).getName());
  }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
    }

  }

  public Condition createCondition(Object host) {
    SimpleCriteria cri = Cnd.cri();
    cri.where().andInBySql(  linkedField.getColumnName(),
                "SELECT %s FROM %s WHERE %s=%s",
                toColumnName,
                this.getRelationName(),
                fromColumnName,
                Sqls.formatFieldValue(hostField.getValue(host)));
View Full Code Here
79
80
81
82
83
84
85
    public static Cnd where(SqlExpression e) {
        return new Cnd(e);
    }

    public static SimpleCriteria cri() {
        return new SimpleCriteria();
    }
View Full Code Here
95
96
97
98
99
100
101
    /*------------------------------------------------------------------*/

    private SimpleCriteria cri;

    Cnd() {
        cri = new SimpleCriteria();
    }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
        assertEquals("pet6", pets.get(0).getName());
    }

    @Test
    public void query_by_like_ignorecase() {
        SimpleCriteria cri = Cnd.cri();
        cri.where().andLike("name", "PeT6", true);
        List<Pet> pets = dao.query(Pet.class, cri, dao.createPager(1, 10));
        assertEquals(1, pets.size());
        assertEquals("pet6", pets.get(0).getName());
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
        }

    }

    public Condition createCondition(Object host) {
        SimpleCriteria cri = Cnd.cri();
        cri.where().andInBySql(    linkedField.getColumnName(),
                                "SELECT %s FROM %s WHERE %s=%s",
                                toColumnName,
                                this.getRelationName(),
                                fromColumnName,
                                Sqls.formatFieldValue(hostField.getValue(host)));
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
        assertEquals("pet6", pets.get(0).getName());
    }

    @Test
    public void query_by_like_ignorecase() {
        SimpleCriteria cri = Cnd.cri();
        cri.where().andLike("name", "PeT6", true);
        List<Pet> pets = dao.query(Pet.class, cri, dao.createPager(1, 10));
        assertEquals(1, pets.size());
        assertEquals("pet6", pets.get(0).getName());
    }
View Full Code Here
203
204
205
206
207
208
209
210
211
212
213
214
        assertEquals("pet6", pets.get(0).getName());
    }

    @Test
    public void each_by_like_ignorecase() {
        SimpleCriteria cri = Cnd.cri();
        cri.where().andLike("name", "PeT6", true);
        final List<Pet> pets = new ArrayList<Pet>();
        dao.each(Pet.class, cri, dao.createPager(1, 10), new Each<Pet>() {
            public void invoke(int i, Pet pet, int length) {
                pets.add(pet);
            }
View Full Code Here
TOP

Related Classes of org.nutz.dao.util.cri.SimpleCriteria

  • org.nutz.dao.Cnd
  • org.nutz.dao.impl.entity.field.ManyManyLinkField
  • org.nutz.dao.pager.Pager
  • org.nutz.dao.test.normal.EachTest
  • org.nutz.dao.test.normal.QueryTest
    • 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.