hibernate的对象查询与sql语句的对应

转载自：http://www.devarticles.com/c/a/Java/Hibernate-Criteria-Queries-in-Depth/2/

１：

SELECT * FROM ORDER

对应的hibernate对象查询：

List orders= session.createCriteria(Order.class).list();

２：

SELECT NAME，ID FROM PRODUCT

对应的hibernate对象查询：

List products =session.createCriteria(Product.class).setProjection(
  Projections.propertyList()
  .add(Projections.property(/"name/"))
  .add(Projections.property(/"id/"))
  ).list();

３：

SELECT O.*, P.* FROM ORDERS O, PRODUCT P WHERE O.ORDER_ID=P.ORDER_ID;
对应的hibernate对象查询：

List orders = session.createCriteria(Order.class)
  .setFetchMode(“products”,FetchMode.JOIN)
  .list();
４：

SELECT * FROM ORDERS WHERE ORDER_ID=’1092’;

对应的hibernate对象查询：

List orders= session.createCriteria(Order.class)
  .add(Restrictions.eq(“orderId”,”1092”))
  .list();
５：

SELECT O.*, P.* FROM ORDERS O, PRODUCT P WHERE 
  O.ORDER_ID=P.ORDER_ID AND P.ID=’1111’;
对应的hibernate对象查询：

List orders = session.createCriteria(Order.class)
  .setFetchMode(“products”,FetchMode.JOIN)
  .add(Restrictions.eq(“id”,”1111”))
  .list();
６：

SELECT COUNT(ID) FROM ORDER HAVING PRICETOTAL>2000 GROUP BY ID

对应的hibernate对象查询：

List orders = session.createCriteria(Order.class)
  .setProjection( Projections.projectionList()
  .add( Projections.count(“id”) )
  .add( Projections.groupProperty(“id”) )
  )
  .list();
查询总结：

（１）如何得到session：

   Configuration cfg = new Configuration()
  .addClass(Order.class);

  SessionFactory　sf = cfg.buildSessionFactory(); 
  // open session
  Session sess = sf.openSession();

（２）HQL方法

String query = "select o from o "
  + "Order as o join o.products as p "
  + "where o.priceTotal > :priceTotalLower "
  + "and o.priceTotal < :priceTotalUpper";  

  Query q = sess.createQuery(query);
  q.setDouble("priceTotalLower", 
  Double.parseDouble(lower));

  q.setDouble("priceTotalUpper",
  Double.parseDouble(upper))

  q.list();
（３）Criteria 

    List list = sess.createCriteria(Order.class)
  .add(Restrictions.between(lower,upper)
  . list();

    Order o=(Order)list.iterator.next();