hibernate hql里可以new对象.

 

String hql = " select new  com.domain.MyUser(name,passwd) from Users";     
Query query = session.createQuery(hql);    //默认查询出来的list里存放的是一个Object数组，但是在这里list里存放的不再是默认的Object数组了，而是MyUser对象了         
List myUsers = query.list();            
for(MyUser myUser : myUsers){                 
	String name = myUser.getUsername();      
	String passwd = myUser.getPassword();       
	System.out.println(name + " : " + passwd);       
	}  

 

// 如果是多个实体,需写上对应的别名

public CommissionArDetailQueryResult findCommDetailHeadInfo(SettleModel  docHead,SettleARModel arItem){
		String hql=
			"select distinct new com.coscon.cbs.domain.model.test.CommissionArDetailQueryResult"
			+"( commBl.billReferenceCode,commBl.companyCode,bizInfo.cargoTradeLaneCode,bizInfo.porUuid,shmtCntr.outBoundDoorCyIndicator " 
			+",shmtCntr.inboundDoorCyIndicator,bizInfo.fndUuid,bizInfo.firstLoadingSvvdId,bizInfo.firstPodCode,bizInfo.firstBaseLoadingSvvdId " 
			+",bizInfo.firstBasePolCode,bizInfo.lastBaseLoadingSvvdId,bizInfo.lastBasePodCode,bizInfo.lastLoadingSvvdId,bizInfo.lastPodCode ) "
			+
			" from " 
			    +" com.coscon.cbs.domain.model.test.SettleModel  docHead, " 
			    +" com.coscon.cbs.domain.model.test.CbsSettlementBusinessInformation  bizInfo ," 
				+" com.coscon.cbs.domain.model.test.CbsCommissionBill commBl ," 
				+" com.coscon.cbs.domain.model.test.SettleARModel arItem,"  
				+" com.coscon.cbs.domain.model.test.CbsCommissionContainer commCntr," 
				+" com.coscon.cbs.domain.model.test.CbsShipmentContainerPackageInformation shmtCntr " 
				+
			" where " 
				+ " bizInfo.businessReferenceUuid = "+docHead.getBizRefUuid() 
				+ " and commBl.billBasicUuid= "+docHead.getBizRefUuid() 
				+ " and commBl.companyCode = "+docHead.getCompanyCde()
				+ " and commBl.commissionMode = "+arItem.getChrgCdeGrp()
				+ " and commBl.commissionType = "+arItem.getChrgCde()
				+ " and commBl.companyCode = commCntr.companyCode " 
				+ " and commBl.commissionMode = commCntr.commissionMode " 
				+ " and commBl.agencyCode = commCntr.agencyCode "
				+ " and commBl.billBasicUuid = commCntr.billBasicUuid " 
				+ " and shmtCntr.shipmentContainerPackageUuid = commCntr.shipmentContainerPackageUuid " ;
		CommissionArDetailQueryResult queryResult = (CommissionArDetailQueryResult) cbsModuleRepository.getSessionFactory().getCurrentSession().createQuery(hql).list().get(0);
		return queryResult;
	}

String sql = "select test1,test2 from Test1 test1,Test2 test2"; 
	List list =  session.find(sql); 
	for(int i=0;i<list.size();i++) 
	{ 
	    Object[] obj = (Object[])list.get(i); 
	    Test1 t1 = (Test1)obj[0]; 
	    Test2 t2 = (Test2)obj[1]; 
	}