sql查询中如何获取count()的值

[qinhuanyu]

我的语句是这样的：sql="select count(stunlid) from stunlstu where stunlid=6"，现在想把查询count(stunlid) 的值赋给一个int 型变量countnum=Integer.parseInt(rs.getString("count(stunlid)")) 但是老是提示出错 ，我想可能是我的赋值语句错误了 后来 又改成sql="select count(stunlid) as countnum from stunlstu where stunlid=6"，可是值还是去不出来。请问各位 这个问题该如何解决呀！谢谢！

[master_fengj]

countnum=rs.getInt(0)

[SQL77]

ExecuteNonQuery ();

[--小F--]

输出参数 
declare @num int, @sqls nvarchar(4000) 
set @sqls='select count(*) from tableName' 
exec(@sqls) 

--如何将exec执行结果放入变量中？ 

declare @num int, @sqls nvarchar(4000) 
set @sqls='select @a=count(*) from tableName ' 
exec sp_executesql @sqls,N'@a int output',@num output 
select @num 

[ziqing_1_2_3]

declare @aa int
select @aa=(select count(stunlid) from stunlstu where stunlid=6 )
print @aa