hibernate投影

/**
     * 测试投影
     * @return
     */
    public List testProjection(){
    	Projection projection=Projections.projectionList()
    	.add(Property.forName("state").avg().as("stateavg"))
    	.add(Property.forName("createTime").max().as("create"));
    	
    	List list=newsDao.createCriteria(Restrictions.ge("id", 1l)).setProjection(projection)
    	.list();
    	return list;
    }

 

/**
	 * 测试投影
	 */
	@Test
	public void testProjection(){
		Iterator results =newsManager.testProjection().iterator();
	
	while ( results.hasNext() ) {
	    Object[] row = (Object[]) results.next();
	    Double type = (Double) row[0];
	    Date oldest = (Date) row[1];
	   System.out.println(type+"=="+oldest);
	}
	}