Re: swing / mysql / jdbc search question

How about simplifying it by requerying the database with the added condition
of what you want to search for?

On 1/11/06, Mike <stuff@dustsmoke.com> wrote:
>
> 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
> ---------------------------------------------------
> 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
>
---------------------------------------------------
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