不太知道JSP的语法你可以使用动态SQL：declare @sql varchar(2000)
select @sql='select a.user_id,a.name,c.award_name from t_user as a,t_record as b,t_award as c
where a.user_id=b.user_id and b.award_id=c.award_id and c.award_id=2 group by a.user_id,a.name,c.award_name having count(b.award_id)='+times
exec (@sql)
select @sql='select a.user_id,a.name,c.award_name from t_user as a,t_record as b,t_award as c
where a.user_id=b.user_id and b.award_id=c.award_id and c.award_id=2 group by a.user_id,a.name,c.award_name having count(b.award_id)='+times
exec (@sql)
只有Value值才是用户输入的数值,名字是Text的代号吧!