Chapter 16 Flashcards
1
Q
Can we manipulate result set and then update database from it
A
Yes
2
Q
rs.getString(“name”) do what ?
A
rs = result set getString = get value from the column of record set in string data type name = any column name in record set
3
Q
rs.absolute(4) do what
A
Result sets jumps directly row 4
4
Q
rs.absolute(-9) do what
A
Result sets starts from end of it and go reverse back to 9th row.
5
Q
is update methods overloaded
A
Yes
6
Q
What updateRow() method do
A
It updates underlying database from resultset
7
Q
What is insert row
A
There is a special memory buffer in result set where we can add new row in it. Then it inserts newly added row to the underlying database. So insert row insert at record set and database table in one go.
8
Q
What last() and first() do
A
It takes to the last or first of ResultSet object
9
Q
How to get current row number
A
getRow()
