hibernate的sql查询出来封装实体的两种方式

1.在用hibernate的查询数据库时，即可以用hql，也可以用sql语句至于用hql语句查出来的结果可以是一个实体对象

如：

public List<CraGovernment> getAll() {
		String sql = "from CraGovernment as o";
			Query query = sessionFactory.getCurrentSession().createQuery(sql);
		return query.list();
	}

2.在使用sql语句时，查询出来后要转换一下，可以自己转成与数据库对应的hibernate的映射对象，也可以是dto，如果是hibernate的映射文件对应的直接加入

addEntity(GovernmentRecordType.class)

就可以了，否则采用下面的方式，这样结果就可以是一个实体对象。

public List<GovernmentRecordType> getRecordTypeById(Long governmentId) {
		String sql = "select o.id as id ,o.neirong_id as governmentId,o.wenzhong_id as recordTypeId from neirong_wenzhong  as o where o.neirong_id ="+governmentId;
//		Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addEntity(GovernmentRecordType.class);//不能用该方法因为不存在hibernate的xml文件与数据库对应的表
		Query query  = sessionFactory.getCurrentSession().createSQLQuery(sql)
			.addScalar("id",Hibernate.LONG)
			.addScalar("governmentId",Hibernate.LONG)
			.addScalar("recordTypeId",Hibernate.LONG)
			.setResultTransformer(Transformers.aliasToBean(GovernmentRecordType.class));
	return query.list();
	}

后来又发现另一种使用方式:

	public List<Researcher> getPublicResearcherForHot(int rowStart,
			int numberOfResultsToShow) {
	
	
		String sql = "select * from ir_researcher.researcher as re "
				+ " where re.researcher_id in (select t.researcher_id from "
				+ " (select  r.researcher_id,count(*) as num from "
				+ " ir_researcher.researcher_subscription as r "
				+ " group by r.researcher_id ORDER BY num desc)as t)";
//		 Query query  = hbCrudDAO.getSessionFactory().getCurrentSession().createQuery(hql); 
		 Query query  = hbCrudDAO.getSessionFactory().getCurrentSession().createSQLQuery(sql)
				 .addEntity("re",Researcher.class); 
		 query.setFirstResult(rowStart);
		 query.setMaxResults(numberOfResultsToShow);
     return  query.list(); 
	}