此博客展示了使用Hibernate进行数据查询的代码示例。通过创建Session和Transaction，执行查询语句，设置查询结果范围，获取查询结果列表，并对列表中的对象进行类型判断和数据输出，最后提交事务并关闭Session。
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 ( );
扫一扫
138
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
