How to display all the results of a Table?

[Jan Michael Soan]

Hello;
I have a problem displaying all the results of a Table from my database. My purpose is to display all the results of the table to My given JTextFields.
for example :
Statement statement1 = connect.createStatement();
String query1 = "SELECT FROM Lastname";

ResultSet rs1 = statement1.executeQuery(query1);
rs1.next();
// here's the problem. I don't know how to get all the results
// what I know is to display only the 1st string.
// is there any method to display all the results of a table.
// instead of displaying only the 1st String?
String pass1 = "" + rs1.getString(1);
x's: Pls. help its an emergency !.
Thanks . . .

[Dirk Schreckmann]

(I'm perhaps not completely understanding your question.)
If I've a table called student that has fields fName and lName, and I want to display the name of everybody in the table, then I might use code similar to the following.

ResultSet rs = statement.executeQuery( "SELECT * FROM student" );
 
while ( rs.next() )
{
  System.out.println( rs.getString( "fName" ) + " " + rs.getString( "lName" ) );
}

Getting any ideas?
[ March 16, 2003: Message edited by: Dirk Schreckmann ]