Jpal

//查询所有员工
@Test
public void testQuery1()throws Exception{
EntityManager entityManager = JpaUtils.getEntityManager();
String jpql = “select o from Employee o”;
Query query = entityManager.createQuery(jpql);
List employees = query.getResultList();
for (Employee employee : employees) {
System.out.println(employee);
}
}

//查询所有员工的姓名和所属部门名称
@Test
public void testQuery2()throws Exception{
EntityManager entityManager = JpaUtils.getEntityManager();
== String jpql = “select o.name,o.department.name from Employee o”;==
Query query = entityManager.createQuery(jpql);
List<Object[]> objects = query.getResultList();
for (Object[] obj : objects) {
System.out.println(Arrays.toString(obj));
}
}

//2.2.3.查询出所有在 成都 和 广州工作的 员工【查询结果过滤】
@Test
public void testQuery3()throws Exception{
EntityManager entityManager = JpaUtils.getEntityManager();
String jpql = “select o from Employee o where o.department.city=? or o.department.city=?”;
Query query = entityManager.createQuery(jpql);
query.setParameter(1, “成都”).setParameter(2, “广州”);

    List<Employee> resultList = query.getResultList();
    resultList.forEach(e->{
        System.out.println(e);
    });
}

查询时基本只需要修改jpql语句就可以了；
可以翻文档，百度等等。