RE: java code help...

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I added the 'a' for a reason, i'm trying to figure out how to qulaify the
field name to a praticular table...


> -----Original Message-----
> From: Clapham, Paul [SMTP:pclapham@core-mark.com]
> Sent: Thursday, November 15, 2001 1:48 PM
> To:   java400-l@midrange.com
> Subject:      RE: java code help...
>
> Question #1: the actual field name is probably "CUSNUM" and not
> "A.CUSNUM".
>
> Question #2: if you want to use Java to display data in tabular format on
> your PC screen, then you probably want to use a JTable from the Swing
> components.  But it would take much more than a few minutes to explain
> that,
> so I'll just point you towards a tutorial on that subject:
> http://java.sun.com/docs/books/tutorial/uiswing/components/table.html
>
> PC2
>
> -----Original Message-----
> From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
> Sent: November 15, 2001 12:56
> To: 'java400-l@midrange.com'
> Subject: java code help...
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> I'm really trying to understand java, and right now, all I have are 2
> examples, that I found out on the net...
> And I got them to compile and run, on the PC, using the 400 toolbox jar..
>
> I was wondering if someone could hold my hand for a few minutes, and offer
> me a great big push in the right direction...
>
> Question #1.  I have this code, and I have modified it, so I could attempt
> to qualify the field names...  But it didn't work... Could someone please
> correct my error.
>
> ERROR Message at runtime: An undefined column name was detected.
>
>     ResultSet rs = stmt.executeQuery ("SELECT * FROM QIWS.QCUSTCDT A ORDER
> BY LSTNAM");
>       while (rs.next ()) {
>               String cusnum = rs.getString("A.CUSNUM");
>
> Question #2,  Could someone please show me how to take the result set that
> I
> get, and instead of printing it in a dos window, how would I place the
> data
> in a real window on my pc, in a datasheet type view (similar to excel, or
> when I do an SQL through ops nav)...
>
> I offer many thanks,  tim...
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.