当前位置:编程学习 > JAVA >>

hibernate 分组查询

   

                  DetachedCriteria criteria = DetachedCriteria.forClass(DreamDownClient.class); /*实体类*/
                   /*参数1 查询的字段名,参数2 分组的字段,参数3 查询结果返回的列名,参数3,返回结果的字段类型*/
		criteria.setProjection( Projections.sqlGroupProjection("ditch,count(*) as c", "ditch", new String[]{ "ditch" , 
		"c"}, new Type[]{ IntegerType.INSTANCE  , IntegerType.INSTANCE } ) ) ;
		criteria.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP) ; 
		System.out.println( dreamDownClientServer.query( criteria ) ) ;

 

补充:软件开发 , Java ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,