</p> TRegister user = new TRegister();( b5 D$ T U3 ]* t R) S2 R6 G
Session session = HibernateUtil.currentSession();
& V6 ~: N; y6 n7 } Query query = session.createQuery("select u.userName ,u.sex from TRegister u");
% V0 u( f2 M' x& H4 c/ ` O List list = query.list();
' g8 }: T$ ?( y( w6 Z for(int i = 0 ; i < list.size(); i++)
& S4 h* O/ r2 T9 Z- C/ Q* d {) y" i/ V/ E: v7 e+ j
Object obj[] = (Object[])list.get(i);
/ E8 L: M+ V% h1 |5 }9 p4 p, _ System.out.println(obj[0]+" 的性别是:"+obj[1]);: @, h) j- ?+ p( o
}
2 J3 L6 E& o' u4 v }6 `; D! V$ b) T5 R2 e3 @
在使用属性查询时,由于使用对象数组,操作和理解不太方便,如果将 一个object[]中所有成员封装成一个对象就方便多了。下面的程序做了示例: public void HQLselectDEMO(), j- Y2 t6 ~* \+ S0 R+ Y% `) W% |
{
/ m6 ?# @" l: n" n Session session = HibernateUtil.currentSession();
6 W( z6 i% M# l Query query = session.createQuery("select new TRegister(u.userName,u.sex) from TRegister u");
- L* z+ F0 U3 i+ o t List list = query.list();
# o7 J0 m7 B+ e5 ` for(int i = 0 ; i < list.size(); i++)
" c0 x6 A& d9 J" E2 ?. t( s {
8 e2 {. {2 U% v6 n a //Object obj[] = (Object[])list.get(i);/ _: \. t* h2 x7 S" e. X5 r# e
TRegister user = (TRegister)list.get(i);
* }, b& M, `* u: C- C5 N1 w7 o' H7 p System.out.println(user.getUserName()+" 的性别是:"+user.getSex());5 F/ e- B+ Z* S/ H* M9 r- }7 e
} |