查询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; }