查询全部
@Test
public void testFindAll(){
EntityManager entityManager = JpaUtils.getEntityManager();
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
String jpql = "from com.leewle.domain.Customer";
Query query = entityManager.createQuery(jpql);
List<Customer> list = query.getResultList();
for(Customer customer:list){
System.out.println(customer);
}
entityManager.close();
}
分页查询
@Test
public void testPage(){
EntityManager entityManager = JpaUtils.getEntityManager();
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
String jpql = "from Customer";
Query query = entityManager.createQuery(jpql);
query.setFirstResult(0);
query.setMaxResults(2);
List<Customer> list = query.getResultList();
for(Customer customer:list){
System.out.println(customer);
}
entityManager.close();
}
条件查询
@Test
public void testCondition(){
EntityManager entityManager = JpaUtils.getEntityManager();
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
String jpql = "from Customer where custId = ?";
Query query = entityManager.createQuery(jpql);
query.setParameter(1,1l);
Customer customer = (Customer) query.getSingleResult();
System.out.println(customer);
entityManager.close();
}
排序查询
@Test
public void testFindAllDesc(){
EntityManager entityManager = JpaUtils.getEntityManager();
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
String jpql = "from com.leewle.domain.Customer order by custId DESC";
Query query = entityManager.createQuery(jpql);
List<Customer> list = query.getResultList();
for(Customer customer:list){
System.out.println(customer);
}
entityManager.close();
}
统计查询
@Test
public void testCount(){
EntityManager entityManager = JpaUtils.getEntityManager();
EntityTransaction tx = entityManager.getTransaction();
tx.begin();
String jpql = "select count(custId) from Customer";
Query query = entityManager.createQuery(jpql);
Long count = (Long) query.getSingleResult();
System.out.println(count);
entityManager.close();
}