１：
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();
责任编辑：小草
