about Cursor
- The Cursor is a collection of each row.
- Use Movetofirst () to locate the first row.
- You must know the name of each column.
- You must know the data type of each column.
- The Cursor is a random data source.
- All data is obtained by subscript.
Important methods for Cursor :
- Close ()
Close cursors, freeing resources
- Copystringtobuffer (int columnindex, chararraybuffer buffer)
Retrieves the text of the requested column in the buffer, storing it
- getColumnCount ()
Returns the total number of all columns
- Getcolumnindex (String columnName)
Returns the name of the specified column if there is no return-1
- Getcolumnindexorthrow (String columnName)
Returns the specified column name from zero, and throws a IllegalArgumentException exception if it does not exist.
- getColumnName (int columnindex)
Returns the column name from the given index
- Getcolumnnames ()
Returns the column name of a string array
- GetCount ()
Returns the number of rows in the cursor
- Movetofirst ()
Move cursor to First line
- Movetolast ()
Move the cursor to the last line
- MoveToNext ()
Move the cursor to the next line
- movetoposition (int position)
Move the cursor to an absolute position
- Movetoprevious ()
Move cursor to previous line
Cursor Positioning: Cursor class