DAO層:
使用hibernate執行HQL語句
public List findByHQL(final String SQL){
List list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(SQL);
return query.list();
}
});
return list;
}
返回Object數組(如:Ljava.lang.Object;@b6e768)
在Seriver層中編寫如下可以顯示值:
List userInfoList = blankFpnFacade.getUserInfo(userId);
for (Iterator ite = userInfoList.iterator(); ite.hasNext();) {
Object[] obj = (Object[]) ite.next();
System.out.println(obj[0]);
System.out.println(obj[1]);
}