RE: How do you select from a JTable?

[Pete Hall <peteh@xxxxxxxxxx>]

At 00:02 10/24/1998 , Chris Jewell wrote:
>There's also a paucity of examples of this very common requirement shipped
>with VisualAge. So, all in all, I'm a little disappointed.

Chris,

There's an example project at 
http://www7.software.ibm.com/vad.nsf/Data/Document2550 called "VADD - VisualAge 
for Java Version 2 Tutorial -- Part 2: Data Access Beans" that I used to get 
started. It uses DB2, which I don't have installed at home, nor do I have 
access to my AS/400 from here, so I used the example as a guide and connected 
to an Access 2.0 database on my PC just for grins. Outside of the fact that the 
SQL syntax is a little different (mainly || doesn't work for concatenations), I 
was able to figure it out fairly easily. The only place that the instructions 
really fall down is explaining how to specify the URL for the connection 
object. For the JDBC-ODBC bridge, it's jdbc:odbc:dataSourceName. Like I said in 
my original post, this worked very well, but once I had data in the JTable, I 
couldn't figure out how to select a row and use it to do an additional select, 
which would obviously be a very necessary thing for a real application. The 
example was apparently written to avoid this functionality. I thought at the 
time it seemed a little contrived, and I'm beginning to think there may have 
been a reason...



Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---