@Repository
public class ABCDaoImpl extends HibernateDaoSupport implements IABCDao {
@Inject
public void setSuperSessionFactory(SessionFactory sessionFactory) {
super.setSessionFactory(sessionFactory);
}
@SuppressWarnings("unchecked")
@Override
public List<StudentExcelDto> getReport() {
String sql = "select name, age, sex, (CASE status WHEN 0 THEN '在校' ELSE '离校' END) status from t_student";
return getHibernateTemplate().getSessionFactory().openSession().createSQLQuery(sql) .setResultTransformer(Transformers.aliasToBean(StudentExcelDto.class)).list();
}
public class ABCDaoImpl extends HibernateDaoSupport implements IABCDao {
@Inject
public void setSuperSessionFactory(SessionFactory sessionFactory) {
super.setSessionFactory(sessionFactory);
}
@SuppressWarnings("unchecked")
@Override
public List<StudentExcelDto> getReport() {
String sql = "select name, age, sex, (CASE status WHEN 0 THEN '在校' ELSE '离校' END) status from t_student";
return getHibernateTemplate().getSessionFactory().openSession().createSQLQuery(sql) .setResultTransformer(Transformers.aliasToBean(StudentExcelDto.class)).list();
}
}
红色字返回非托管实体对象
自动生成hibernat