create table users ( uid int not null primary key, uname varchar(10) ) go create table trade ( tid int not null primary key, buyuserid int not null, selluserid int not null ) go alter table trade add constraint FK_buyuserid foreign key(buyuserid) references users(uid); alter table trade add constraint FK_selluserid foreign key(selluserid) references users(uid); go insert into users values(1, 'aaa '); insert into users values(2, 'bbb '); insert into users values(3, 'ccc '); insert into users values(4, 'ddd '); insert into users values(5, 'eee '); go insert into trade values(1,1,3); insert into trade values(2,2,4); insert into trade values(3,2,3); insert into trade values(4,3,5); go select * from users; select * from trade; --买 select count(trade.buyuserid) as buycount,trade.buyuserid,min(users.uname) as buyusername from trade,users where trade.buyuserid=users.uid group by trade.buyuserid; --卖 select count(trade.selluserid) as sellcount,trade.selluserid,min(users.uname) as sellusername from trade,users where trade.selluserid=users.uid group by trade.selluserid; 应该可以吧 试试
难道你多个请求用的同一个hibernate的Session实例??
应该可以吧 试试
<noscript><a href="http://www.51.la/?3584349" target="_blank"><img alt="我要啦免费统计" src="http://img.users.51.la/3584349.asp" style="border:none" /></a></noscript>首先你在51la上面注册一个免费的帐号,然后,将这段代码复制到你所有的页面中,那么就可以统计访问量了。
只需要用帐号登陆到www.51.la 后台即可查看