aspose file tools*
The moose likes JDBC 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
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
 
 
subject: Need urgent help with ResultSet