# 將Hibernate回傳的資料轉為Map來使用
利用

query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

讓原本回傳的陣列Object變成Map

List<StudentVo> resultList = null;

SQLQuery query = null;
try{
    StringBuffer sql = new StringBuffer();
    sql.append("...");
    ...
    ... 
    ...
    
    query = getSession().createSQLQuery(sql.toString());
    query.setParameterList("xxx",xxx);
    query.setString("yyy",yyy);
    query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
    
    List<Map<String,Object>> mapList = query.list();
    
    if(mapList != && !mapList.isEmpty()){
        resultList = new ArrayList<StudentVo>();
        for(Map<String,Object> sMap : mapList){
            StudentVo vo = new StudentVo();
            BeanClone.map2Object(smap,vo,null);
            resultList.add(vo);
        }
    }
}catch(Exception e){
    
}