How to make each SQL query is a thread?

Question

I'm writing a program in Java GUI. I have a main JFrame from which released with SQL queries buttons and also a JFrame with gif. For SQL queries, I've created a class that provides connection to the database and has a method for each type of query. The fact is that while doing the query, the new JFrame with gif freezes. I know that is because the query is not a Thread. But inherit from Thread is not the solution at all.

I want every method of consultation is like a Thread. To also be able to launch it from anywhere in the main JFrame JFrame without any freezing.

Thank you very much.

This should be a good start: stackoverflow.com/questions/1531073/… — AhDev
– AhDev, Commented Mar 14, 2014 at 12:45
I understand what the connection pool. But that does not solve my problem. thanks — York Xtrem
– York Xtrem, Commented Mar 14, 2014 at 12:51

piet.t · Accepted Answer · 2014-03-14 12:56:19Z

1

Since your application is using swing you should take a look at the SwingWorker class that is designed just for jobs like that.

While you're about it take your time to study the swing threading model, e.g. starting from here.

answered Mar 14, 2014 at 12:56

piet.t

11.9k21 gold badges45 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

York Xtrem Over a year ago

Thanks, I will look: swing threading model and SwingWorker. Let's see if I find solution.

York Xtrem · Accepted Answer · 2014-03-28 10:27:57Z

0

Solution: Use SwingWorker - DoInBackground () Make check here. - Done () Ask here showing a JTable.

answered Mar 28, 2014 at 10:27

York Xtrem

581 silver badge11 bronze badges

Collectives™ on Stack Overflow

How to make each SQL query is a thread?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related