Women in Technology

Hear us Roar



Article:
  Getting Up To Date with JDBC API
Subject:   Scrolling through Resultset
Date:   2006-05-17 10:24:21
From:   pandu345
Hi,


Here is my requrement,I have a table(username,requestdate,createdate).I want to make a report where I give user his department and some other details from different places and reauest dates and create dates.Now I am running a query for each user once to get his dates,I wanted to use a scrollable resultset,where I query database only once and use this result set each time instead of running a query every time.But my users are not ordered,initially I want dates of user 'arun' , then I need dates of user 'manick' etc.For this purpose how can I scroll the result.


Thanks,
Pandu