1
2 Session s=HibernateUtil. currentSession ( );
3 Transaction t=s. beginTransaction ( );
4
5 Query q=s. createQuery ("from Trade t,Aclrole r where t. trade_id= 1 and r. rolename= 'lyorole'" );
6 q. setFirstResult ( 0 );
7 q. setMaxResults ( 10 );
8 List list=q. list ( );
9
10 int i= 0;
11 for (i= 0;i<list. size ( );i++ ) {
26
27 t. commit ( );
28 HibernateUtil. closeSession ( );
2 Session s=HibernateUtil. currentSession ( );
3 Transaction t=s. beginTransaction ( );
4
5 Query q=s. createQuery ("from Trade t,Aclrole r where t. trade_id= 1 and r. rolename= 'lyorole'" );
6 q. setFirstResult ( 0 );
7 q. setMaxResults ( 10 );
8 List list=q. list ( );
9
10 int i= 0;
11 for (i= 0;i<list. size ( );i++ ) {
...}
12
Object
[
] o=
(
Object
[
]
)list.
get
(i
);
13 for ( int j= 0;j<o. length;j++ ) {
25 out.
println
("I is: "+i
);
13 for ( int j= 0;j<o. length;j++ ) {
...}
14
Object oo=o
[j
];
15 if (oo instanceof Trade ) {
23 }
24
}
15 if (oo instanceof Trade ) {
...}
16 Trade tt=
(Trade
)oo;
17 out. println ("<tr><td>get trade:" +tt. getTrade_id ( )+"</td></tr>" );
18 } else if (oo instanceof Aclrole ) {
19 Aclrole r= (Aclrole )oo;
20 out. println ("<tr><td>get Role:"+r. getRoleid ( )+"</td></tr>" );
21 }
22
17 out. println ("<tr><td>get trade:" +tt. getTrade_id ( )+"</td></tr>" );
18 } else if (oo instanceof Aclrole ) {
19 Aclrole r= (Aclrole )oo;
20 out. println ("<tr><td>get Role:"+r. getRoleid ( )+"</td></tr>" );
21 }
23 }
26
27 t. commit ( );
28 HibernateUtil. closeSession ( );