How to manipulate records in database?

in my application , i handle records in my database, i have 4 buttons as first next previous and last

So to get them used, wat i shud do?

RS.next?

Its nt working, i hink theres something wrong

can you tell me how i should proceed?

Thank youuu

String Pno=jTextField9.getText();

Statement stmt = connection.createStatement();

String query ="SELECT * FROM fiche where No='"+Pno+"'";

ResultSet RS = stmt.executeQuery(query);

RS.next();

while(RS.next())

{

jTextField1.setText(RS.getString(2));

jTextField2.setText(RS.getString(3));

jTextField3.setText(RS.getString(4));

jTextField4.setText(RS.getString(5));

jTextField5.setText(RS.getString(6));

jTextField6.setText(RS.getString(7));

jTextField9.setText(RS.getString(1));

jLabel7.setVisible(false);

jLabel8.setVisible(false);

jTextField7.setVisible(false);

jTextField8.setVisible(false);

}}

[1293 byte] By [roseddeeepssa] at [2007-10-2 14:27:11]