hibernate SQLQuery结果存到 以MAP格式存放


查询sql: select col1,col2,col3 from table

代码如下

Java代码

public List queryBySqlMap(String asql) {           final String sql = asql;           List lst = getHibernateTemplate().executeFind( new  HibernateCallback() {                 public  Object doInHibernate(Session s)  throws  HibernateException, SQLException {                       Query query  =  s.createSQLQuery(sql).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);                        List list  =  query.list();                       return  list;                       }                 });          return  lst;        }