Chapter 16 Flashcards

1
Q

Can we manipulate result set and then update database from it

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

rs.absolute(4) do what

A

Result sets jumps directly row 4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

rs.absolute(-9) do what

A

Result sets starts from end of it and go reverse back to 9th row.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

is update methods overloaded

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What updateRow() method do

A

It updates underlying database from resultset

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What last() and first() do

A

It takes to the last or first of ResultSet object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How to get current row number

A

getRow()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly