Where is the cursor after we execute a query with statement ?

[raminaa niilian]

Hi
Thank you for reading my post.
imagine that you execute a query with stetement something like

ResultSet rs=st.executeQuery("select * from table1");

where is cursor of rs now ?
is it in first , is yes does first means first record or it is before first record ?

Thank you
[ January 30, 2006: Message edited by: raminaa niilian ]

[Thara Visu]

I believe its before the first record.
You need to traverse to the first record using rs.next() to get to the first record.

[chirs blr]

its before the first record
ypu have to move it to first

[Jeff Albertson]

... so the typical loop that precesses a result set looks like:

while(rs.next()) {
    String s = rs.getString("...");
   ...
}

... rather than some freaky do/while loop to test at the loop's bottom!