How can I refresh a view every second to reflect changes in real time?

I'm writing an app for a manager to keep track of the goings-on of a factory that uses machines. Could I make a Swing interface that updates from an SQL database and constantly shows who is logged into each machine, the status of each machine and 开发者_StackOverflow中文版how many things are in the queue of each machine? All the machine info is in the database.

In short, how can I refresh a view every second so that it will reflect the real-time status of the factory floor?

---

Using the Java timer class at 1000 milliseconds and querying the mysql database. Provided your db latency is low, you should be able to update 1/second.

---

Or use a ScheduledExecutorService