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.getInt(Unknown Source)
at net.acai.database.DBConnect.main(DBConnect.java:187)
数据库中就一个表,表有两个字段,
ResultSet rs=conn.stmt.executeQuery("select * from class");
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
}catch(Exception e){
e.printStackTrace();
}stmt为statement的实例
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.getInt(Unknown Source)
at net.acai.database.DBConnect.main(DBConnect.java:187)
数据库中就一个表,表有两个字段,
ResultSet rs=conn.stmt.executeQuery("select * from class");
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
}catch(Exception e){
e.printStackTrace();
}stmt为statement的实例
while(rs.next())
{
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
}
没有移动游标的位置,操作出错