CODEWITHSUNDEEP
javamysqlprogress-bar
Muhammad Haryadi Futra Iskanda
Muhammad Haryadi Futra Iskanda

Reputation: 105

How to run progress bar while executing the mysql query in java?

I want to delete duplicate record in my database table, and I do it in java by using this query

String sql = "DELETE e1 FROM tweet_after_preprocessing e1, tweet_after_preprocessing e2 WHERE e1.tweet = e2.tweet AND e1.tweet_after_preprocessing_id > e2.tweet_after_preprocessing_id"

The problem is when there are so many records in my database table, the process will take so long, and make my program look not curently running.

and I want to use progress bar to show progress of the executing, how can I do that?. I don't now the maximum and the minimum value, so how can i accessing the progress bar?.

Upvotes: 2

Views: 2500

Answers (3)

Jose Martinez
Jose Martinez

Reputation: 12022

Excellent question.

Jenkins uses the time of the last build to guess how long the current build will take to run. So for example if the last time a build ran it took 10 minutes, and it is 5 minutes into a current build it will show that it is 50% complete.

You can do something similar. Maybe query the DB first to see how many items need to be deleted and have a table of how long it will take for the amount of items being deleted and how many items are in the table.

Upvotes: 0

Uwe Plonus
Uwe Plonus

Reputation: 9974

You can create an indeterminate progress bar by setting the property indeterminate to true: JProgressBar.html#setIndeterminate().

Also it is wise to not execute long lasting work in the EDT but use a different thread for this.

Upvotes: 2

Kevin Workman
Kevin Workman

Reputation: 42174

The problem is that you're doing all your work on the EDT, which is blocking your GUI. You need to do the loading on another Thread, so your GUI can still update, display, and respond to user input.

Once you have the work on another thread, then from that thread, you can post updates to the EDT using the SwingUtilities.invokeLater() method.

You could also look into the SwingWorker class, which handles some of that for you.

Recommended reading: http://docs.oracle.com/javase/tutorial/uiswing/concurrency/

Upvotes: 1

Related Questions