trjhtr

I wrote a chat program in Java/MySQL and did the refreshing part of the chat frame with this code:

//Thats the connecting part and reading out of the consisting data base
sq = new sqlCom("db4free.net","3306");
 ResultSet r = sq.executeQuery("select * from chat where chat.sichtbar = 1");
 i = 0;
 try
 while(r.next())
 jTextArea1.append(r.getString("chat.users")+" : "+r.getString("chat.kommentar")+"n");
 i++;
 
 
 catch(Exception e)
 System.out.println(e);
 
//Here does the "refreshing" starts 
 Thread th = new Thread()
 public void run()
 while(sq.isConnected())
 ResultSet r = sq.executeQuery("select * from chat where chat.sichtbar = 1");
 for(int x = 0 ;x<i;x++)
 try
 r.next();
 
 catch(Exception e)
 System.out.println(e);
 
 
 try
 while(r.next())
 jTextArea1.append(r.getString("chat.users")+" : "+r.getString("chat.kommentar")+"n");
 i++;
 
 
 catch(Exception e)
 System.out.println(e);
 
 
 
 ;
 th.start();
}

I am pretty sure this isn't a good way of doing this. I already had the idea of doing this with an observer where it sends a signal to the other clients to refresh. So I wanted to ask if this, how I did it, is a way of doing it or if I have to change something.