createSQLQuery 用法

List<Subject_people_config> list=new ArrayList<Subject_people_config>();
String sql="select * from Subject_people_config";
Query query=this.getSession().createSQLQuery(sql)
.addScalar("check_subject_id",Hibernate.INTEGER)
.addScalar("people_id",Hibernate.INTEGER)
.addScalar("people_name",Hibernate.STRING)
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List map_list=query.list();
for (Iterator iterator = map_list.iterator(); iterator.hasNext();) {
Map<String,Object> spc_map = (HashMap<String ,Object>)iterator.next();
//System.out.println(spc_map.get("people_name"));
Subject_people_config spc=new Subject_people_config();
spc.setCheck_subject_id((Integer)spc_map.get("check_subject_id"));
spc.setPeople_id((Integer)spc_map.get("people_id"));
spc.setPeople_name((String) spc_map.get("people_name"));
list.add(spc);

}
//.findByNamedParam("from Subject_people_config spc where spc.check_subject_id=:id", "id",id); 
//.findByNamedQuery("bycheck_subject_id","1");
return list;