java中怎样使用游标？急！！！

[robinwrh]

java中是否能直接定义游标？能定义的话应该怎样定义？怎样使用？应注意些什么？
最好能有实例。小弟不胜感激！

[tsingien]

ava.sql
Interface ResultSetpublic boolean absolute(int row)
throws SQLException


Moves the cursor to the given row number in this ResultSet object.

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.

If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method absolute(-1) positions the cursor on the last row; calling the method absolute(-2) moves the cursor to the next-to-last row, and so on.

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.

Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

Parameters:

row - the number of the row to which the cursor should move. A positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set

Returns:

true if the cursor is on the result set; false otherwise

Throws:

SQLException - if a database access error occurs, or the result set type is TYPE_FORWARD_ONLY

Since:

1.2

[youthy_yy]

java中没有，但可以用Types.OTHER来代替
另外如果用的是Oracle数据库，则很方便的用OracleTypes.CURSOR来获取游标 (需要class12.jar驱动程序）

[shangqiao]

ResultSet不就是是游标吗

[vongood]

gz

[zhifangtu]

正解：youthy_yy(阿远<广州>)