Pls I’m having a problem getting result set rows from database to display in a new frame/panel . I have created a loop

for(I=0; I<rs.getString(); i++)//Or maybe
while rs.next();{
//Statement code
}


But there seems to be some error as the button is not responding to the action event .

The query statement using prepared statement is
pst=con.preparedStatement(“select * from ticketing where Urgency=?”)
pst.executeQuery();

/*ticketing is the name of the table where the query is searching from the database */

Please is the error coming frm the query or the loop through the resultSet?

Thanks

sweetguy10:
Pls I’m having a problem getting result set rows from database to display in a new frame/panel . I have created a loop

for(I=0; I<rs.getString(); i++)//Or maybe
while rs.next();{
//Statement code
}


But there seems to be some error as the button is not responding to the action event .

The query statement using prepared statement is
pst=con.preparedStatement(“select * from ticketing where Urgency=?”)
pst.executeQuery();

/*ticketing is the name of the table where the query is searching from the database */

Please is the error coming frm the query or the loop through the resultSet?

Thanks

No idea if you are referring to Swing, Android or JavaFX, sorry which is it ? But since you mentioned frame and panel I will assume swing, did you implement the ActionListener and provided the action performed method and check the event and the control if its your button.

pcguru1:


No idea if you are referring to Swing, Android or JavaFX, sorry which is it ? But since you mentioned frame and panel I will assume swing, did you implement the ActionListener and provided the action performed method and check the event and the control if its your button.

Yes it’s on Swing .. i’ll check the action performed again and even paste the code here .. thanks

sweetguy10:


Yes it’s on Swing .. i’ll check the action performed again and even paste the code here .. thanks

How are you building your GUI, by hand or Netbeans ?

pcguru1:


How are you building your GUI, by hand or Netbeans ?

Netbeans

sweetguy10:


Yes it’s on Swing .. i’ll check the action performed again and even paste the code here .. thanks

Use an online code editor and link here, its stressful reading code here.