½«sql²éѯ³öÀ´µÄÊý¾Ýת»¯Îª¶ÔÏó

import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import xml.dao.admin.AdminArea;
public class NativeSQLQuery extends HibernateDaoSupport {
 /**
  * ½«Êý¾Ý¿â²éѯ³öµÄÊý¾Ýת»¯ÎªAdminArea
  * @param queryString ²éѯadmin_area±íÊý¾ÝµÄsqlÓï¾ä
  * @param pojoClass
  * @param jdbcTemplate
  * @return
  */
 public List<? extends AdminArea> findObjectBySql(String queryString,
   Class<? extends AdminArea> pojoClass, JdbcTemplate jdbcTemplate) {
  Session session = this.getSession();
  /**
   * ʹÓÃSQL¹¹Ôì²éѯ¶ÔÏ󣬴ËSQLÊÇ¿ÉÒÔ±»JDBC½ÓÊܵÄSQL£¬ÈçSELECT * from XXX_TABLE
   */
  Query query = session.createSQLQuery(queryString);
  
  /**
   * ÉèÖýá¹û¼¯×ª»»Æ÷
   */
  query.setResultTransformer(new SqlColumnToBean(pojoClass));
  
  List list = query.list();
  
  /**
   * ¹Ø±Õsession
   */
  session.close();
  
  /**
   * ·µ»Ø²éѯ½á¹û
   */
  return list;
 }
}
import java.lang.reflect.Field;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.property.ChainedPropertyAccessor;
import org.hibernate.property.PropertyAccessor;
import org.hibernate.property.PropertyAccessorFactory;
import org.hibernate.property.Setter;
import org.hibernate.transform.ResultTransformer;
import xml.dao.admin.AdminArea;
public class SqlColumnToBean implements ResultTransformer {
 private static final long serialVersionUID = 1L;
 private final Class<? extends AdminArea> resultClass;
 private Setter[] setters;
 private PropertyAccessor propertyAccessor;
&