/** * Test group by with entity. */ private void testGroupByWithEntity() { String queryString = "Select p from Person p where p.age < 20 group by p.age"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(1, resultList.size()); Person person = (Person) (resultList.get(0)); Assert.assertEquals("5", person.getPersonId()); Assert.assertEquals("AK", person.getPersonName()); Assert.assertEquals(10, person.getAge().intValue()); Assert.assertEquals(500.0, person.getSalary()); }
/** * Test having with entity. */ private void testHavingWithEntity() { String queryString = "Select p from Person p where p.age < 40 group by p.age having max(p.salary) > 600"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(1, resultList.size()); Person person = (Person) (resultList.get(0)); Assert.assertEquals("7", person.getPersonId()); Assert.assertEquals("KPM", person.getPersonName()); Assert.assertEquals(30, person.getAge().intValue()); Assert.assertEquals(700.0, person.getSalary()); }
/** * Assert person. * * @param actual * the actual * @param person * the person */ private void assertPerson(Object actual, Person person) { Person actualPerson = (Person) actual; Assert.assertEquals(actualPerson.getPersonId(), person.getPersonId()); Assert.assertEquals(actualPerson.getPersonName(), person.getPersonName()); Assert.assertEquals(actualPerson.getAge().intValue(), person.getAge().intValue()); Assert.assertEquals(actualPerson.getSalary(), person.getSalary()); Assert.assertEquals(actualPerson.getDay(), person.getDay()); }
allPersons = findQuery.getResultList(); Assert.assertEquals(1, allPersons.size()); Assert.assertEquals("p2", allPersons.get(0).getPersonId()); Assert.assertEquals(new Integer(24), allPersons.get(0).getAge()); allPersons = findQuery.getResultList(); Assert.assertEquals(1, allPersons.size()); Assert.assertEquals("p1", allPersons.get(0).getPersonId()); Assert.assertEquals(new Integer(32), allPersons.get(0).getAge());
/** * Comparator implementation which sorts Person objects on person_id field */ public class SortByPerson_ID implements Comparator{ public int compare(Object o1, Object o2) { Person p1 = (Person) o; Person p2 = (Person) o; return p1.getPersonId() - p2.getPersonId(); } }
List<Long> personIds = Collection2.transform(persons, new Function<Person,Long>(){ @Override public Long apply(@Nullable Person person) { return person.getPersonId(); } });
@Test public void test() { Person p = new Person(); SearchResult result = new SearchResult(); result.setPrimaryKey(p.getPersonId()); result.setEmbeddedColumnName("none"); result.addEmbeddedColumnValue("embeddedcolumn1"); result.addEmbeddedColumnValue("embeddedcolumn2"); Assert.assertNull(result.getPrimaryKey()); Assert.assertNotNull(result.getEmbeddedColumnName()); Assert.assertNotNull(result.getEmbeddedColumnValues()); Assert.assertEquals(2,result.getEmbeddedColumnValues().size()); }
List<String> personIds=new ArrayList<>(); for(Person p: persons){ // Iterate over persons List if(p.getPersonId()!=null){ //Check the personId from Person personIds.add(p.getPersonId()); } }
List<Long> ids = new ArrayList(people.size()); for(Person p : people) id.add(p.getPersonId());
Person obj = (Person) it.next(); System.out.println(obj.getPersonId());