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();
}
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();
}
ResultSet rs=stmt.executeQuery("select * from class");
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
}catch(Exception e){
e.printStackTrace();
}
ResultSet rs=stmt.executeQuery("select * from class");
rs.next();
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
}catch(Exception e){
e.printStackTrace();
}
楼主少了
rs.next();语句
当执行
ResultSet rs = stmt.executeQuery(sql);之后
rs指向第一条记录的前边