Hibernate QBC查询基本语句

1. Hibernate QBC查询基本语句
3. public class QBC {
4.       public static void main(String[] args) {
5.         HibernateUtil.initSessionFactory(new File(QBC.class.getClassLoader().getResource
7. ("hibernate.cfg.xml").getFile()));
8.         Session se = HibernateUtil.getSession();
9.         
10.         Cgoods goods=new Cgoods();
11.         goods.setGname("Sony");
12.         //内联
13.         //Criteria criteria = se.createCriteria(Catg.class).createCriteria("goods", 
15. "a").add(Expression.eq("a.gname","Sony"));
16.         
17.         
18.         Criteria criteria2 = se.createCriteria(Cgoods.class);
19.         //criteria2.setFirstResult(0);
20.         //criteria2.setMaxResult(2);
21.         
22.         //criteria.add(Restrictions.eq("this.gname", "Sony"));  //1
23.         //criteria.add(Expression.eq("this.gname", "Sony"));      //2
24.         //criteria.add(Example.create(goods).ignoreCase().excludeZeroes().enableLike
26. (MatchMode.ANYWHERE)); //3
27.         
28.         //criteria2.add(Restrictions.like("gname", "%S%"));
29.         //criteria2.add(Restrictions.between("cid", new Integer(0),  new Integer(5)));
30.         //criteria2.add(Restrictions.or(Restrictions.eq("cage", new Integer
32. (0)),Restrictions.isNull("cage")));
33.         //criteria2.add(Restrictions.in("gname", new String[] {"a", "b", "c"}));
35.         /*
36.         通过调用Property.forName()创建一个Property
37.         Property age = Property.forName("gname"); 
38.         criteria2.add(age.isNull());
39.         */
40.         /*
41.         criteria2.setProjection(Projections.groupProperty("gname"));
42.          聚合函数
43.         ProjectionList prolist=Projections.projectionList();
44.         prolist.add(Projections.groupProperty("gname"));
45.         prolist.add(Projections.rowCount());
46.         criteria2.setProjection(prolist);
47.         */
48.         
49.         //criteria.addOrder(Order.asc("gname"));  //排序 
50.         List list= criteria2.list();
51.         Iterator iter= list.iterator();
52.         while(iter.hasNext()){
53.             Cgoods temp=(Cgoods)iter.next();
54.         String cname=temp.getGname();
55.         String cnt=temp.getGdes();
56.         System.out.println(cname + ":" + cnt+"");
57.         }
58.         HibernateUtil.closeSession();
59.     }
60. }