本文整理了Java中javax.persistence.criteria.Root.alias方法的一些代码示例，展示了Root.alias的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Root.alias方法的具体详情如下：
包路径：javax.persistence.criteria.Root
类名称：Root
方法名：alias

Root.alias介绍

暂无

代码示例

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithWhereClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\"";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.equal(from.get("personName"), "vivek"));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithoutWhereClause()
{
  String expected = "Select p from Person p";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  // Check for multi column select
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age = 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.equal(from.get("age"), 32)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

protected <E extends Object> void assertFindByNameAndAge(EntityManager em, Class clazz, E e, String name,
    String minVal, String fieldName)
{
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
  Root<E> from = query.from(clazz);
  query.select(from.alias("p"));
  query.where(criteriaBuilder.and(criteriaBuilder.equal(from.get(fieldName), name),
      criteriaBuilder.gt((Expression) from.get("age"), Integer.parseInt(minVal))));
  TypedQuery<E> q = em.createQuery(query);
  List<E> results = q.getResultList();
  Assert.assertNotNull(results);
  Assert.assertFalse(results.isEmpty());
  Assert.assertEquals(2, results.size());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithBTWClause()
{
  String expected = "Select p from Person p where p.age BETWEEN 10 AND 20";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.between((Expression) from.get("age"), 10, 20));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithMultiANDClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age = 32 AND p.salary = 3200.01";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.equal(from.get("age"), 32), criteriaBuilder.equal(from.get("salary"), 3200.01)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testCountClause()
{
  String expected = "Select Count(p) from Person p";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Long> personQuery = criteriaBuilder.createQuery(Long.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(criteriaBuilder.count((Expression<?>) from.alias("p")));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithORClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" OR p.age = 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.or(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.equal(from.get("age"), 32)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testCountWithWhereClause()
{
  String expected = "Select Count(p) from Person p where p.personName = \"vivek\" AND p.age = 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Long> personQuery = criteriaBuilder.createQuery(Long.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(criteriaBuilder.count((Expression<?>) from.alias("p")));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.equal(from.get("age"), 32)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDLTClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" OR p.age < 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.or(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.lt((Expression) from.get("age"), new Integer(32))));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithORLTEClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" OR p.age <= 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.or(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.le((Expression) from.get("age"), new Integer(32))));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

protected <E extends Object> void assertFindByNameAndAgeBetween(EntityManager em, Class clazz, E e, String name,
    String minVal, String maxVal, String fieldName)
{
  // // find by between clause
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
  Root<E> from = query.from(clazz);
  query.select(from.alias("p"));
  query.where(criteriaBuilder.and(
      criteriaBuilder.equal(from.get(fieldName), name),
      criteriaBuilder.between((Expression) from.get("age"), Integer.parseInt(minVal),
          Integer.parseInt(maxVal))));
  TypedQuery<E> q = em.createQuery(query);
  List<E> results = q.getResultList();
  Assert.assertNotNull(results);
  Assert.assertFalse(results.isEmpty());
  Assert.assertEquals(2, results.size());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDBTWClause()
{
  String expected = "Select p from Person p where p.personName = \"'vivek'\" AND p.age BETWEEN 10 AND 20";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "'vivek'"),
      criteriaBuilder.between((Expression) from.get("age"), 10, 20)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDGTClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age > 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.gt((Expression) from.get("age"), new Integer(32))));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDGTEClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age >= 32";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.ge((Expression) from.get("age"), new Integer(32))));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

protected <E extends Object> void assertFindByNameAndAgeGTAndLT(EntityManager em, Class clazz, E e, String name,
    String minVal, String maxVal, String fieldName)
{
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
  Root<E> from = query.from(clazz);
  query.select(from.alias("p"));
  query.where(criteriaBuilder.and(criteriaBuilder.equal(from.get(fieldName), name),
      criteriaBuilder.gt((Expression) from.get("age"), Integer.parseInt(minVal)),
      criteriaBuilder.lt((Expression) from.get("age"), Integer.parseInt(maxVal))));
  // // // find by name, age clause
  TypedQuery<E> q = em.createQuery(query);
  List<E> results = q.getResultList();
  Assert.assertNotNull(results);
  Assert.assertFalse(results.isEmpty());
  Assert.assertEquals(1, results.size());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testOrderByClause()
{
  String expected = "Select p from Person p ORDER BY p.personName DESC";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  // Check for multi column select
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.orderBy(criteriaBuilder.desc(from.get("personName")));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testWithANDGTLTClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age > 32 AND p.salary <= 3200.01";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.gt((Expression) from.get("age"), 32),
      criteriaBuilder.le((Expression) from.get("salary"), 3200.01)));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testOrderByWithCompositeClause()
{
  final String expected = "Select u from PersonnelEmbedded u where u.personalDetail.phoneNo = 91234567 ORDER BY u.personalDetail.emailId ASC";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<PersonnelEmbedded> embedQuery = criteriaBuilder.createQuery(PersonnelEmbedded.class);
  Root<PersonnelEmbedded> from = embedQuery.from(PersonnelEmbedded.class);
  embedQuery.select(from.alias("u"));
  embedQuery.orderBy(criteriaBuilder.asc(from.get("personalDetail").get("emailId")));
  embedQuery.where(criteriaBuilder.equal(from.get("personalDetail").get("phoneNo"), "91234567"));
  String actual = CriteriaQueryTranslator.translate(embedQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}

代码示例来源：origin: Impetus/Kundera

@Test
public void testOrderByWithWhereClause()
{
  String expected = "Select p from Person p where p.personName = \"vivek\" AND p.age > 32 AND p.salary <= 3200.01 ORDER BY p.personName DESC";
  CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
  CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
  Root<Person> from = personQuery.from(Person.class);
  personQuery.select(from.alias("p"));
  personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "vivek"),
      criteriaBuilder.gt((Expression) from.get("age"), 32),
      criteriaBuilder.le((Expression) from.get("salary"), 3200.01)));
  personQuery.orderBy(criteriaBuilder.desc(from.get("personName")));
  String actual = CriteriaQueryTranslator.translate(personQuery);
  Assert.assertEquals(expected.trim(), actual.trim());
}