关于queryb的讨论汇总 - 话题女王

c******n
发帖数: 4965

A ---- B is many to many relation
so in DB there is a A_B mapping table.
now I want to do hql : " from A a where a.setsOfB = :queryB " and do
session.createQuery("from A a where a.setsOfB = :queryB " ).setEntity(
oneInstanceOfB).list()
Hibernate does a 3-table JOIN,
select * from A a join A_B ab on a.B_ID = ab.B_ID join B b on b.B_ID = ab.B_
ID where b.B_ID = [ oneInstanceOfB.getId() ]
but instead, supposedly it should be able to just JOIN A and A_B table,
I set lazy=true everywhere, and from... 阅读全帖

M**********n
发帖数: 4964

来自主题: Database版 - 大牛们，问两个Access Combo box问题

很少用Access，实在对Access不熟悉。请大牛们指点指点怎么做，给个方向/idea。
比如我现在有一个十万record的table，我想根据三个fieldname(假设fieldnameA,
fieldnameB,fieldnameC) filter table,然后generate report。
我现在根据这三个fieldname弄了三个group by query，每个query只有这个fieldname
，没其他field了。比如queryA有100行，queryB有300行，queryC有500行。然后在form
上弄了三个combo box，每个combo box的dropdown list来自各自对应的query，ComboA
有100 dropdown item,ComboB有300 dropdown item,ComboC有500 dropdown item.
其实这个十万record的table是dynamic的,每过一段时间就要import new data append
到这个table里面。所以那三个query的行数（dropdown item)有可能是... 阅读全帖

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

版面

帖数(主题数)

全站

4871 (796)

3777 (569)

341 (51)

117 (17)

116 (3)