public static void GetTasksFromDB() { try { // zrobic zeby zwrocil to albo dodal do listy bezposrednio i oznaczyl ze odczytane. moze // usunac bezposrednio zeby nie wadzily? // System.out.println("# Bufor pusty. Odpytywanie bazy danych..."); String selectedBy = Konfiguracja.getDeviceComPort(); // markowanie zadan w bazie. onzacza ze zadania beda wykonywane przez dana instancje // programu(urzadzenie) String updateQuery = "update sms.tasks set selected_by = '" + selectedBy + "' where id_task in (select id_task from(select id_task, send_time FROM sms.tasks where (selected_by is null OR selected_by = '') AND send_time <= now() order by send_time asc limit 5)as t);"; dba.updateDataBase(updateQuery); // String selectQuery = "SELECT id_task, phone_number, message, send_time FROM sms.tasks where // selected_by = '"+selectedBy+"' order by send_time"; String selectQuery = "SELECT id_task, phone_number, message, send_time, selected_by FROM sms.tasks where selected_by = '" + selectedBy + "' AND send_time <= now() order by send_time"; // dba.readDataBase("SELECT phone_number, message, sender, send_time FROM sms.tasks order by // send_time asc limit 5"); dba.readDataBase(selectQuery); } catch (Exception ex) { Logger.getLogger(BuforZadan.class.getName()).log(Level.SEVERE, null, ex); } }