hibernate 一对多查询问题

[bbblove65]

请教下，在hibernate中建立1->n的单向关联。
我想要在1的一方查询，获取1的全部对象同时也需要1关联的n的表的部分数据.现在查询出来的sql语句如下
Hibernate:
select
chcategory0_.category_id as category1_1_,
chcategory0_.cat_name as cat2_1_,
chcategory0_.cat_order as cat3_1_,
chcategory0_.is_valid as is4_1_
from
change.ch_category chcategory0_
where
is_valid=1
Hibernate:
select
chmembers0_.category_id as category6_1_,
chmembers0_.id as id1_,
chmembers0_.id as id0_0_,
chmembers0_.user_id as user2_0_0_,
chmembers0_.user_name as user3_0_0_,
chmembers0_.pass_word as pass4_0_0_,
chmembers0_.status as status0_0_,
chmembers0_.category_id as category6_0_0_,
chmembers0_.channels_id as channels7_0_0_,
chmembers0_.cooperation_id as cooperat8_0_0_,
chmembers0_.qq as qq0_0_,
chmembers0_.msn as msn0_0_,
chmembers0_.mobile as mobile0_0_,
from
change.ch_members chmembers0_
where
chmembers0_.category_id=?
。。。。。。。。。。。。。。。。。。。。。。。。。
想要的效果是在关联的对象加入条件例如:
Hibernate:
select
chmembers0_.category_id as category6_1_,
chmembers0_.id as id1_,
chmembers0_.id as id0_0_,
chmembers0_.user_id as user2_0_0_,
chmembers0_.user_name as user3_0_0_,
chmembers0_.pass_word as pass4_0_0_,
chmembers0_.status as status0_0_,
chmembers0_.category_id as category6_0_0_,
chmembers0_.channels_id as channels7_0_0_,
chmembers0_.cooperation_id as cooperat8_0_0_,
chmembers0_.qq as qq0_0_,
chmembers0_.msn as msn0_0_,
chmembers0_.mobile as mobile0_0_,
from
change.ch_members chmembers0_
where
chmembers0_.category_id=?
limt 5

[yang4187668]

FROM bclass b WHERE b.students.name="张三"

[luodiweichen19861225]

[Quote=引用 6 楼 yang4187668 的回复:]
FROM bclass b WHERE b.students.name="张三"
[/Quote]



select * from bclass b,students s where b.cid=s.cid and s.name='张三'

[安心逍遥]

哎，帮楼主顶一下拉。这个还没学呢，我是超级菜鸟啊

[madFatso]

	List<Object []> list = session.createSQLQuery("").list();
		for(Object [] obj : list){
			System.out.println(obj[0].toString());
		}

[bbblove65]

[Quote=引用 2 楼 madfatso 的回复:]

Java code
List<Object []> list = session.createSQLQuery("").list();
for(Object [] obj : list){
System.out.println(obj[0].toString());
}
[/Quote]
不是如何遍历，是想要hibernate关联生成的sql加上一定的条件。
比如 分类->商品 1个分类下有上万种商品，只要其中符合条件的商品几条。现在每次查询分类的到的关联商品对象是全部

[madFatso]

[Quote=引用 3 楼 bbblove65 的回复:]
引用 2 楼 madfatso 的回复:
不是如何遍历，是想要hibernate关联生成的sql加上一定的条……
[/Quote]
createSQLQuery(放你的功能SQL)

[bbblove65]

[Quote=引用 4 楼 madfatso 的回复:]

引用 3 楼 bbblove65 的回复:
引用 2 楼 madfatso 的回复:
不是如何遍历，是想要hibernate关联生成的sql加上一定的条……

createSQLQuery(放你的功能SQL)
[/Quote]

大哥不是这个意思！
bclass 班级表 students学生表
Query query = session.createQuery("FROM bclass");
List lx= query.list();
for (int i = 0; i < lx.size(); i++)
{
bclass bc = (bclass) l1.get(i);//班级信息
Set mset=bc.getStudents();//学生信息（全部的）
我要的是给学生检索加入条件不是全部学生