Thread: Help in GUI development

I have a set of complex SQLs which generate information from the various spatial and non-spatial layers. The database is Postgres 9.2 with PostGIS on Windows 7 O/s. I would like to package the SQLs into a GUI based entity rather than the user having to type out at command line. In short, press a button and at backend, a set of SQLs will run in Postgres and generate the information - mostly the output is a jpg file. How do I start and what are the tools i need? Thanx in advance.

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.

Originally Posted by copeg

You can start with these tutorials:
Trail: Creating a GUI With JFC/Swing (The Java™ Tutorials)
Trail: JDBC(TM) Database Access (The Java™ Tutorials)
Lesson: Working with Images (The Java™ Tutorials > 2D Graphics)

Looked at all of these. But could not get an answer. Kindly note that i need to develop a GUI which would run complex SQLs in Postgres. Currently the SQLs are run from command line / PGAdmin.

Thank you for your reply. Here is my problem dissected.

1. I use remote sensing images along with ancillary data like rainfall, temperature, vegetation map etc.
2. The various layers are accessed by SQLs (entered as long commands) currently and outputs are generated as text files / tables / images (jpg format).
3. Sometimes there can be conditional statements
e.g. if the rainfall is within a range (user defined) and under a particular vector (administrative unit), then vegetation could be of some type.
4. Currently I am using Postgres as database to store images, ancillary data and running SQLs and PostGIS to handle raster and vector data.
5. If the tool has to be handed over to someone who has minimal idea of writing SQLs, one cannot derive any useful information from the data.
6. It is planned to build multiple scenarios for the data and give to the user a GUI.
7. By clicking the GUI, at the backend a SQL will be executed and user gets the output.
e.g. a button on GUI would be <Get NDVI> This would run an appropriate SQL at the backend and return the value to the user.
if another button is <Generate Map> The appropriate SQL would be executed (can have conditional and/or nested statements) and user would have an output image.

Yes, JDBC is connected. I also attempted at writing the SQLs into java code. This works for simple SQLs (one line statements), but not for nested / conditional SQLs. Swing does help in GUI development, but how do we execute the SQLs. Rather how do we attach buttons on the GUI with the SQLs so that they execute smoothly.

I hope I am clear now.