~~~ @Test public void test1(){ EntityManager em = JpaUtils.getEntityManager(); EntityTransaction tx = em.getTransaction(); tx.begin(); // 查詢全部 //String sql = "from com.test.domain.Customer"; //排序 //String sql = "from Customer order by id desc"; //統計 //String sql = "select count(id) from Customer "; //分頁 String sql = "from Customer where name like ? "; // 創建Query查詢對象 Query query = em.createQuery(sql); query.setParameter(0, "test1"); //分頁 //query.setFirstResult(0); //query.setMaxResults(2); List list = query.getResultList(); for (Object obj : list){ System.out.println(obj.toString()); } tx.commit(); em.close(); } ~~~