取得记录总数的错误?
public String getPageCount()
{
String pc= " ";
try
{
String sql = "SELECT COUNT(*) FROM RMS.dbo.prd_pic_tbl_pic ";
conn = DatabaseDao.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
pc=rs.getString(0);
} catch (Exception e)
{
e.printStackTrace();
}
return pc;
}

================================错误提示
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateCursorPosition(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)

好象是查询语句的问题,那里写错了?连接是正常的
第一次用SQL Server,请高手帮下忙

[解决办法]
把连接字符串贴出来看看
[解决办法]
public String getPageCount()
{
String pc= " ";
try
{
//String sql = "SELECT COUNT(*) FROM RMS.dbo.prd_pic_tbl_pic ";
改成String sql = "SELECT COUNT(*) as exist FROM RMS.dbo.prd_pic_tbl_pic ";
conn = DatabaseDao.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
pc=rs.getString( "exist ");
} catch (Exception e)
{
e.printStackTrace();
}
return pc;
}

--还有楼主应该加个finally关闭数据库连接 ：）

[解决办法]
java看不太懂。
[解决办法]
pc=rs.getString(0);

String ？？？
好象应该是个数字吧？？？？
JAVA 我也不懂