Dear Friends,

I'm using JDBC-Thin Driver to connect with Oracle, so is it possible that I can find a particular record by using ResultSet Object. For Example, I want to serach a record of student bearing registration # 45, so can I move the resultset cursor directly to 45. Please note that I also using the same resultset object as a scrolling one, mean I can move forward and backward too.

Looking forward to your reply..

Thankyou in advance

use a proper select statement..

like ;

select record from table where registration=45

If you want the single row output use HAVING or WHERE clause to the SQL
"Don't forget to move to hasNext()"
as mentioned above.

otherwise
get the resultset :: rs = executeQuery("Select * Student");

put in loop till u find the reg# = 45
while (rs.next()){
   if (#==45)
.
.
.
}