Application for querying the database and sending the results as a file over HTTPS
I currently have a tool that allows me to set up a database connection (using JDBC) and specify a set of queries to work with the database. This is scheduled to run at a specific time of day (using cron or the window scheduler currently). The tool then exports the results to a file (xml) and sends that file to my server over HTTPS. This tool is installed on client computers so that I can get some data feeds from them for later processing.
I would like to write an interface for this so that clients can customize the data extraction themselves. However, I am not very familiar with Rich Client interface design (I am an integration software developer) and wondered if there is an existing tool out there that would do all of this, or if it was worth learning a little Swing so I might knock the interface out. Do you know any of a suitable tool? (I'm looking for a single feature, not a complete suite for extracting and transforming data, which might scare off some customers)
source to share
If your tool already exists and works, I think the best approach would be to just read a little about GUI event programming (it's pretty easy once you understand it and get a nice GUI Builder) and complete a little GUI using the GUI Builder.
For Java, I can recommend the NetBeans IDE and its GUI Builder.
The easiest way for the GUI is to simply pass the received arguments to the existing tool via Runtime.exec () or a similar approach.
source to share
In my opinion, it's pretty easy and quick to make a decent interface using Swing. A Swing tutorial might be a good place to start.
source to share