JDBC ResultSet Methods Flashcards Preview

OCP > JDBC ResultSet Methods > Flashcards

Flashcards in JDBC ResultSet Methods Deck (17):
1

Sets the cursor just before the first row in the ResultSet

void beforeFirst()

2

Sets the cursor just after the last row in the ResultSet

void afterLast()

3

Sets the cursor to the requested row number absolutely.

boolean absolute(int rowNumber)

4

Sets the cursor to the requested row relatively.

boolean relative(int rowNumber)

5

Sets the cursor to the next row of the ResultSet

boolean next()

6

Sets the cursor to the previous row of the ResultSet

boolean previous()

7

Methods that return value from a column number.

XXX getXXX(int columNumber) where XXX is an object like a String or Double.

8

Methods that return a value from a column name.

XXX getXXX(String columnName) where XXX is an object like a String or Double.

9

Methods that update a value to a column number.

void updateXXX(int columnNumber, XXX x) where XXX is an object like a String or Double.

10

Methods that update a value to a column name.

void updateXXX(String columnName, XXX x) where XXX is an object like a String or Double.

11

Executes a query on a statement object to store in a result set.

executeQuery()

12

The column index in a result set starts at...

1

13

Modifier of result set that only allows the cursor to move forward.

TYPE_FORWARD_ONLY

14

Modifier of result set that lets the cursor move forward, backward, or to any location in the resultset. Changes to the underlying database are not updated to the open resultset.

TYPE_SCROLL_INSENSITIEVE

15

Modifier of result set that lets the cursor move forward, backward, or to any location in the resultset. Changes to the underlying database are updated to the open resultset. This is not supported by most databases as it is very difficult to implement.

TYPE_SCROLL_SENSITIVE

16

Modifier of result set that causes it to be read only.

CONCUR_READ_ONLY

17

Modifier of result set that allows it to be modified.

CONCUR_UPDATABLE