db2 sql and Java Gui's

Applications Programming
1

Hi Everyone,

I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. Any advise / comments would be highly appreciated. Thanks.  

  DBNAME     AGENT_ID             AUTHID   APPL_NAME                                APPL_STATUS
---------- -------------------- -------- ---------------------------------------- -----------
T01KATD1                  58105 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57822 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58315 TKUCOM1 db2jccORB.thread.poo                     UOWWAIT
T01KATD1                  58282 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57157 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58374 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58216 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58012 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  57887 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58229 TKULAN1 db2jcc_application                       UOWWAIT
T01KATD1                  57854 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58130 TKULAN1 db2jcc_application                       UOWWAIT
T01KATD1                  58222 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58268 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58294 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58228 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  58024 TKUPMR1 db2jcc_application                       UOWWAIT
T01KATD1                  58366 TKUGOM1 db2jcc_application                       UOWWAIT
T01KATD1                  42333  KDAV   QuestCentral.exe                         UOWWAIT
T01KATD1                  58300 TKUPMR1 db2jcc_application                       UOWWAIT
2

Well, the traditional method would be to use JDBC to connect to and fetch data from DB2, and use Swing to display it in the tabular format.

A more modern approach would be to use Java FX for the GUI part. Java FX is for RIAs; it is Sun's answer to Adobe's Flash/Flex and Microsoft's SilverLight. I am not very clear about the DB connectivity part. You could, of course, still use your JDBC code base with Java FX. But I believe it has inbuilt features for database connectivity. It can atleast interact with Derby quite easily.

tyler_durden