aspose file tools*
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 Java 8 in Action this week in the Java 8 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
Author

How to display all the results of a Table?

Jan Michael Soan
Ranch Hand

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

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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to display all the results of a Table?
 
Similar Threads
More Simplified version of the question bellow !
problem with resultset in reference with my previous post
Value returned from a select tag
Problem in viewing records ?
problem while reading data from excel sheet