/** * Test parameter query. */ private void testParameterQuery() { String queryString = "Select p from Person p where p.personName = :personName"; Query query = em.createQuery(queryString); query.setParameter("personName", "amit"); List resultList = query.getResultList(); Assert.assertEquals(1, resultList.size()); Assert.assertEquals(100.0, ((Person) resultList.get(0)).getSalary()); }
/** * 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()); }
/** * Test order by asc multiple fields. */ private void testOrderByASCMultipleFields() { String queryString = "Select p.personName, p.age, p.salary from Person p where p.salary <> 300.0 order by p.age ASC"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(3, resultList.size()); Assert.assertEquals("pragalbh", (((Person) resultList.get(0)).getPersonName())); Assert.assertEquals(20, ((Person) resultList.get(0)).getAge().intValue()); Assert.assertEquals(700.0, ((Person) resultList.get(0)).getSalary()); Assert.assertEquals("dev", ((Person) resultList.get(1)).getPersonName()); Assert.assertEquals(40, ((Person) resultList.get(1)).getAge().intValue()); Assert.assertEquals(400.0, ((Person) resultList.get(1)).getSalary()); Assert.assertEquals("karthik", ((Person) resultList.get(2)).getPersonName()); Assert.assertEquals(50, ((Person) resultList.get(2)).getAge().intValue()); Assert.assertEquals(500.0, ((Person) resultList.get(2)).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()); }
class SoccerTeam { private final List<Person> members = new ArrayList<>(); private double budget = 0.0; public void setBudget(double budget) { this.budget = budget; } public void addMember(Person member) { members.add(member); budget -= member.getSalary(); } public boolean isBroke() { return budget < 0; } }
if(action.equals("Save Person List")) { f1 = new File("PersonList.txt"); if(f1.exists()) { f1.delete(); f1 = new File("PersonList.txt"); } try { fWriter = new FileWriter(f1, false); } catch (IOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } pWriter = new PrintWriter(fWriter, true); for(Person p: pList) { pWriter.println(p.getFName()); pWriter.println(p.getLName()); pWriter.println(p.getPNo()); pWriter.println(p.getSalary()); } JOptionPane.showMessageDialog(null, "Person List Stored in File 'PersonList.txt'"); }