This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Need urgent help with ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Need urgent help with ResultSet" Watch "Need urgent help with ResultSet" New topic
Author

Need urgent help with ResultSet

Othmar Stehlik
Ranch Hand

Joined: Jul 24, 2001
Posts: 36
Hi
I have a servlet, that inserts parameters in a database.
Its a kind of guestbook, I Select the entreis from the table and want to print them out, an entry, an HR, the next entry.
Here�s a code snippet:
Vector entries = new Vector();
entries.add(rs;
rs.executeQuery("SELECT name FROM actor");
for(int i=0; i<entries.size(); i++){>
while(rs.next(){
out.println(name)
}
}

The problem is, that I don�t know, how to get every entry, and after the entry a HR printed.
I tried different way, but nothing worked.
Perhaps, there is a method to count the number of entries, and use this in a for loop?
I really appreciate any suggestion!
Othmar
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

http://java.sun.com/docs/books/tutorial/jdbc/basics/retrieving.html
I can't make any sense of your code snippet! This leads me to believe that you might want to look at the tutorial. It has the information you were asking for as well.
Jamie
 
Have you checked out Aspose?
 
subject: Need urgent help with ResultSet
 
It's not a secret anymore!