swing - Java -How to implement code into GUI made in Netbeans gui builder? -

i made gui using netbeans gui builder , looks great! however, i've got no idea how go implementing code change values inside of gui.

my program connects database , pulls information such sex, room number, bed number, name , referral source each individual patient. purpose of gui represent changes information every often, want automatically sync database every 60 seconds or so. can write code database sync , i've made gui.

question how update information displayed in gui made in netbeans?

public class connectmssqlserver {  static int bedcount;  public static int getbedcount(){       return bedcount;  }  public void setbedcount(int number){     bedcount = number;  } public void dbconnect(string db_connect_string, string db_userid, string db_password) {     try {         class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver");         connection conn = drivermanager.getconnection(db_connect_string, db_userid, db_password);         system.out.println("connected");         statement statement = conn.createstatement();         string querystring = "select f2 beds.dbo.sheet1$";         string querystring1 = "select f3 beds.dbo.sheet1$";         string querystring2 = "select f4 beds.dbo.sheet1$";         string querystring3 = "select f5 beds.dbo.sheet1$";         string querystring4 = "select f6 beds.dbo.sheet1$";         string querystring5 = "select f7 beds.dbo.sheet1$";         string querystring6 = "select f8 beds.dbo.sheet1$";         string querystring7 = "select f9 beds.dbo.sheet1$";         string querystring8 = "select f10 beds.dbo.sheet1$";         string querystring9 = "select f11 beds.dbo.sheet1$";         string querystring10 = "select f12 beds.dbo.sheet1$";          list<string> locationlist = new arraylist<string>();         list<string> patientlist = new arraylist<string>();         list<string> refferalllist = new arraylist<string>();         list<string> datelist = new arraylist<string>();         // list<string> locationlist = new arraylist<string>();         // list<string> locationlist = new arraylist<string>();         // list<string> locationlist = new arraylist<string>();         resultset rs = statement.executequery(querystring);          while (rs.next()) {              locationlist.add(rs.getstring(1));             locationlist.removeall(collections.singleton(null));          }         resultset rs1 = statement.executequery(querystring1);          while (rs1.next()) {              patientlist.add(rs1.getstring(1));             patientlist.removeall(collections.singleton(null));          }          set<string> uniquelocationlist = new hashset<string>(locationlist);         system.out.println(uniquelocationlist);         setbedcount(uniquelocationlist.size());         set<string> uniquepatientlist = new hashset<string>(patientlist);         system.out.println(uniquepatientlist);      } catch (exception e) {         e.printstacktrace();     } }  public static void main(string[] args) {     connectmssqlserver connserver = new connectmssqlserver();     connserver.dbconnect("jdbc:sqlserver://******", "***", "********"); } 

}

so want write code within provided example appends data inside gui. bed1a.seticon(emptyicon); that, don't know how change values of gui code exists outside of it.

• keep controller class, application, boss.
• keep datamodel class, field of controller, data, loaded database used create gui; done controller.
• and there view, jframe, field of controller.

now in gui builder want not repeat (dry principly). room components should list of rooms. after using gui builder adding element, can adapt code arrays/lists.

the controller can set things in jframe: add jframe: addpatient(int room, int bed, string name) , can fetch component list , use ctrl-space elect settext("jane") whatever.

make data classes room, bed, patient.

(use version control.)