swing / mysql / jdbc search question

[Mike]

keith smith wrote:

> Hi Plug folks,
>  
> I posted a question to the Java Users Group and received limited 
> feedback.
>  
> I know some of you do Java also.
>  
> Any help appreciated.
>  
> I am writing a simple swing/mysql/jdbc form that has previous, next, 
> add, save, edit, del, exit buttons.
>  
> The resultset is People and next, previous, add, save (update) , 
> delete, and exit button code work ok.
>  
> The problem I am having difficulty with is doing a search, example:
>  
> Say I have a MySql table with 1000 records in my resultset. I want to 
> "order" it by phone number which is not unique. I need to find a phone 
> number within that resultset which say is at record 700. (this is a 
> swing desktop application)
>  
> How do I do the search within this resultset?
>  
> Thanks a bunch,
>  
> Keith
>
>
Can't you just run through it with next() and match the string?

-Mike