当前位置: 首页>>代码示例>>Java>>正文


Java Criteria.setAlias方法代码示例

本文整理汇总了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());
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:27,代码来源:QueryTest.java

示例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
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:22,代码来源:QueryTest.java

示例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());
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:33,代码来源:QueryTest.java

示例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

}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:32,代码来源:QueryTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:31,代码来源:PathTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:37,代码来源:PathTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:38,代码来源:PathTest.java

示例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());
     }
 }
 
开发者ID:KualiCo,项目名称:ojb,代码行数:39,代码来源:PathTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:40,代码来源:PathTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:38,代码来源:PathTest.java

示例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());
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:46,代码来源:PathTest.java


注:本文中的org.apache.ojb.broker.query.Criteria.setAlias方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。