JPQL常用用法.doc

2010-06-14 HYPERLINK http://blog/692018JPQL的一些用法 文章分类:HYPERLINK /blogs/category/javaJava编程 关联(join) JPQL仍然支持和SQL中类似的关联语法： left out join/left join inner join left join fetch/inner join fetch left out join/left join等，都是允许符合条件的右边表达式中的Entiies 为空（需要显式使用left join/left outer join 的情况会比较少。） 例： //获取26岁人的订单,不管Order中是否有OrderItem select o from Order o left join o.orderItems where o.ower.age=26 order by o.orderid inner join 要求右边的表达式必须返回Entities。 例： //获取26 岁人的订单,Order 中必须要有OrderItem select o from Order o inner join o.orderItems where o.ower.age=26 order by o.orderid ！！重要知识点：在默认的查询中，Entity中的集合属性默认不会被关联，集合属性默认是延迟加载( lazy-load )。那么，left fetch/left out fetch/inner join fetch提供了一种灵活的查询加载方式来提高查询的性能。 例： private String QueryInnerJoinLazyLoad(){ // 默认不关联集合属性变量(orderItems)对应的表 Query query = em.createQuery(select o from Order o inner join o.orderItems where o.ower.age=26 order by o.orderid); List result = query.getResultList(); if (result!=null result.size()0){ //这时获得Order 实体中orderItems( 集合属性变量)为空 Order order = (Order) result.get(0); //当需要时，EJB3 Runtime才会执行一条SQL语句来加载属于当前Order的 //OrderItems SetOrderItem list = order.getOrderItems(); IteratorOrderItem iterator = list.iterator(); if (iterator.hasNext()){ OrderItem orderItem =iterator.next(); System.out.println (订购产品名：+ orderItem.getProductname()); } } 上面代码在执行select o from Order o inner join o.orderItems where o.ower.age=26 order by o.orderid时编译成的SQL如下（他不包含集合属性变量(orderItems)对应表的字段）： select order0_.orderid as orderid6_, order0_.amount as amount6_, order0_.person_id as person4_6_, order0_.createdate as createdate6_ from Orders order0_ inner join OrderItems orderitems1_ on order0_.orderid=orderitems1_.order_id, Person person2_ where order0_.person_id=person2_.personid and person2_.age=26 order by order0_.orderid 上面代码当执行到SetOrderItem list = order.getOrderItems();时才会执行一条SQL语句来加载属于当前Order的OrderItems，编译成的SQL 如下： select orderitems0_.order_id as order4_1_, orderitems0_.id as id1_, orderitems0_.id