File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes How to display all the results of a Table? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to display all the results of a Table?" Watch "How to display all the results of a Table?" New topic

How to display all the results of a Table?

Jan Michael Soan
Ranch Hand

Joined: Feb 08, 2003
Posts: 36
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);;
// 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

Joined: Dec 10, 2001
Posts: 7023
(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.Getting any ideas?
[ March 16, 2003: Message edited by: Dirk Schreckmann ]

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
It is sorta covered in the JavaRanch Style Guide.
subject: How to display all the results of a Table?
Similar Threads
Problem in viewing records ?
More Simplified version of the question bellow !
problem with resultset in reference with my previous post
Value returned from a select tag
problem while reading data from excel sheet