@Test
public void testNamedQuery(){
Query query = entityManager.createNamedQuery("testNamedQuery").setParameter(1, 1);
Customer customer =(Customer) query.getSingleResult();
System.out.println(customer);
}
@Test
public void testNativeQuery(){
String sql="select lastname from customers where age>?";
Object result = entityManager.createNativeQuery(sql).setParameter(1, 120).getSingleResult();
System.out.println(result);
}
@Test
public void testJPQL(){
String jpql="select new Customer(c.lastname,c.age) from Customer c where age>?";
List list=entityManager.createQuery(jpql).setParameter(1, 1).getResultList();
System.out.println(list);
}
JPA-jqpl
最新推荐文章于 2023-04-14 17:27:26 发布