在使用Java JDBC处理查询结果时，如果直接调用ResultSet的getInt(1)等方法可能会抛出'ResultSet没有当前行'的异常。解决这个问题需要在访问数据前先调用rs.next()来移动光标到第一行。rs.next()方法会将游标向下移动一行，返回值表示当前行是否有效。如果不调用next()，则没有行被选中，从而导致异常。
编程过程中发现这样的问题：ResultSet rs, 当执行好查询之后操作比如 rs.getInt(1)，会发生异常：
com.microsoft.sqlserver.jdbc.SQLServerException: ResultSet 没有当前行。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyOnValidRow(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getInt(Unknown Source)
在这行之前添加了rs.next()操作就可以了，查询了一下文档才知道了原因。
java.sql
Interface ResultSet
boolean
Method Detail
next
public boolean next()
throws SQLException
Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.
If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.
Returns:
true if the new current row is valid; false if there are no more rows
Throws:
扫一扫
1250
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
