/*** 条件查询* 案例:查询客户名称以“腾讯”开头的客户* sql : SELECT * FROM cst_customer WHERE cust_name LIKE ?* jpql: FROM Customer WHERE custName like ?*/@Testpublic void testCondition(){//1.获取entityManager对象EntityManager entityManager = JpaUtils.getEntityManager();//2.开启事务EntityTransaction transaction = entityManager.getTransaction();transaction.begin();//3.查询全部//i.根据jpql语句创建查询对象String jpql = "from Customer where custName like ?";Query query = entityManager.createQuery(jpql);//ii.对参数赋值 -- 占位符参数//第一个参数:占位符的索引位置(从1)开始,第二个参数:取值query.setParameter(1,"腾讯%");//iii.发送查询,封装结果集/*** getResultList:直接将查询结果封装为list集合* getSingleResult:得到唯一的结果集*/List list = query.getResultList();for (Object obj : list){System.out.println(obj);}//4.提交事务transaction.commit();//5.释放资源entityManager.close();}
