Basics Of Controlling A Thread That Selects Data From MySQL

Lets say I am selecting a record at a time from mysql.

String sql = "SELECT id, first, last, age FROM Registration";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
int id = rs.getInt("id");

[Code] ....

The code above selects the data that i need.Now,i want to have this in some sort of a thread.This is what i want to achieve.

The code displays a record a time,i want to introduce sleep for 10 seconds before displaying the next record.Before going to the next record,i want the program to check whether a condition is true such as the value of a field of a table being 1 or 0.

If the condition is not true(therefore is false),i want the program to display 'waiting.....' and should continue waiting until the condition is true.