Package org.apache.ojb.broker.query

Examples of org.apache.ojb.broker.query.Criteria.addSql()

171
172
173
174
175
176
177
178
179
180
181
        Query q;
        Collection results;
       
        // sql only
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM' and id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
        // sql plus attribute
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM'");
        crit.addEqualTo("id", new Integer(1));
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size2 = results.size();
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        int size2 = results.size();
       
        // attribute plus sql
        crit = new Criteria();
        crit.addEqualTo("upper(firstname)", "TOM");
        crit.addSql("id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size3 = results.size();
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
        Query q;
        Collection results;
       
        // sql only
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM' and id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
        // sql plus attribute
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM'");
        crit.addEqualTo("id",new Integer(1));
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size2 = results.size();
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
        int size2 = results.size();
       
        // attribute plus sql
        crit = new Criteria();
        crit.addEqualTo("upper(firstname)","TOM");
        crit.addSql("id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size3 = results.size();
       
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
        Query q;
        Collection results;
       
        // sql only
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM' and id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
        results = broker.getCollectionByQuery(q);
        int size1 = results.size();
       
        // sql plus attribute
        crit = new Criteria();
        crit.addSql("upper(firstname) = 'TOM'");
        crit.addEqualTo("id", new Integer(1));
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size2 = results.size();
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        int size2 = results.size();
       
        // attribute plus sql
        crit = new Criteria();
        crit.addEqualTo("upper(firstname)", "TOM");
        crit.addSql("id = 1");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        int size3 = results.size();
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.