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,请高手帮下忙
{
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,请高手帮下忙
Connection conn = null;
String db_url = "jdbc:microsoft:sqlserver://100.100.0.201:1766; DatabaseName=RMS";
String db_user = "*****";
String db_password= "*****";
String db_driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
try {
Class.forName(db_driver);
conn = DriverManager.getConnection(db_url, db_user, db_password);
} catch (Exception ex) {
ex.printStackTrace();
}
return conn;
}
{
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);
}