Database Batch Query Processor — An old project from archives

Java swing had always been an interesting framework for me!

While going through laptop’s archives just found an old code which was created for my old team in order to check different tables data counts quickly [As there had lots of queries to execute] before and after some process.

Take a look at some screens :), Its always feel funny while looking at your old work/code!

DB Batch Query Processor

Step 1 : We need to connect to the db providing the credentials

Step 2 : Provide the batch query excel [Ignore the dummy queries, used to provide 50–60 queries]

After ‘Process Query’ Result : Execute each db queries and get the counts and write in the next column

Step 3 : Made it an executable JAR in order to run multiple machine

Here is the code of the tool, hope this helps somebody :)

Run the below class.