swing / mysql / jdbc search question

[keith smith]

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 at asu.edu
Subject: Re: swing / mysql / jdbc search question
To: Main PLUG discussion list <plug-discuss at lists.plug.phoenix.az.us>
Message-ID: <Pine.GSO.4.21.0601301408190.9929-100000 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.plug.phoenix.az.us/pipermail/plug-discuss/attachments/20060205/5b45a94e/attachment.htm