DetachedCriteria

DetachedCriteria detachedCriteria =DetachedCriteria.forClass(UserVO.class)
 //.add(Restrictions.like("username","sz",MatchMode.ANYWHERE));
   .add(org.hibernate.criterion.Expression.disjunction()  //or查询把add放到外面是and查询,MatchMode.ANYWHERE糊查询
        .add(org.hibernate.criterion.Property.forName("username").like("s", MatchMode.ANYWHERE))
        .add(org.hibernate.criterion.Property.forName("password").like("c", MatchMode.ANYWHERE))
        );

 

多对一情况  
DetachedCriteria  zlbdc=DetachedCriteria.forClass(ZlZlxm.class, "zlb");
                     //  .createAlias("zlb.zl", "t")
                        // .setProjection(Property.forName("t.id").count())
                       //.add(Property.forName("t.id").eq(new  Long(1)))
                       org.hibernate.criterion.Projection projection=org.hibernate.criterion.Projections.projectionList()
                                   .add(org.hibernate.criterion.Property.forName("zlb.fdxx"),"id");
                       zlbdc.setProjection(projection);
                                     //zlbdc.createCriteria("zl");//加上这句是内联接(inner join)zl为集合
投影查询，得到一是object[]

  DetachedCriteria  zlbdc=DetachedCriteria.forClass(ZlZlxm.class, "zlb")
  //zlbdc.createCriteria("zl"); //此处为对象
                       .createAlias("zlb.zl", "t") //别名
                       .setProjection(Property.forName("t.id").count())
                       .add(Property.forName("t.id").eq(new  Long(1))); //这里统计的是个数内联接(inner join)
         //zladc.setFetchMode("zla.zlZlxm", org.hibernate.FetchMode.JOIN);//无作用(集合lazy)？？？，如果not lazy将会是全部查出