Thread: running script in Postgres via JDBC

Hi,
I have a spatial database in Postgres/PostGIS and SQL queries developed to manipulate the data. Now I want to build a GUI (user interface) with help of JAVA, JAI on NetBeans. I would like to know if there is a way to access and manipulate data in Postgres database using already developed SQL queries without having to code the queries in java. Simply call the query and run it in database via JDBC.

Thanks
Varu

Originally Posted by copeg

By script, are you referring to a stored procedure? If so, see Using Stored Procedures (The Java™ Tutorials > JDBC(TM) Database Access > JDBC Basics) If not, then please elaborate.

Actually I am working on postgres database and as such i do not have stored procedures. I have stored .sql files which contain predefined functions provided in postgres/PostGIS. So I do not want to create SQL query in java. I want to access these .sql files and run them in postgres on a button click from GUI developed on java (using NetBeans).

Hi copeg,
Yes thts exactly what i wish to do, but dont know how to do, rather dont knw how to code tht in java. Kindly help.

--- Update ---

Originally Posted by Norm

Are you asking about writing a java program that will create a commandline:
"command filename" to execute?
The program(command) will execute in its own process.

ya something to tht effect, but not write the whole query in java. Instead use prebuilt queries stored in .sql files.

"I have to develop a user friendly information tool that uses raster and vector database. For my SQLs developed using Postgres/Postgis I would like to have a GUI that would run them on a user click of button, rather than the user have to type whole SQL commands. How do I develop and link the GUI which would run the SQLs at the back end ? "