fetch data at a given record

[Faiz Abdelhafid]

Hello,

what I should use with the Result Set, in order to obtain just the first record or any other record.

Thanks

[Faiz Abdelhafid]

Problem solved.

Thanks

[Peter Johnson]

Faiz, while it is good that you solved your problem, it would have been better if you posted the solution for the benefit of Ranchers who will run into this problem in the future.

[Faiz Abdelhafid]

Peter Johnson wrote:Faiz, while it is good that you solved your problem, it would have been better if you posted the solution for the benefit of Ranchers who will run into this problem in the future.

Dear Peter,

No problem !


well I was looking for a method to use with the Result Set in order to fetch records in a given order inside a Thread. The exercise is to refresh a text string every 45 sec from the database.

you can use "absolute" method to move the cursor used to fetch data to any given record inside the table.

here is the code:

   

 public void selectResult (String ssn, int index){

         String preQuery = "SELECT * FROM shares WHERE ssn=?";

            try{




            con = DBManager.openDBConnection();


            pstmt = con.prepareStatement(preQuery);
            pstmt.setString(1, ssn);
            rs = pstmt.executeQuery();
        
            
                System.out.println(rs.absolute(index));

               System.out.println("ssn: "+rs.getString(1)+" name: "+rs.getString(2)+" address: "+rs.getString(3));

            

            }catch(Exception e){

                e.printStackTrace();

            }
    }



 

Hope this will help

[Peter Johnson]

This might not be the best approach. The call to PreparedStatement.execute() might actually retrieve a number of records from the database and buffer them, at which point you ask for only one record. This wastes the database's time and network bandwidth. Most databases provide SQL syntax to limit the results return for a query - you would be better off using such a mechanism. One caveat though - the SQL mechanism is not database independent.