Hibernate 使用原生SQL进行查询

例子

 SQLQuery sqlQuery = getSession().createSQLQuery(SQLString); sqlQuery.setResultTransformer(Transformers.aliasToBean(PvpRank.class)); sqlQuery.addScalar("bodyId", Hibernate.INTEGER); sqlQuery.addScalar("bodyName", Hibernate.STRING); sqlQuery.addScalar("integration", Hibernate.INTEGER); sqlQuery.addScalar("winRate", Hibernate.INTEGER); List<PvpRank>  list = sqlQuery.list();

其中 ：sqlQuery.setResultTransformer(Transformers.aliasToBean(PvpRank.class)); 设置你查询后的对象 xxx.class

sqlQuery.addScalar("bodyId", Hibernate.INTEGER);

设置你查询的字段的类型,这里bodyId ,类型为int;