String sql= "select name,age,sex from student";
SQLQuery query = session.createSQLQuery(sql);
query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List list =query.list();
for(int i=0;i<list.size();i++){
Map m = (Map)list.get(i);
System.out.println(" name :"+m.get("NAME"));//此处注意大写问题,oracle数据库查询出来的表列名为大写,此处必须与查询出的列名完全一样
System.out.println(" age:"+m.get("AGE"));
System.out.println(" sex :"+m.get("SEX"));
}