Urgent-Imp-Displaying message with respect to system time

[garinapavan]

I have a table (TimeTable) in database and column name is Current time:

Table Name: TimeTable


TimeTable
CurrentTime

03.00.00.000000 AM
04.00.00.000000 AM
05.00.00.000000 AM
10.00.00.000000 AM
12.00.00.000000 PM



Now My java Program should do the following:

Reading the data from the database.

And Now pick up the time from table and when the time matches with the system time
it need to trigger or dispaly a message "Hello".This should happen with all the records
in the table with respect to their time.

If i take the above database table as example:

At 3'o clock it has to display "Hello" and again 4'o clock
again it has dispaly "Hello". Like this it has to happen for the rest of the
rows also.

Provide me the answers for the below questions



1)Help me with this kind of code where i can schedule and trigger the message for display.
2) The Program should run always and it should look up the system time and
display the message when ever the time occurs.





Pavan

[levent]

You can access your database table with JDBC.

When you initially launched your program, it will get the nearest alarm time from table and remove it from the table. You will start a timer to launch a specific event at the fetched alarm time. And after that timer is executed, you will fetch the next alarm time from database and restart a timer.

For timer functionality, check Timer class in Java SE.