Re: swing / mysql / jdbc search question

Hi Bryan,

I have not gotten an answer yet. I think to make this clearer would be -

How do I bind a Swing component to MySql? I know this can be done in NetBeans.
What I was looking for is code examples so I can do this by hand to learn.

I have dropped this for now. I am working on the Java Cert and then I will get back to this.

Thanks a bunch,
Keith


Message: 2
Date: Mon, 30 Jan 2006 14:09:57 -0700 (MST)
From: Bryan.ONeal@asu.edu
Subject: Re: swing / mysql / jdbc search question
To: Main PLUG discussion list <plug-discuss@lists.plug.phoenix.az.us>
Message-ID: <Pine.GSO.4.21.0601301408190.9929-100000@general1.asu.edu>
Content-Type: TEXT/PLAIN; charset=X-UNKNOWN

Have you recived your answer yet?
I would use the latest version of MySQL and do a subquery; however you
could
also just read in the result set, create objects from it, and then sort
those
object into an array (or vector) for display.

On Tue, 10 Jan 2006, 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
>
>
>
> ---------------------------------
> Yahoo! Photos – Showcase holiday pictures in hardcover
> Photo Books. You design it and we’ll bind it!



------------------------------



            
---------------------------------
Yahoo! Mail - Helps protect you from nasty viruses.---------------------------------------------------
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