swing / mysql / jdbc search question

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


        
---------------------------------
Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss