Hibernate纯SQL查询

       目前有个项目使用了hibernate，让使用mybatis的我有点不舒服，hibernate更多的是对单表的处理方便，对于多表查询不是很方便，所以不可避免要用到纯SQL查询，而我又比较喜欢List<Map>的返回值，所以例子如下：

      

String sql = "select a.ID,a.account_id,a.company_id,a.score as totalscore,a.comments," +
					"date_format(a.update_time,'%Y-%m-%d') as update_time,b.eva_name_cn,b.score as subscore from u1 a,u1_item b "+
					" where a.ID=b.u1_id and a.account_id=1 ORDER BY a.update_time";

List list = sessionFactory.getCurrentSession().createSQLQuery(sql).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();

for (Map<String,Object> m:list){
      System.out.println(m.get("ID").toString());
      System.out.println(m.get("totalscore").toString());
      System.out.println(m.get("subscore").toString());
}