View RSS Feed

Java Database

Result Sets and Cursors

Rate this Entry
by , 03-09-2012 at 08:28 PM (871 Views)
Conditions of a query are satisfied by the result set. Result set is considered to be rows set. A result set can return no. of rows.
  • Zero
  • One
  • Many

One user might obtain 1 row at one time. This functionality is supported by the cursor.
Pointer and cursor are same which are present in a file that consists of many rows of the result set. Rows track is maintained by the pointer, which are accessible by the program. All rows top to bottom access is supported by a cursor, in a result set. It can further be used for sake of iterative processing. Automatically, a cursor is made with result set.

New capabilities are added by earlier JDBC API for result cursor set which allows it to move backward or forward. It also permits it to move to one specific row, whose position is relative to other one.

Submit "Result Sets and Cursors" to Facebook Submit "Result Sets and Cursors" to Digg Submit "Result Sets and Cursors" to Submit "Result Sets and Cursors" to StumbleUpon Submit "Result Sets and Cursors" to Google