hibernate 执行原生 sql 查询，返回包含 map 的 list

// hibernate 执行原生 sql 查询，返回包含 map 的 list
Session session = sessionFactory.getCurrentSession();
String sql = "select s.sys_code as sysCode, s.sys_name as sysName from system s";
Query query = session.createSQLQuery( sql );
query.setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
List<Map<String, Object>> list = ( List<Map<String, Object>> ) query.list();

for ( int i = 0; i < list.size(); i++ ) {
    Map<String, Object> m = ( Map<String, Object> ) list.get( i );
    System.out.println( m.get( "sysCode" ) + " ------- " + m.get( "sysName" ) );
}

 

转自： http://blog.sina.com.cn/s/blog_6cf1532b0101a49x.html