Hibernate查询结果封装成一个自定义实体

public void testSql() {
List<TestSql> listdata = getHibernateTemplate().executeWithNativeSession(
new HibernateCallback<List<TestSql>>() {
@Override
public List<TestSql> doInHibernate(Session session)
throws HibernateException, SQLException {
// TODO Auto-generated method stub
try{
SQLQuery query = session.createSQLQuery("select * from test");
//addScalar("id", Hibernate.STRING).addScalar("nickname", Hibernate.STRING).addScalar("name",Hibernate.STRING);
query.setResultTransformer(Transformers.aliasToBean(TestSql.class));
List<TestSql> list = query.list();
for (Object object : list) {
System.out.println(object);
}
System.out.println(list);

return list;
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return null;
}
});
System.out.println(listdata);
}