對hql查詢結果的顯示
情況一:
《jsp通過logic:iterate或html:optionsCollection循環顯示action中傳過來的對象List》
情況二:
List ha = new ArrayList();
ha=session.createQuery("SELECT test2.id,test2.name FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
Object[] test2 = (Object[]) it.next();
System.out.print(test2[0]);
System.out.println(":"+test2[1]);
}
情況一為了也可以動態的在hql語句中構建一個新的對象,定義相應的set,get方法,然后就可以像第三種情況一樣使用了,這樣便于從action到jsp頁面去顯示:參照ha=session.createQuery("SELECT test2.id,test2.name FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
Object[] test2 = (Object[]) it.next();
System.out.print(test2[0]);
System.out.println(":"+test2[1]);
}
《jsp通過logic:iterate或html:optionsCollection循環顯示action中傳過來的對象List》
情況二:
List ha = new ArrayList();
ha=session.createQuery("SELECT test2.name FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
System.out.println(it.next());
}
情況三:ha=session.createQuery("SELECT test2.name FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
System.out.println(it.next());
}
List ha = new ArrayList();
ha=session.createQuery("SELECT test2 FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
Test2 test2=(Test2)it.next();
System.out.println(test2.getName());
}
ha=session.createQuery("SELECT test2 FROM Test2 as test2").list();
//ha = session.createCriteria(Test2.class).list();
for (Iterator it = ha.iterator(); it.hasNext();) {
Test2 test2=(Test2)it.next();
System.out.println(test2.getName());
}
posted on 2007-09-25 10:56 月芽兒 閱讀(328) 評論(0) 編輯 收藏 所屬分類: J2EE學習心得