Take last table value from bank and show in Jtextfield

Question

I have a program here at the factory that, every 1 minute, an equipment connected to a supervisory launches a direct value in a table in the database (SQL Server).

I wonder how do I always take the last value and show in a JTextField, and every minute he tries to make that query.

In case, this code suits me perfectly, but my doubt now how do I get the last database value that in the case would be (SQL Server).

    int delay = 5000;   // delay de 5 seg.
    int interval = 5000;  // intervalo de 1 seg.
    Timer timer = new Timer();

    timer.scheduleAtFixedRate(new TimerTask() {
        public void run() {
          jTextField6.setText("1");
        }
    }, delay, interval);
}

Answer 1

If using the class java.util.Timer, make sure that the component is updated within the EDT, because this Thread is the one who should be solely responsible for managing swing API components:

int delay = 5000;   // delay de 5 seg.
int interval = 5000;  // intervalo de 1 seg.
Timer timer = new Timer();

timer.scheduleAtFixedRate(new TimerTask() {
    public void run() {
      SwingUtilities.InvokeLater(()-> jTextField6.setText("1"));
    }
}, delay, interval);

Remembering that the time is 1 minute, the interval needs to be 60*1000 because the argument that the method scheduleFixedRate() awaits both the delay (delay for first execution) how much the interval(time between repetitions) in milliseconds.

As for the search in the table, from what I understand you want to seek the last result inserted in the table, you probably need to adapt to query down within the TimerTask, returning the field only of the last row of the table:

SELECT TOP 1 * FROM <tabela> ORDER BY <campo a ser ordenado> DESC