hibernate sql查询对象到map中

  1. public List queryBySqlMap(String asql) {
  2. final String sql = asql;
  3. List lst = getHibernateTemplate().executeFind( new HibernateCallback() {
  4. public Object doInHibernate(Session s) throws HibernateException, SQLException {
  5. Query query = s.createSQLQuery(sql).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
  6. List list = query.list();
  7. return list;
  8. }
  9. });
  10. return lst;
  11. }