这么简单的句子也能出错? 请教....

[xushli]

平台,WEBLOGIC7.0+SQLSERVER2000+JSP
源码..
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="includes/job-data.jsp" %>
<%
ResultSet rs=stmt.executeQuery("select count(cid) as Rcount from rc_reg");
int RowCount=rs.getInt("Rcount");
out.print(RowCount);
rs.close();
%>

错误信息..
<2003-5-29 上午10时17分24秒> <Error> <HTTP> <101017> <[ServletContext(id=5709463
,name=DefaultWebApp,context-path=)] Root cause of ServletException
com.jnetdirect.jsql.w: Result set has no current row

[dlh169]

呵呵，你应该用
if rs.next()
{


}

[dlh169]

if rs.next()
{


}

[dlh169]

不好意思，没有写完
int rowcount=0;
if rs.next(){

rowcount=rs.getInt("");
}