mysql - looping error in java -

when run code, code shows errors. please me fix problem. here java code:

public void kirim(){     try{     koneksi();     string data ="select count(number) pbk";     resultset rs1 = cn.executequery(data);     while (rs1.next()){         rs1.getstring(1);     }     int banyakdata=integer.parseint(rs1.getstring(1));      (int i=0; i<=banyakdata ;i++){     string sqi = "select number pbk";     resultset rs = cn.executequery(sqi);     while(rs.next()){         rs.getstring(sqi);     }               string sql="insert outbox (destinationnumber, textdecoded, creatorid) values ("     + "'"+sqi +"',"     + "'" + jtextarea1.gettext()+ "',"     + "'1'"     + ")";     cn.executeupdate(sql);      } joptionpane.showmessagedialog(null, "pesan terkirim");     }catch (exception e){     joptionpane.showmessagedialog(null, "pesan gagal terkirim");     system.out.println(e.getmessage());     } } 

here stack trace output:

after end of result set 

change code to

resultset rs1 = cn.executequery(data); int banyakdata;     while (rs1.next()){        banyakdata= rs1.getint(1);     } 

and remove

  int banyakdata=integer.parseint(rs1.getstring(1)); 

with approach have iterated through resultset , after completition of while loop again fetching resultset giving error.

and doing rs.getstring(sqi); , rs1.getstring(1); in while loop doesnt make sense if dint put result in variable btw sqi not valid parameter.