Jpql的一些常用方法

查询全部

@Test
    public void testFindAll(){
        EntityManager manager = jpaUtil.getEntityManager();
        EntityTransaction tx = manager.getTransaction();
        tx.begin();
        String jpql=" from com.ahead.pojo.Custorm order by id desc ";
        Query query = manager.createQuery(jpql);//创建query查询对象，query对象才是执行jpql的对象
        List list=query.getResultList();
        for(Object obj:list){
            System.out.println(obj);
        }
        tx.commit();
        manager.close();
    }

分页查询

@Test
    public void testPaged(){
        EntityManager manager = jpaUtil.getEntityManager();
        EntityTransaction tx = manager.getTransaction();
        tx.begin();
        String jpql="  from  Custorm  ";
        Query query = manager.createQuery(jpql);
        //对参数赋值  --分页参数
        //起始索引
        query.setFirstResult(1);
        //每页查询的条数
        query.setMaxResults(3);
        List list = query.getResultList();
        for (Object obj:list){
            System.out.println(obj);
        }
        tx.commit();
        manager.close();
    }

条件查询

@Test
    public void test(){
        EntityManager manager = jpaUtil.getEntityManager();
        EntityTransaction tx = manager.getTransaction();
        tx.begin();
        String jpql="  from  Custorm where name like ? ";
        Query query = manager.createQuery(jpql);
        //对参数赋值  --占位符参数
        //第一个参数，占位符的索引位置（从1开始） 第二个参数 :取值
        query.setParameter(1,"%邓%");
        //起始索引
        query.setFirstResult(0);
        //每页查询的条数
        query.setMaxResults(2);
        List list = query.getResultList();
        for (Object obj:list){
            System.out.println(obj);
        }
        tx.commit();
        manager.close();
    }

工具类（jpaUtil）

private static EntityManagerFactory factory;
    static{
        factory= Persistence.createEntityManagerFactory("JPA");
    }
    public static EntityManager getEntityManager(){
        return factory.createEntityManager();
    }