本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.setAlias方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.setAlias方法的具体用法?Java Criteria.setAlias怎么用?Java Criteria.setAlias使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.setAlias方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: testPathExpressionForExtentsAlias
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Test pathExpression and Extents using Alias
*/
public void testPathExpressionForExtentsAlias()
{
ArrayList list = new java.util.ArrayList();
Criteria crit1 = new Criteria();
crit1.setAlias("NAMES");
crit1.addLike("upper(allArticlesInGroup.articleName)", "F%");
Criteria crit2 = new Criteria();
crit2.addGreaterOrEqualThan("allArticlesInGroup.stock", new Integer(110));
crit1.addAndCriteria(crit2);
Query q = QueryFactory.newQuery(ProductGroup.class, crit1, true);
Iterator iter = broker.getIteratorByQuery(q);
while(iter.hasNext())
{
list.add(iter.next());
}
// ProductGroup 4
assertEquals("check size", 1, list.size());
}
示例2: testQueryMN_Alias1
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testQueryMN_Alias1() throws Exception
{
Criteria crit1 = new Criteria();
Criteria crit2 = new Criteria();
QueryByCriteria q;
Collection result;
broker.clearCache();
// get persons working for projects OJB and SODA
crit1.addLike("projects.title", "OJB%");
crit1.setAlias("alias1");
crit2.addLike("projects.title", "SODA%");
crit2.setAlias("alias2");
crit1.addAndCriteria(crit2);
q = QueryFactory.newQuery(Person.class, crit1, true);
result = broker.getCollectionByQuery(q);
assertNotNull(result);
assertTrue(result.size() == 2); // bob, tom
}
示例3: testReportQueryAlias
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Test ReportQuery and Alias
*/
public void testReportQueryAlias()
{
ArrayList list = new java.util.ArrayList();
Criteria crit1 = new Criteria();
crit1.setAlias("NAMES");
crit1.addLike("upper(allArticlesInGroup.articleName)", "F%");
Criteria crit2 = new Criteria();
crit2.setAlias("STOCKS");
crit2.addGreaterOrEqualThan("allArticlesInGroup.stock", new Integer(110));
crit1.addAndCriteria(crit2);
ReportQueryByCriteria q = QueryFactory.newReportQuery(ProductGroup.class, crit1);
q.setAttributes(new String[]{"groupId", "groupName", "STOCKS.allArticlesInGroup.articleName",
"NAMES.allArticlesInGroup.articleName", "NAMES.allArticlesInGroup.stock"});
// Due to AliasPrefixes ArticleName is taken from A2 and A1, Stock from A1,
// SELECT A0.Kategorie_Nr,A0.KategorieName,A2.Artikelname,A1.Artikelname,A1.Lagerbestand FROM
Iterator iter = broker.getReportQueryIteratorByQuery(q);
while(iter.hasNext())
{
list.add(iter.next());
}
// ProductGroup 4 with it's Articles
assertEquals("check size", 1, list.size());
}
示例4: testQueryMN_Alias2
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testQueryMN_Alias2() throws Exception
{
Criteria crit1 = new Criteria();
Criteria crit2 = new Criteria();
QueryByCriteria q;
Collection result1;
Collection result2;
broker.clearCache();
// get persons working for projects OJB (alias should have no effect)
crit1.setAlias("myAlias");
crit1.addLike("firstname", "%o%");
crit1.addLike("projects.title", "OJB%");
q = QueryFactory.newQuery(Person.class, crit1, true);
result1 = broker.getCollectionByQuery(q);
assertNotNull(result1);
assertTrue(result1.size() == 2); // bob, tom
// WITHOUT ALIAS
// get persons working for projects OJB
crit2.addLike("firstname", "%o%");
crit2.addLike("projects.title", "OJB%");
q = QueryFactory.newQuery(Person.class, crit2, true);
result2 = broker.getCollectionByQuery(q);
assertNotNull(result2);
assertTrue(result2.size() == 2); // bob, tom
}
示例5: testSingleAlias
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testSingleAlias() throws Exception
{
try
{
// d1 criteria
Criteria crit1 = new Criteria();
crit1.setAlias("cToD1", "cSet"); // unnecessary, but its use should not
// cause incorrect results
crit1.addEqualTo("cSet.d.dAttrib", new Integer("10010"));
Query query = new QueryByCriteria(B.class, crit1);
Collection allBs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allBs.iterator();
assertEquals(2 * NUM_A, allBs.size());
System.out.println("testSingleAlias() iteration size:" + allBs.size());
while (itr.hasNext())
{
B b = (B) itr.next();
System.out.println("Found B: " + b.getId() + " " + b.getBAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testSingleAlias: " + t.getMessage());
}
}
示例6: testTwoAliasesTwoSegments
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testTwoAliasesTwoSegments() throws Exception
{
try
{
// d1 criteria
Criteria crit1 = new Criteria();
crit1.setAlias("cToD1", "cSet.d");
crit1.addEqualTo("cSet.d.dAttrib", new Integer("10010"));
// d2 criteria
Criteria crit2 = new Criteria();
crit2.setAlias("cToD2", "cSet.d");
crit2.addEqualTo("cSet.d.dAttrib", new Integer("10110"));
crit1.addAndCriteria(crit2);
Query query = new QueryByCriteria(B.class, crit1);
Collection allBs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allBs.iterator();
assertEquals(4 * NUM_A, allBs.size());
System.out.println("testTwoAliasesTwoSegments() iteration size:" + allBs.size());
while (itr.hasNext())
{
B b = (B) itr.next();
System.out.println("Found B: " + b.getId() + " " + b.getBAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testTwoAliasesTwoSegments: " + t.getMessage());
}
}
示例7: testTwoAliasesThreeSegments
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testTwoAliasesThreeSegments() throws Exception
{
try
{
// d1 criteria
Criteria crit1 = new Criteria();
crit1.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10010"));
crit1.setAlias("bToCToD1", "cSet.d");
// d2 criteria
Criteria crit2 = new Criteria();
crit2.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10110"));
crit2.setAlias("bToCToD2", "cSet.d");
crit1.addAndCriteria(crit2);
boolean isDistinct = true;
Query query = new QueryByCriteria(A.class, crit1, true);
Collection allAs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allAs.iterator();
assertEquals(1 * NUM_A, allAs.size());
System.out.println("testTwoAliasesThreeSegments() iteration size:" + allAs.size());
while (itr.hasNext())
{
A a = (A) itr.next();
System.out.println("Found A: " + a.getId() + " " + a.getAAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testTwoAliasesThreeSegments: " + t.getMessage());
}
}
示例8: testPathClassPerCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testPathClassPerCriteria() throws Exception
{
try
{
// C criteria
Criteria crit1 = new Criteria();
crit1.addEqualTo("cSet.cAttrib", new Integer("10200"));
crit1.addPathClass("cSet", C.class);
crit1.setAlias("alias1");
// C1 criteria (subclass of C)
Criteria crit2 = new Criteria();
crit2.addEqualTo("cSet.c1Attrib", new Integer("10001"));
crit2.addPathClass("cSet", C1.class);
crit2.setAlias("alias2");
crit1.addAndCriteria(crit2);
Query query = new QueryByCriteria(B.class, crit1);
Collection allBs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allBs.iterator();
assertEquals(1 * NUM_A, allBs.size());
System.out.println("testPathClassPerCriteria() iteration size:" + allBs.size());
while (itr.hasNext())
{
B b = (B) itr.next();
System.out.println("Found B: " + b.getId() + " " + b.getBAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testPathClassPerCriteria: " + t.getMessage());
}
}
示例9: testPathClassPerQuery
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testPathClassPerQuery() throws Exception
{
try
{
// c1_a criteria
Criteria crit1 = new Criteria();
crit1.addEqualTo("cSet.c1Attrib", new Integer("12001"));
//crit1.addPathClass("cSet", C1.class); // can use 1 query setting instead
crit1.setAlias("alias1");
// c2_b criteria
Criteria crit2 = new Criteria();
crit2.addEqualTo("cSet.c1Attrib", new Integer("12101"));
//crit2.addPathClass("cSet", C1.class); // can use 1 query setting instead
crit2.setAlias("alias2");
crit1.addAndCriteria(crit2);
QueryByCriteria query = new QueryByCriteria(B.class, crit1);
query.addPathClass("cSet", C1.class);
Collection allBs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allBs.iterator();
assertEquals(1 * NUM_A, allBs.size());
System.out.println("testPathClassPerQuery() iteration size:" + allBs.size());
while (itr.hasNext())
{
B b = (B) itr.next();
System.out.println("Found B: " + b.getId() + " " + b.getBAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testPathClassPerQuery: " + t.getMessage());
}
}
示例10: testThreeSegmentsAliasOnSegment2And3
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testThreeSegmentsAliasOnSegment2And3() throws Exception
{
try
{
// d1 criteria
Criteria crit1 = new Criteria();
crit1.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10010"));
crit1.setAlias("bToCToD1", "cSet.d");
// d2 criteria
Criteria crit2 = new Criteria();
crit2.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10110"));
crit2.setAlias("bToCToD2", "cSet.d");
crit1.addAndCriteria(crit2);
boolean isDistinct = true;
Query query = new QueryByCriteria(A.class, crit1, isDistinct);
Collection allAs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allAs.iterator();
assertEquals(1 * NUM_A, allAs.size());
System.out.println("testThreeSegmentsAliasOnSegment2And3() iteration size:" + allAs.size());
while (itr.hasNext())
{
A a = (A) itr.next();
System.out.println("Found A: " + a.getId() + " " + a.getAAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testThreeSegmentsAliasOnSegment2And3: " + t.getMessage());
}
}
示例11: testThreeSegmentsAliasOnSegment2And3UserAlias
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testThreeSegmentsAliasOnSegment2And3UserAlias() throws Exception
{
try
{
UserAlias userAlias1 = new UserAlias("alias1");
userAlias1.add("bSet.cSet");
userAlias1.add("bSet.cSet.d");
// d1 criteria
Criteria crit1 = new Criteria();
crit1.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10010"));
crit1.setAlias(userAlias1);
// d2 criteria
UserAlias userAlias2 = new UserAlias("alias2");
userAlias2.add("bSet.cSet");
userAlias2.add("bSet.cSet.d");
Criteria crit2 = new Criteria();
crit2.addEqualTo("bSet.cSet.d.dAttrib", new Integer("10110"));
crit2.setAlias(userAlias2);
crit1.addAndCriteria(crit2);
boolean isDistinct = true;
Query query = new QueryByCriteria(A.class, crit1, isDistinct);
Collection allAs = broker.getCollectionByQuery(query);
java.util.Iterator itr = allAs.iterator();
assertEquals(1 * NUM_A, allAs.size());
System.out.println("testThreeSegmentsAliasOnSegment2And3UserAlias() iteration size:" + allAs.size());
while (itr.hasNext())
{
A a = (A) itr.next();
System.out.println("Found A: " + a.getId() + " " + a.getAAttrib());
}
}
catch (Throwable t)
{
t.printStackTrace(System.out);
fail("testThreeSegmentsAliasOnSegment2And3UserAlias: " + t.getMessage());
}
}