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();
}