DAO需要繼承DAO extends HibernateDaoSupport

applicationContext.xml中需要注入sessionFactory
<bean id="adminManagerDAO" class="com.guigu.store.dao.AdminManagerDAO">
<!--注入SessionFactory -->
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>

Session session = getHibernateTemplate().getSessionFactory().openSession();
SQLQuery query = session.createSQLQuery("select * from user_kissfly");
query.addEntity(UserKissfly.class);
query.setFirstResult(0);
//query.setFetchSize(3);
query.setMaxResults(4);
List<UserKissfly> list =query.list();
// for(UserKissfly user:list){
// System.out.println("當前用戶的部門是：" + user.getDeptKissfly().getDeptname());
// }

System.out.println("查到的數據條數為：" + list.size());
session.close();