Thread: java code for Next button

hay
i am new in java world, please guide me , i have made a phone directory and i have also maintained a database for this. i want on clicking the next button each row from database table display one by one on the GUI into their relevant text Fields. i have written this code , this code show the last row of the table on single click on next button. i want one by one row on each next button click. please if u provide me little bit solution

private void next_contactActionPerformed(java.awt.event.ActionE vent evt) {

try{
String Url = "Jdbc:OdbcirDSN";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(Url,"sa","mysql");

String sql = "SELECT * FROM PersonInformation";
PreparedStatement pstmt = con.prepareStatement(sql,
ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR _UPDATABLE);
ResultSet rs = pstmt.executeQuery();

while(rs.next())

{

String name = rs.getString("First_Name");
String lName = rs.getString("Last_Name");
String add = rs.getString ("Address");
String em = rs.getString("Email_Id");
String cell = rs.getString("cell#");
jTextField2.setText(name);
jTextField3.setText(lName);
jTextField4.setText(add);
jTextField5.setText(em);
jTextField10.setText(cell);


}
con.close();
}

catch(Exception sqlEx)
{

System.out.println(sqlEx);


}
finally{

}


}

i facing this trouble , when i click the next button , i want each time new record from the phone directory and display into text fields ,but now i am getting only the last record, and can click the next button only one time

please tell me how i save the state of next button. so that when i click it 2nd time or so on, it behave according to that and give me row 2nd , 3rd and so on

--- Update ---

i have also tried rs.next() ,it gives the first record of phone directory on single next click. but when i click the next button , it does not work for 2nd or third row on each click

ScreenShot006.jpg
this is GUi, here is next button , that when i click , it fetches the row from table,and display on text fields. so problem is only with next button. i want each time on single click on next fetches the row from table and display on text fields , so for this i have written the above mention code.
so now when i click the next button i get the only last row from the table into text fields and when i use rs.next() instead of while(rs.next())i get only first row.

kevinworkman you have said"you either need to save your results to an ArrayList" how i maintain this ArrayList for this, and how it will work?

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.

Please post your code correctly per the above link.